Customers

CustomerIDFirstNameLastNameEmailAddress
1JohnDoejohn@example.com
2JaneSmithjane@example.com

Accounts

AccountNumberBalanceOpenDateCustomerID
(→ Customers.CustomerID)
1-1000.02022-01-011
2-5000.02023-06-072

Transactions

TransactionIDAmountDateDescriptionFromAccountNumberToAccountNumber
(→ Accounts.AccountNumber)(→ Accounts.AccountNumber)
11000.02022-01-15Transfer1None
21500.02023-06-18Deposit2None

Financial_Swaps

SwapIDCurrencySwapInterestRateSwapOtherValuesFromAccountNumberToAccountNumberBank
(→ Accounts.AccountNumber)(→ Accounts.AccountNumber)
1Currency SwapN/ADetails here12Royal Bank
2Currency SwapN/ADetails here13Other Bank
3Interest Rate SwapN/ADetails here23Royal Bank
4Interest Rate SwapN/ADetails here24Other Bank