MonthlyInterestRates
id | Monthly_Interest_Rate | Bank_Account | Date |
1 | 0.05 | 1834293214 | 2024-03-13 18:39:22 |
2 | 0.06 | 7894512361 | 2024-03-13 18:39:22 |
AnnualPercentageRates
id | Annual_Percentage_Rate | Bank_Account | StartDate | EndDate |
1 | 4.5 | 1834293214 | None | None |
2 | 3.75 | 7894512361 | None | None |
Customers
id | FirstName | LastName | Address | Email | PhoneNumber |
1 | John | Doe | 123 Main St | john.doe@example.com | 555-1234 |
2 | Jane | Smith | 456 Elm St | jane.smith@example.com | 555-5678 |
Transactions
id | Account_ID | Transaction_Type | Amount | Date |
| (→ Customers.id) | | | |
1 | 1 | Deposit | 1000 | 2024-03-13 18:39:22 |
2 | 1 | Withdrawal | 500 | 2024-03-13 18:39:22 |
3 | 2 | Deposit | 2000 | 2024-03-13 18:39:22 |
4 | 2 | Withdrawal | 1000 | 2024-03-13 18:39:22 |
SavingsAccounts
id | Customer_ID | Balance | Interest_Rate | Opening_Date |
| (→ Customers.id) | | | |
1 | 1 | 5000 | 0.05 | 2021-01-01 |
2 | 2 | 3000 | 0.06 | 2021-01-01 |