Banks

bank_idnamelocation
1Bank ANew York
2Bank BLos Angeles
3Bank CChicago
4Bank DHouston
5Bank EPhoenix

Microfinance_Institutions

institution_idnamelocation
1MF Inst ASan Francisco
2MF Inst BDallas
3MF Inst CSeattle
4MF Inst DDenver
5MF Inst EWashington

Customers

customer_idfirst_namelast_nameemailphone_number
1JohnSmithjohnsmith@example.com1234567890
2JaneDoejanedoe@example.com0987654321
3AliceJohnsonalicejohnson@example.com1122334455
4BobWilliamsbobwilliams@example.com5544332211
5EmmaNelsonemmanelson@example.com1112223333

Accounts

account_idcustomer_idbalance
(→ Customers.customer_id)
115000
2210000
333000
448000
552000

Transactions

transaction_idaccount_idamounttypedate
(→ Accounts.account_id)
11100deposit2022-01-01 00:00:00
22-50withdrawal2022-01-02 00:00:00
33200deposit2022-01-03 00:00:00
44-75withdrawal2022-01-04 00:00:00
55150deposit2022-01-05 00:00:00

Credit

credit_idamountinterest_ratestart_dateend_dateterm_lengthstatusbank_idinstitution_id
(→ Banks.bank_id)(→ Microfinance_Institutions.institution_id)
11000052022-01-012023-01-0112approved11
2500062022-01-022023-01-0212approved22
31500042022-01-032023-01-0312approved33
42000072022-01-042023-01-0412approved44
52500032022-01-052023-01-0512approved55