Customers

CustomerIDFirstNameLastNameEmailAddressPhoneNumber
1JohnDoejohn.doe@example.com+1-503-789-1234
2JaneSmithjane.smith@example.com+1-503-789-5678

Accounts

AccountIDCustomerIDAccountTypeBalanceOpenDate
(→ Customers.CustomerID)
11Checking1000.02021-01-01
22Savings500.02021-01-02

Loans

LoanIDCustomerIDLoanAmountInterestRateTermYearsApprovalDate
(→ Customers.CustomerID)
1110000.03.552021-01-01
225000.0432021-01-02

Overdrafts

OverdraftIDAccountIDLimitAmountInterestRateFees
(→ Accounts.AccountID)
11500.04.50.1
221000.040.15

Rewards

RewardIDAccountIDPointsRedemptionValue
(→ Accounts.AccountID)
1110010.0
22505.0

Transactions

TransactionIDFromAccountIDToAccountIDAmountDateExtra_ChargesTransactions
(→ Accounts.AccountID)(→ Accounts.AccountID)
112100.02021-01-012.01
223200.02021-01-024.02