Customers

CustomerIDFirstNameLastNameEmailAddress
1JohnDoejohn.doe@example.com
2JaneSmithjane.smith@example.com

Accounts

AccountNumberAccountTypeBalanceOpenDateCustomerID
(→ Customers.CustomerID)
1Checking1000.02023-01-011
2Savings5000.02023-02-012

Transactions

TransactionIDAmountDateAndTimeDescriptionAccountNumber
(→ Accounts.AccountNumber)
1200.02023-03-01 10:30:00Groceries1
2-150.02023-03-02 14:15:00ATM Withdrawal1

Overdrafts

OverdraftIDApprovalStatusLimitAmountStartDateEndDateAccountNumber
(→ Accounts.AccountNumber)
11500.02023-04-012023-05-011
20750.02023-05-012023-06-012

Rewards

RewardIDPointsExpiryDateAccountNumber
(→ Accounts.AccountNumber)
11002024-01-011
22002024-02-012

Limits

TransactionIDWithdrawal_LimitAtmsAccountNumber
(→ Accounts.AccountNumber)
13000.021
24000.032