Customers
CustomerID | FirstName | LastName | DateOfBirth | EmailAddress |
1 | John | Smith | 1987-06-20 | johnsmith@example.com |
2 | Jane | Doe | 1990-05-25 | janedoe@example.com |
3 | Alice | Wonderland | 1975-11-10 | alicemadness@example.com |
4 | Charlie | Sheen | 1978-02-28 | charliesheen@example.com |
5 | Betty | White | 1922-01-17 | bettywhite@example.com |
Mortgages
MortgageID | RepaymentPeriod | InterestRate | LoanAmount | StartDate | EndDate | CustomerID |
| | | | | | (→ Customers.CustomerID) |
1 | 30 years | 0.03 | 300000.0 | 2023-01-01 | 2053-01-01 | 1 |
2 | 25 years | 0.035 | 250000.0 | 2022-05-01 | 2047-05-01 | 2 |
3 | 30 years | 0.025 | 350000.0 | 2019-08-01 | 2049-08-01 | 3 |
4 | 25 years | 0.04 | 200000.0 | 2020-12-01 | 2045-12-01 | 4 |
5 | 30 years | 0.02 | 320000.0 | 2018-03-01 | 2048-03-01 | 5 |
HomeEquityLoans
EquityLoanID | RepaymentPeriod | InterestRate | LoanAmount | StartDate | EndDate | CustomerID |
| | | | | | (→ Customers.CustomerID) |
1 | 30 years | 0.03 | 100000.0 | 2022-02-01 | 2052-02-01 | 1 |
2 | 25 years | 0.035 | 150000.0 | 2023-06-01 | 2048-06-01 | 2 |
3 | 30 years | 0.025 | 180000.0 | 2019-09-01 | 2049-09-01 | 3 |
4 | 25 years | 0.04 | 120000.0 | 2020-12-01 | 2045-12-01 | 4 |
5 | 30 years | 0.02 | 160000.0 | 2018-03-01 | 2048-03-01 | 5 |
Repayments
RepaymentID | AmountPaid | PaymentDueDate | PaymentReceivedDate | MortgageID | EquityLoanID |
| | | | (→ Mortgages.MortgageID) | (→ HomeEquityLoans.EquityLoanID) |
1 | 1500.0 | 2023-01-15 | 2023-01-16 | 1 | None |
2 | 1600.0 | 2023-01-15 | 2023-01-16 | 2 | None |
3 | 1400.0 | 2023-01-15 | 2023-01-16 | 3 | None |
4 | 1500.0 | 2023-01-15 | 2023-01-16 | 4 | None |
5 | 1400.0 | 2023-01-15 | 2023-01-16 | 5 | None |
6 | 1300.0 | 2023-01-15 | 2023-01-16 | 1 | 1 |
7 | 1400.0 | 2023-01-15 | 2023-01-16 | 2 | 2 |
8 | 1300.0 | 2023-01-15 | 2023-01-16 | 3 | 3 |
9 | 1400.0 | 2023-01-15 | 2023-01-16 | 4 | 4 |
10 | 1300.0 | 2023-01-15 | 2023-01-16 | 5 | 5 |