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