Clients
ClientID | FirstName | LastName | DateOfBirth | Email | PhoneNumber |
1 | John | Smith | 1970-01-01 | johnsmith@example.com | +123456789 |
2 | Jane | Doe | 1980-02-02 | janedoe@example.com | +987654321 |
Accounts
AccountID | ClientID | Balance |
| (→ Clients.ClientID) | |
1 | 1 | 5000.0 |
2 | 2 | 7000.0 |
Loans
LoanID | AccountID | PrincipalAmount | InterestRate | RepaymentTermYears |
| (→ Accounts.AccountID) | | | |
1 | 1 | 10000.0 | 0.05 | 5 |
2 | 2 | 15000.0 | 0.06 | 10 |
Transactions
TransactionID | AccountID | Amount | Type | Timestamp |
| (→ Accounts.AccountID) | | | |
1 | 1 | 200.0 | Deposit | 2022-01-01 10:00:00 |
2 | 1 | -150.0 | Withdrawal | 2022-01-01 11:00:00 |
_Bank_Cards
CardID | AccountID | CardType | Card_Limit | ExpiryDate | CVV | IsActive |
| (→ Accounts.AccountID) | | | | | |
1 | 1 | Credit Card | 10000.0 | 2025-12-31 | 123 | 1 |
2 | 2 | Debit Card | 5000.0 | 2024-12-31 | 456 | 1 |
3 | 2 | Credit Card | 5000.0 | 2026-12-31 | 789 | 0 |
4 | 2 | Debit Card | 7000.0 | 2023-12-31 | 135 | 0 |