Savings_Accounts

AccountIDCustomerNameOpenDateBalanceInterest_Rate
1John Doe2023-01-011000.01%
2Jane Smith2023-01-012000.02%

Checking_Accounts

AccountIDCustomerNameOpenDateBalanceOverdraftLimitInterest_Rate
1John Doe2023-01-01500.0250.01%
2Jane Smith2023-01-01750.0350.02%

Customers

CustomerIDFirstNameLastNameDateOfBirthEmail
1JohnDoe1990-01-01john.doe@example.com
2JaneSmith1992-01-01jane.smith@example.com

Loans

LoanIDCustomerIDAmountStartDateEndDateRate
(→ Customers.CustomerID)
1150002023-01-012026-01-014.5
22100002023-01-012028-01-014.75

Transactions

TransactionIDAccountIDTypeAmountDateAndTime
(→ Savings_Accounts.AccountID)
11Deposit500.02023-01-01 12:00:00
22Withdrawal250.02023-01-01 13:00:00