Customers
customerID | firstName | lastName | dateOfBirth |
1 | John | Doe | 2000-01-01 |
2 | Jane | Smith | 1987-06-15 |
Accounts
accountNumber | customerID | balance |
| (→ Customers.customerID) | |
1 | 1 | 3000.0 |
2 | 2 | 20000.0 |
LifeInsurance
policyNumber | payoutColumn | startDate | endDate | customerID |
| | | | (→ Customers.customerID) |
1 | 100000 | 2023-01-01 | 2033-01-01 | 1 |
2 | 200000 | 2024-01-01 | 2036-01-01 | 2 |
Annuities
annuityID | payoutColumn | startDate | endDate | customerID |
| | | | (→ Customers.customerID) |
1 | 100000 | 2022-01-01 | 2030-01-01 | 1 |
2 | 200000 | 2023-01-01 | 2032-01-01 | 2 |
Payouts
paymentID | amountInWords | payoutType | accountNumber |
| | | (→ Accounts.accountNumber) |
1 | 100000 dollars | Life Insurance | 1 |
2 | 200000 dollars | Life Insurance | 1 |
3 | 50000 dollars | Annuity | 2 |
4 | 150000 dollars | Annuity | 2 |
5 | 50000 dollars | Account Balance | 1 |
6 | 100000 dollars | Account Balance | 2 |