Savings_Accounts
AccountID | CustomerName | OpenDate | Balance | Interest_Rate |
1 | John Doe | 2023-01-01 | 1000.0 | 1% |
2 | Jane Smith | 2023-01-01 | 2000.0 | 2% |
Checking_Accounts
AccountID | CustomerName | OpenDate | Balance | OverdraftLimit | Interest_Rate |
1 | John Doe | 2023-01-01 | 500.0 | 250.0 | 1% |
2 | Jane Smith | 2023-01-01 | 750.0 | 350.0 | 2% |
Customers
CustomerID | FirstName | LastName | DateOfBirth | Email |
1 | John | Doe | 1990-01-01 | john.doe@example.com |
2 | Jane | Smith | 1992-01-01 | jane.smith@example.com |
Loans
LoanID | CustomerID | Amount | StartDate | EndDate | Rate |
| (→ Customers.CustomerID) | | | | |
1 | 1 | 5000 | 2023-01-01 | 2026-01-01 | 4.5 |
2 | 2 | 10000 | 2023-01-01 | 2028-01-01 | 4.75 |
Transactions
TransactionID | AccountID | Type | Amount | DateAndTime |
| (→ Savings_Accounts.AccountID) | | | |
1 | 1 | Deposit | 500.0 | 2023-01-01 12:00:00 |
2 | 2 | Withdrawal | 250.0 | 2023-01-01 13:00:00 |