Customers

customer_idfirst_namelast_nameemailphone_number
1JohnDoejohn@example.com+123456789
2JaneSmithjane@example.com+098765432
3AliceBrownalice@example.com+987654321
4CharlieWhitecharlie@example.com+135792468
5DavidBlackdavid@example.com+246801753

Accounts

account_idcustomer_idbalance
(→ Customers.customer_id)
111000.0
225000.0
337500.0
442500.0
551500.0

Loans

loan_idbanktype_idamountcreditstart_dateend_date
(→ BankType.banktype_id)
1110000.010000.02022-01-012023-01-01
215000.05000.02022-01-152023-01-15
3210000.010000.02022-02-012023-02-01
425000.05000.02022-02-152023-02-15
537500.07500.02022-03-012023-03-01

BankType

banktype_idfinance_organizationdescription
1Formal BanksTraditional financial institutions.
2Microfinance InstitutionsSmall scale lenders focused on underprivileged communities.
3Credit UnionsNot-for-profit financial cooperatives.
4Investment BanksInstitutions primarily involved in raising capital.
5Central BanksGovernment-owned banks responsible for monetary policy.