Customers

CustomerIDFirstNameLastNameDateOfBirthEmailAddress
1JohnSmith1987-06-20johnsmith@example.com
2JaneDoe1990-05-25janedoe@example.com
3AliceWonderland1975-11-10alicemadness@example.com
4CharlieSheen1978-02-28charliesheen@example.com
5BettyWhite1922-01-17bettywhite@example.com

Mortgages

MortgageIDRepaymentPeriodInterestRateLoanAmountStartDateEndDateCustomerID
(→ Customers.CustomerID)
130 years0.03300000.02023-01-012053-01-011
225 years0.035250000.02022-05-012047-05-012
330 years0.025350000.02019-08-012049-08-013
425 years0.04200000.02020-12-012045-12-014
530 years0.02320000.02018-03-012048-03-015

HomeEquityLoans

EquityLoanIDRepaymentPeriodInterestRateLoanAmountStartDateEndDateCustomerID
(→ Customers.CustomerID)
130 years0.03100000.02022-02-012052-02-011
225 years0.035150000.02023-06-012048-06-012
330 years0.025180000.02019-09-012049-09-013
425 years0.04120000.02020-12-012045-12-014
530 years0.02160000.02018-03-012048-03-015

Repayments

RepaymentIDAmountPaidPaymentDueDatePaymentReceivedDateMortgageIDEquityLoanID
(→ Mortgages.MortgageID)(→ HomeEquityLoans.EquityLoanID)
11500.02023-01-152023-01-161None
21600.02023-01-152023-01-162None
31400.02023-01-152023-01-163None
41500.02023-01-152023-01-164None
51400.02023-01-152023-01-165None
61300.02023-01-152023-01-1611
71400.02023-01-152023-01-1622
81300.02023-01-152023-01-1633
91400.02023-01-152023-01-1644
101300.02023-01-152023-01-1655