Types

TypeIDTypeNameServices_OfferedInterestRateMaxDepositAmount
1BranchBalance2.0100000.0
2BranchATM Access3.080000.0
3Online BankBalance2.575000.0
4Online BankMobile App3.560000.0
5Credit UnionLoans1.590000.0

Customers

CustomerIDFirstNameLastNameEmailPhoneNumberBranchID
(→ Branches.BranchID)
1JohnDoejohn.doe@example.com+1-555-123-45671
2JaneSmithjane.smith@example.com+1-555-987-65432
3AliceBrownalice.brown@example.com+1-555-765-4321None
4BobWhitebob.white@example.com+1-555-456-7890None
5CharlieBlackcharlie.black@example.com+1-555-111-2222None

Accounts

AccountIDCustomerIDBalanceDateCreatedTYPEID
(→ Customers.CustomerID)(→ Types.TypeID)
115000.02021-01-011
2210000.02021-02-011
3320000.02021-03-013
4430000.02021-04-013
5540000.02021-05-015

Transactions

TransactionIDAccountIDAmountDate
(→ Accounts.AccountID)
11100.02021-01-15
21-50.02021-01-16
32200.02021-02-15
42-100.02021-02-16
53300.02021-03-15