Clients

ClientIDFirstNameLastNameEmailAddressPhoneNumber
1JohnSmithjohnsmith@email.com+123456789
2JaneDoejanedoe@email.com+987654321

Accounts

AccountIDClientIDBalanceInterestRate
(→ Clients.ClientID)
115000.00.05
2210000.00.03

Loans

LoanIDClientIDPrincipalInterestRateTermYearsMonthlyPayment
(→ Clients.ClientID)
11150000.065400
22200000.0510500

Structured_Financial_Products

ProductIDNameTypePriceOtherValues
1CDO1Collateralized Debt Obligation1000.0Details about CDO1
2CDO2Collateralized Debt Obligation1200.0Details about CDO2
3CMO1Collateralized Mortgage Obligation1000.0Details about CMO1
4CMO2Collateralized Mortgage Obligation1500.0Details about CMO2