customer_id | first_name | last_name | phone_number | |
---|---|---|---|---|
1 | John | Doe | john@example.com | +123456789 |
2 | Jane | Smith | jane@example.com | +098765432 |
3 | Alice | Brown | alice@example.com | +987654321 |
4 | Charlie | White | charlie@example.com | +135792468 |
5 | David | Black | david@example.com | +246801753 |
account_id | customer_id | balance |
---|---|---|
(→ Customers.customer_id) | ||
1 | 1 | 1000.0 |
2 | 2 | 5000.0 |
3 | 3 | 7500.0 |
4 | 4 | 2500.0 |
5 | 5 | 1500.0 |
loan_id | banktype_id | amount | credit | start_date | end_date |
---|---|---|---|---|---|
(→ BankType.banktype_id) | |||||
1 | 1 | 10000.0 | 10000.0 | 2022-01-01 | 2023-01-01 |
2 | 1 | 5000.0 | 5000.0 | 2022-01-15 | 2023-01-15 |
3 | 2 | 10000.0 | 10000.0 | 2022-02-01 | 2023-02-01 |
4 | 2 | 5000.0 | 5000.0 | 2022-02-15 | 2023-02-15 |
5 | 3 | 7500.0 | 7500.0 | 2022-03-01 | 2023-03-01 |
banktype_id | finance_organization | description |
---|---|---|
1 | Formal Banks | Traditional financial institutions. |
2 | Microfinance Institutions | Small scale lenders focused on underprivileged communities. |
3 | Credit Unions | Not-for-profit financial cooperatives. |
4 | Investment Banks | Institutions primarily involved in raising capital. |
5 | Central Banks | Government-owned banks responsible for monetary policy. |