| CustomerID | FirstName | LastName | DateOfBirth | |
|---|---|---|---|---|
| 1 | John | Doe | 1987-03-06 | john.doe@example.com |
| 2 | Jane | Smith | 1990-08-15 | jane.smith@example.com |
| 3 | Alice | Johnson | 1975-05-10 | alice.johnson@example.com |
| ObligationID | CustomerID | Type | Amount | Price |
|---|---|---|---|---|
| (→ Customers.CustomerID) | ||||
| 1 | 1 | CDO | 50000.0 | 1000 |
| 2 | 1 | CDO | 100000.0 | 2000 |
| 3 | 2 | ABS | 80000.0 | 1500 |
| 4 | 3 | MBS | 60000.0 | 1200 |
| MortgageID | PropertyAddress | LoanAmount | InterestRate | MonthlyPayment | RemainingBalance | Price |
|---|---|---|---|---|---|---|
| 1 | 123 Main St | 200000.0 | 3.5 | 966.34 | 193266.66 | 1000 |
| 2 | None | 300000.0 | 3.75 | 1189.21 | 296849.29 | 2000 |
| 3 | None | 150000.0 | 3.25 | 770.15 | 153015.0 | None |
| 4 | None | 250000.0 | 4.0 | 1109.49 | 249890.0 | None |
| AccountNumber | CustomerID | Balance | AnnualInterestRate |
|---|---|---|---|
| (→ Customers.CustomerID) | |||
| AC123456789 | 1 | 1000.0 | 0.05 |
| AS987654321 | 2 | 2000.0 | 0.02 |
| AX112233445 | 3 | 3000.0 | 0.03 |
| AY654321098 | 1 | 5000.0 | 0.04 |
| AZ789012345 | 2 | 7000.0 | 0.01 |