Currency_Swaps

IDSwap_IDAmountDateMaturity_DateCurrencyBank
(→ Banks.Name)
1CS11000000.02023-06-01 10:00:002025-06-01 10:00:00USDRoyal Bank
2CS2800000.02023-07-01 10:00:002024-07-01 10:00:00EURCitibank

Interest_Rate_Swaps

IDSwap_IDFixed_RateFloating_RateStart_DateEnd_DateNotional_AmountBank
(→ Banks.Name)
1IRS13.52.52023-06-01 10:00:002025-06-01 10:00:001000000.0Royal Bank
2IRS24.02.02023-07-01 10:00:002024-07-01 10:00:00900000.0Citibank

Customers

IDNameAddressPhoneEmail
1John Doe123 Main St555-1234john@example.com
2Jane Smith456 Elm St555-5678jane@example.com

Accounts

IDCustomer_IDAccount_NumberBalanceTypeOpening_Date
(→ Customers.ID)
111234567895000.0Checking2022-01-01 10:00:00
2298765432110000.0Savings2022-02-01 10:00:00

Transactions

IDAccount_IDTransaction_TypeAmountTransaction_Date
(→ Accounts.ID)
11Deposit1000.02023-01-01 10:00:00
21Withdrawal500.02023-02-01 10:00:00
32Deposit2000.02023-03-01 10:00:00
42Withdrawal1000.02023-04-01 10:00:00