bankID | name | type |
---|---|---|
1 | Bank A | Formal |
2 | Bank B | Microfinance |
customerID | firstName | lastName | phoneNumber | |
---|---|---|---|---|
1 | John | Doe | john@example.com | 1234567890 |
2 | Jane | Smith | jane@example.com | 987654321 |
loanID | amount | Finance_Organization | Credit | startDate | endDate | status | customerID |
---|---|---|---|---|---|---|---|
(→ Customers.customerID) | |||||||
1 | 10000.0 | Formal Banks | 10000 | 2022-01-01 | 2023-01-01 | Approved | 1 |
2 | 5000.0 | Formal Banks | 5000 | 2022-01-01 | 2023-01-01 | Approved | 1 |
3 | 10000.0 | Microfinance Institutions | 10000 | 2022-01-01 | 2023-01-01 | Approved | 2 |
4 | 6000.0 | Microfinance Institutions | 6000 | 2022-01-01 | 2023-01-01 | Approved | 2 |
transactionID | date | description | amount | accountID | loanID |
---|---|---|---|---|---|
(→ Accounts.accountID) | (→ Loans.loanID) | ||||
1 | 2024-03-07 23:33:27 | Deposit | 1000.0 | 1 | None |
2 | 2024-03-07 23:33:27 | Withdrawal | -500.0 | 1 | None |
3 | 2024-03-07 23:33:27 | Payment | 1000.0 | 2 | 3 |
4 | 2024-03-07 23:33:27 | Interest Payment | -50.0 | 2 | 4 |
5 | 2024-03-07 23:33:27 | Late Fee | 20.0 | 2 | 4 |