Banks

bankIDnametype
1Bank AFormal
2Bank BMicrofinance

Customers

customerIDfirstNamelastNameemailphoneNumber
1JohnDoejohn@example.com1234567890
2JaneSmithjane@example.com987654321

Loans

loanIDamountFinance_OrganizationCreditstartDateendDatestatuscustomerID
(→ Customers.customerID)
110000.0Formal Banks100002022-01-012023-01-01Approved1
25000.0Formal Banks50002022-01-012023-01-01Approved1
310000.0Microfinance Institutions100002022-01-012023-01-01Approved2
46000.0Microfinance Institutions60002022-01-012023-01-01Approved2

Transactions

transactionIDdatedescriptionamountaccountIDloanID
(→ Accounts.accountID)(→ Loans.loanID)
12024-03-07 23:33:27Deposit1000.01None
22024-03-07 23:33:27Withdrawal-500.01None
32024-03-07 23:33:27Payment1000.023
42024-03-07 23:33:27Interest Payment-50.024
52024-03-07 23:33:27Late Fee20.024