## Clients

ClientID | FirstName | LastName | EmailAddress | PhoneNumber
--- | --- | --- | --- | ---
1 | John | Smith | johnsmith@email.com | +123456789
2 | Jane | Doe | janedoe@email.com | +987654321

## Accounts

AccountID | ClientID | Balance | InterestRate
--- | --- | --- | ---
| (→ Clients.ClientID) |  |
1 | 1 | 5000.0 | 0.05
2 | 2 | 10000.0 | 0.03

## Loans

LoanID | ClientID | Principal | InterestRate | TermYears | MonthlyPayment
--- | --- | --- | --- | --- | ---
| (→ Clients.ClientID) |  |  |  |
1 | 1 | 15000 | 0.06 | 5 | 400
2 | 2 | 20000 | 0.05 | 10 | 500

## Structured_Financial_Products

ProductID | Name | Type | Price | CollateralizedDebtObligations | CollateralizedMortgageObligations | OtherValues
--- | --- | --- | --- | --- | --- | ---
1 | CDO1 | Collateralized Debt Obligation | 1000.0 | None | None | Details about CDO1
2 | CDO2 | Collateralized Debt Obligation | 1200.0 | None | None | Details about CDO2
3 | CMO1 | Collateralized Mortgage Obligation | 1000.0 | None | None | Details about CMO1
4 | CMO2 | Collateralized Mortgage Obligation | 1500.0 | None | None | Details about CMO2