## 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

## 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

## Transactions

TransactionID | FromAccountID | ToAccountID | Amount | Date | Extra_Charges | Transactions
--- | --- | --- | --- | --- | --- | ---
| (→ Accounts.AccountID) | (→ Accounts.AccountID) |  |  |  |
1 | 1 | 2 | 100.0 | 2021-01-01 | 2.0 | 1
2 | 2 | 3 | 200.0 | 2021-01-02 | 4.0 | 2