Customers

customerIDfirstNamelastNamedateOfBirth
1JohnDoe2000-01-01
2JaneSmith1987-06-15

Accounts

accountNumbercustomerIDbalance
(→ Customers.customerID)
113000.0
2220000.0

LifeInsurance

policyNumberpayoutColumnstartDateendDatecustomerID
(→ Customers.customerID)
11000002023-01-012033-01-011
22000002024-01-012036-01-012

Annuities

annuityIDpayoutColumnstartDateendDatecustomerID
(→ Customers.customerID)
11000002022-01-012030-01-011
22000002023-01-012032-01-012

Payouts

paymentIDamountInWordspayoutTypeaccountNumber
(→ Accounts.accountNumber)
1100000 dollarsLife Insurance1
2200000 dollarsLife Insurance1
350000 dollarsAnnuity2
4150000 dollarsAnnuity2
550000 dollarsAccount Balance1
6100000 dollarsAccount Balance2