customers
customer_id | first_name | last_name | date_of_birth | email |
1 | John | Doe | 2000-01-01 | john@example.com |
2 | Jane | Smith | 1985-06-30 | jane@example.com |
accounts
account_number | balance | interest_rate | customer_id |
| | | (→ customers.customer_id) |
1 | 1000.0 | 2.0 | 1 |
2 | 3000.0 | 2.5 | 2 |
loans
loan_id | amount | start_date | end_date | monthly_payment | account_number |
| | | | | (→ accounts.account_number) |
1 | 50000.0 | 2022-01-01 | 2027-01-01 | 1000.0 | 1 |
2 | 75000.0 | 2021-01-01 | 2026-01-01 | 1200.0 | 2 |
life_insurances
policy_number | payout | coverage_amount | term_years | customer_id |
| | | | (→ customers.customer_id) |
1 | 100000.0 | 500000.0 | 20 | 1 |
2 | 150000.0 | 600000.0 | 20 | 2 |
annuities
contract_number | payout | premium_amount | start_date | end_date | customer_id |
| | | | | (→ customers.customer_id) |
1 | 100000.0 | 10000.0 | 2023-01-01 | 2033-01-01 | 1 |
2 | 150000.0 | 15000.0 | 2024-01-01 | 2034-01-01 | 2 |
transactions
transaction_id | type | amount | account_number |
| | | (→ accounts.account_number) |
1 | Deposit | 1000.0 | 1 |
2 | Withdrawal | 500.0 | 1 |