Customers
CustomerID | FirstName | LastName | EmailAddress |
1 | John | Doe | john@example.com |
2 | Jane | Smith | jane@example.com |
Accounts
AccountNumber | Balance | OpenDate | CustomerID |
| | | (→ Customers.CustomerID) |
1 | -1000.0 | 2022-01-01 | 1 |
2 | -5000.0 | 2023-06-07 | 2 |
Transactions
TransactionID | Amount | Date | Description | FromAccountNumber | ToAccountNumber |
| | | | (→ Accounts.AccountNumber) | (→ Accounts.AccountNumber) |
1 | 1000.0 | 2022-01-15 | Transfer | 1 | None |
2 | 1500.0 | 2023-06-18 | Deposit | 2 | None |
Financial_Swaps
SwapID | CurrencySwap | InterestRateSwap | OtherValues | FromAccountNumber | ToAccountNumber | Bank |
| | | | (→ Accounts.AccountNumber) | (→ Accounts.AccountNumber) | |
1 | Currency Swap | N/A | Details here | 1 | 2 | Royal Bank |
2 | Currency Swap | N/A | Details here | 1 | 3 | Other Bank |
3 | Interest Rate Swap | N/A | Details here | 2 | 3 | Royal Bank |
4 | Interest Rate Swap | N/A | Details here | 2 | 4 | Other Bank |