Customers

CustomerIDFirstNameLastNameDateOfBirthEmailAddress
1JohnDoe2000-06-13john@example.com
2JaneSmith1987-07-21jane@example.com

Accounts

AccountNumberBalanceInterestRateOpenDateCustomerID
(→ Customers.CustomerID)
10011000.05.02021-06-201
1002500.03.02021-06-202

Transactions

TransactionIDAmountTypeAccountNumberDate
(→ Accounts.AccountNumber)
1500.0Credit10012021-06-20 10:00:00
2-200.0Debit10012021-06-20 11:00:00

Financial_Swaps

SwapIDCurrencySwapInterestRateSwapOtherValueStartDateEndDateBank
(→ Banks.BankName)
1Currency SwapFixed vs FloatingPayment2021-06-202022-06-20Royal Bank
2Currency SwapFloating vs FixedPayment2021-06-202022-06-20Another Bank
3Interest Rate SwapFixed vs FloatingPayment2021-06-202022-06-20Royal Bank
4Interest Rate SwapFloating vs FixedPayment2021-06-202022-06-20Another Bank

Banks

BankNameAddressPhoneNumber
Royal BankNew York, USA+1-212-123-4567
Another BankLondon, UK+44-20-123-4567