Customers
CustomerID | FirstName | LastName | EmailAddress | PhoneNumber |
1 | John | Doe | john.doe@example.com | +1-503-789-1234 |
2 | Jane | Smith | jane.smith@example.com | +1-503-789-5678 |
Accounts
AccountID | CustomerID | AccountType | Balance | OpenDate |
| (→ Customers.CustomerID) | | | |
1 | 1 | Checking | 1000.0 | 2021-01-01 |
2 | 2 | Savings | 500.0 | 2021-01-02 |
Transactions
TransactionID | FromAccountID | ToAccountID | Amount | Date | Fee_Amount | Commission_Percentage | Transactions |
| (→ Accounts.AccountID) | (→ Accounts.AccountID) | | | | | |
1 | 1 | 2 | 100.0 | 2021-01-01 | 2.0 | 0.2 | 1 |
2 | 2 | 3 | 200.0 | 2021-01-02 | 4.0 | 0.3 | 2 |
Loans
LoanID | CustomerID | LoanAmount | InterestRate | TermYears | ApprovalDate |
| (→ Customers.CustomerID) | | | | |
1 | 1 | 10000.0 | 3.5 | 5 | 2021-01-01 |
2 | 2 | 5000.0 | 4 | 3 | 2021-01-02 |
Overdrafts
OverdraftID | AccountID | LimitAmount | InterestRate | Fees |
| (→ Accounts.AccountID) | | | |
1 | 1 | 500.0 | 4.5 | 0.1 |
2 | 2 | 1000.0 | 4 | 0.15 |
Rewards
RewardID | AccountID | Points | RedemptionValue |
| (→ Accounts.AccountID) | | |
1 | 1 | 100 | 10.0 |
2 | 2 | 50 | 5.0 |