Banks
bank_id | name | location |
1 | Bank A | New York |
2 | Bank B | Los Angeles |
3 | Bank C | Chicago |
4 | Bank D | Houston |
5 | Bank E | Phoenix |
Microfinance_Institutions
institution_id | name | location |
1 | MF Inst A | San Francisco |
2 | MF Inst B | Dallas |
3 | MF Inst C | Seattle |
4 | MF Inst D | Denver |
5 | MF Inst E | Washington |
Customers
customer_id | first_name | last_name | email | phone_number |
1 | John | Smith | johnsmith@example.com | 1234567890 |
2 | Jane | Doe | janedoe@example.com | 0987654321 |
3 | Alice | Johnson | alicejohnson@example.com | 1122334455 |
4 | Bob | Williams | bobwilliams@example.com | 5544332211 |
5 | Emma | Nelson | emmanelson@example.com | 1112223333 |
Accounts
account_id | customer_id | balance |
| (→ Customers.customer_id) | |
1 | 1 | 5000 |
2 | 2 | 10000 |
3 | 3 | 3000 |
4 | 4 | 8000 |
5 | 5 | 2000 |
Transactions
transaction_id | account_id | amount | type | date |
| (→ Accounts.account_id) | | | |
1 | 1 | 100 | deposit | 2022-01-01 00:00:00 |
2 | 2 | -50 | withdrawal | 2022-01-02 00:00:00 |
3 | 3 | 200 | deposit | 2022-01-03 00:00:00 |
4 | 4 | -75 | withdrawal | 2022-01-04 00:00:00 |
5 | 5 | 150 | deposit | 2022-01-05 00:00:00 |
Credit
credit_id | amount | interest_rate | start_date | end_date | term_length | status | bank_id | institution_id |
| | | | | | | (→ Banks.bank_id) | (→ Microfinance_Institutions.institution_id) |
1 | 10000 | 5 | 2022-01-01 | 2023-01-01 | 12 | approved | 1 | 1 |
2 | 5000 | 6 | 2022-01-02 | 2023-01-02 | 12 | approved | 2 | 2 |
3 | 15000 | 4 | 2022-01-03 | 2023-01-03 | 12 | approved | 3 | 3 |
4 | 20000 | 7 | 2022-01-04 | 2023-01-04 | 12 | approved | 4 | 4 |
5 | 25000 | 3 | 2022-01-05 | 2023-01-05 | 12 | approved | 5 | 5 |