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 |