customers

customer_idfirst_namelast_namedate_of_birthaddress
1JohnDoe1970-06-15123 Main St
2JaneSmith1985-09-20456 Elm St

accounts

account_numbercustomer_idaccount_typebalance
(→ customers.customer_id)
11Checking1000.0
22Savings500.0

transactions

transaction_idaccount_numberamounttransaction_date
(→ accounts.account_number)
11200.02024-02-19 13:39:22
22-50.02024-02-19 13:39:22

minimum_requirements

requirement_idaccount_numberminimum_balanceminimum_agemoney_market_accounts
(→ accounts.account_number)
111000210
22500181

loans

loan_idcustomer_idloan_amountinterest_raterepayment_termstart_date
(→ customers.customer_id)
1110000.05.0362024-02-19 13:39:22
225000.04.0242024-02-19 13:39:22

overdraft_facilities

facility_idcustomer_idlimit_amountinterest_rate
(→ customers.customer_id)
11200.010.0
22500.015.0