Central_Banks

idNameCountryYear_FoundedCurrency
1Federal ReserveUSA2014USD
2European Central BankGermany1998Euro

Commercial_Banks

idNameCountryAssetsHeadquarter_City
1CitibankUSA300000000000.0New York
2HSBCUK670000000000.0London

Customers

idFirstNameLastNameDateOfBirthAccountNumber
1JohnSmith1990-01-011234567890
2JaneDoe2000-02-022345678901

Loans

idCustomerIDPrincipalInterestRateStartDateEndDate
(→ Customers.id)
111000004.52022-01-012025-12-31
222000003.02022-01-152025-12-15

SavingsAccounts

idCustomerIDBalanceInterestRateOpeningDate
(→ Customers.id)
1150000.01.52021-01-01
2230000.02.02021-02-01

Transactions

idFromAccountToAccountAmountTransactionTypeDate
(→ SavingsAccounts.id)(→ SavingsAccounts.id)
1125000.0Deposit2024-03-13 18:48:25
212-2500.0Withdrawal2024-03-13 18:48:25