customers

customer_idfirst_namelast_namedate_of_birthemail
1JohnDoe2000-01-01john@example.com
2JaneSmith1985-06-30jane@example.com

accounts

account_numberbalanceinterest_ratecustomer_id
(→ customers.customer_id)
11000.02.01
23000.02.52

loans

loan_idamountstart_dateend_datemonthly_paymentaccount_number
(→ accounts.account_number)
150000.02022-01-012027-01-011000.01
275000.02021-01-012026-01-011200.02

life_insurances

policy_numberpayoutcoverage_amountterm_yearscustomer_id
(→ customers.customer_id)
1100000.0500000.0201
2150000.0600000.0202

annuities

contract_numberpayoutpremium_amountstart_dateend_datecustomer_id
(→ customers.customer_id)
1100000.010000.02023-01-012033-01-011
2150000.015000.02024-01-012034-01-012

transactions

transaction_idtypeamountaccount_number
(→ accounts.account_number)
1Deposit1000.01
2Withdrawal500.01