customers
customer_id | first_name | last_name | date_of_birth | address |
1 | John | Doe | 1970-06-15 | 123 Main St |
2 | Jane | Smith | 1985-09-20 | 456 Elm St |
accounts
account_number | customer_id | account_type | balance |
| (→ customers.customer_id) | | |
1 | 1 | Checking | 1000.0 |
2 | 2 | Savings | 500.0 |
transactions
transaction_id | account_number | amount | transaction_date |
| (→ accounts.account_number) | | |
1 | 1 | 200.0 | 2024-02-19 13:39:22 |
2 | 2 | -50.0 | 2024-02-19 13:39:22 |
minimum_requirements
requirement_id | account_number | minimum_balance | minimum_age | money_market_accounts |
| (→ accounts.account_number) | | | |
1 | 1 | 1000 | 21 | 0 |
2 | 2 | 500 | 18 | 1 |
loans
loan_id | customer_id | loan_amount | interest_rate | repayment_term | start_date |
| (→ customers.customer_id) | | | | |
1 | 1 | 10000.0 | 5.0 | 36 | 2024-02-19 13:39:22 |
2 | 2 | 5000.0 | 4.0 | 24 | 2024-02-19 13:39:22 |
overdraft_facilities
facility_id | customer_id | limit_amount | interest_rate |
| (→ customers.customer_id) | | |
1 | 1 | 200.0 | 10.0 |
2 | 2 | 500.0 | 15.0 |