CustomerID | FirstName | LastName | DateOfBirth |
---|---|---|---|
1 | John | Doe | 1980-06-15 |
2 | Jane | Smith | 1973-08-23 |
AccountNumber | CustomerID | AccountType | OpenDate |
---|---|---|---|
(→ Customers.CustomerID) | |||
1001 | 1 | Checking | 2021-06-01 |
1002 | 1 | Savings | 2021-06-01 |
TransactionID | AccountNumber | Amount | TransactionDate |
---|---|---|---|
(→ Accounts.AccountNumber) | |||
1 | 1001 | -200 | 2021-06-01 08:00:00 |
2 | 1001 | 150 | 2021-06-01 09:00:00 |
FeeID | AccountNumber | Fees | EffectiveFrom | EffectiveTo |
---|---|---|---|---|
(→ Accounts.AccountNumber) | ||||
1001 | 1001 | 2 | 2021-06-01 | 2022-06-01 |
1002 | 1001 | 2.5 | 2022-06-01 | 2023-06-01 |
OverdraftID | AccountNumber | LimitAmount | InterestRate | ApprovalDate |
---|---|---|---|---|
(→ Accounts.AccountNumber) | ||||
1001 | 1001 | 500 | 10 | 2021-06-01 |
1002 | 1001 | 800 | 12 | 2021-06-01 |
LoanID | AccountNumber | PrincipalAmount | RateOfInterest | TenureMonths | StartDate | EndDate | RepaymentMethod |
---|---|---|---|---|---|---|---|
(→ Accounts.AccountNumber) | |||||||
1001 | 1001 | 1000 | 8 | 12 | 2021-06-01 | 2023-06-01 | Equal monthly installments |
1002 | 1001 | 800 | 7 | 18 | 2021-06-01 | 2023-06-01 | Weekly repayments |