Clients

ClientIDFirstNameLastNameDateOfBirthEmailPhoneNumber
1JohnSmith1970-01-01johnsmith@example.com+123456789
2JaneDoe1980-02-02janedoe@example.com+987654321

Accounts

AccountIDClientIDBalance
(→ Clients.ClientID)
115000.0
227000.0

Loans

LoanIDAccountIDPrincipalAmountInterestRateRepaymentTermYears
(→ Accounts.AccountID)
1110000.00.055
2215000.00.0610

Transactions

TransactionIDAccountIDAmountTypeTimestamp
(→ Accounts.AccountID)
11200.0Deposit2022-01-01 10:00:00
21-150.0Withdrawal2022-01-01 11:00:00

_Bank_Cards

CardIDAccountIDCardTypeCard_LimitExpiryDateCVVIsActive
(→ Accounts.AccountID)
11Credit Card10000.02025-12-311231
22Debit Card5000.02024-12-314561
32Credit Card5000.02026-12-317890
42Debit Card7000.02023-12-311350