customers

idfirst_namelast_nameemailphoneaddress_id
1JohnDoejohn.doe@example.com123-456-78901
2JaneSmithjane.smith@example.com098-765-43212
3AliceBrownalice.brown@example.com555-123-45673
4CharlieWhitecharlie.white@example.com555-987-65434
5DavidBlackdavid.black@example.com555-555-55555

accounts

account_numberaccount_typebalancecustomer_id
(→ customers.id)
1Checking1000.01
2Savings5000.02
3Money Market20000.03
4CD15000.04
5IRA40000.05

transactions

transaction_iddateamountdescriptionaccount_id
(→ accounts.account_number)
12021-01-01 00:00:00-500.0Initial Deposit1
22021-01-02 00:00:00200.0Paycheck Deposit1
32021-01-03 00:00:00-150.0Rent Payment1
42021-01-04 00:00:00300.0Online Shopping1
52021-01-05 00:00:00-50.0Groceries1

loans

loan_numberloan_amountinterest_ratetermdue_datecustomer_id
(→ customers.id)
110000.05.0362023-01-01 00:00:001
215000.06.0482024-01-01 00:00:002
320000.04.5602026-01-01 00:00:003
425000.05.5602027-01-01 00:00:004
530000.06.0722029-01-01 00:00:005

branches

branch_idbranch_managerstreet_nameneighborhoodnumber_of_branches
1John Smith1st AveUptown1
2Jane DoeBroadwayDowntown2
3Alice BrownMadison AveMidtown3
4Charlie WhiteCentral Park WestUpper West Side4
5David BlackWashington BlvdLower Manhattan5
6NoneNoneNone6

employees

employee_idfirst_namelast_namepositionhire_datebranch_id
(→ branches.branch_id)
1JohnDoeBranch Manager2021-01-01 00:00:001
2JaneDoeTeller2021-02-01 00:00:001
3AliceDoeHead Teller2021-03-01 00:00:002
4CharlieDoeCustomer Service Representative2021-04-01 00:00:003
5DavidDoeTeller2021-05-01 00:00:004