Customers

CustomerIDFirstNameLastNameEmailPhoneNumber
1JohnDoejohn@example.com+123456789
2JaneSmithjane@example.com+987654321
3BobRobertsonbob@example.com+0987654321
4AliceWonderlandalice@example.com+135792468
5CharlieBrowncharlie@example.com+246801753

Accounts

AccountIDBalanceInterestRateDateOpenedCustomerID
(→ Customers.CustomerID)
11000.02.52020-01-011
22000.03.02020-01-022
33000.02.02020-01-033
44000.02.52020-01-044
55000.03.02020-01-055

Insurance_Products

ProductIDPolicyHolderIDProductTypePayoutStartDateEndDate
(→ Customers.CustomerID)
11Life Insurance100000.02020-01-012030-01-01
22Life Insurance50000.02020-01-022030-01-02
33Annuity100000.02020-01-032030-01-03
44Annuity50000.02020-01-042030-01-04
55Health Insurance80000.02020-01-052030-01-05

Transactions

TransactionIDAmountTypeDateAccountID
(→ Accounts.AccountID)
1-500.0Withdrawal2020-01-011
2200.0Deposit2020-01-022
3300.0Transfer2020-01-033
4-200.0Withdrawal2020-01-044
5500.0Deposit2020-01-055

Loans

LoanIDPrincipalInterestRateTermYearsMonthlyPaymentApprovalDateAccountID
(→ Accounts.AccountID)
110000.05.030450.0None1
215000.04.525600.0None2
320000.05.530500.0None3
425000.05.020750.0None4
530000.04.525650.0None5