Leadership

ceoIDfirstNamelastName
1JohnDoe
2JaneSmith
3MichaelJohnson
4EmilyWilliams
5DavidBrown

Customers

customerIDcustomerNameaccountNumberbankID
(→ Banks.bankID)
1Customer A9876543211
2Customer B1234567892
3Customer C9999999993
4Customer D8888888884
5Customer E7777777775

Accounts

accountIDaccountTypebalancecustomerID
(→ Customers.customerID)
1Checking1000.01
2Savings500.02
3Money Market2000.03
4CD10000.04
5IRA5000.05

Transactions

transactionIDamounttypedateaccountID
(→ Accounts.accountID)
1500.0Deposit2024-02-19 14:16:121
2-200.0Withdrawal2024-02-19 14:16:122
3300.0Transfer2024-02-19 14:16:123
4-400.0Withdrawal2024-02-19 14:16:124
5500.0Deposit2024-02-19 14:16:125

Banks

bankIDbankNamebranchNumberceoID
(→ Leadership.ceoID)
1Bank A1001
2Bank B2002
3Bank C3003
4Bank D4004
5Bank E5005