Transaction_Type

transaction_idtransaction_typebank_accountamountdate
1Payment12345671000.02022-09-01
2Payment98765431500.02022-09-01
3Remittance Transfer12345672000.02022-09-01
4Remittance Transfer98765433000.02022-09-01
5Deposit12345672500.02022-09-01
6Withdrawal9876543500.02022-09-01

Customer

customer_idfirst_namelast_nameemailphone_number
1JohnDoejohn.doe@example.com+1234567890
2JaneSmithjane.smith@example.com+0987654321
3AliceBrownalice.brown@example.com+1357924680
4BobWhitebob.white@example.com+2468013579
5TomBlacktom.black@example.com+3579246801

Account

account_idbank_accountbalanceinterest_rate
112345675000.00.05
2987654310000.00.04
3111111115000.00.03
4222222220000.00.02
5333333325000.00.01

Employee

employee_idfirst_namelast_nameemailhire_date
1MikeAdamsmike.adams@example.com2022-01-01
2LisaWilsonlisa.wilson@example.com2021-08-15
3DavidJacksondavid.jackson@example.com2022-05-20
4EmmaTayloremma.taylor@example.com2021-12-01
5AlexGreenalex.green@example.com2022-03-15

Loan

loan_idcustomer_idloan_amountinterest_ratestart_dateend_date
(→ Customer.customer_id)
11$1000000.052022-01-012026-01-01
22$1500000.042021-01-012025-01-01
33$2000000.032022-01-012026-01-01
44$2500000.022021-01-012025-01-01
55$3000000.012022-01-012026-01-01

Savings_Account

savings_idaccount_idbalanceannual_interst_ratecreated_at
(→ Account.account_id)
115000.00.052022-01-01
2210000.00.042021-01-01
3315000.00.032022-01-01
4420000.00.022021-01-01
5525000.00.012022-01-01