## 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