Customers

CustomerIDFirstNameLastNameEmailPhoneNumber
1JohnDoejohn.doe@example.com+1234567890
2JaneSmithjane.smith@example.com+0987654321
3AliceBrownalice.brown@example.com+1112223334
4BobWhitebob.white@example.com+44556677889
5CharlieBlackcharlie.black@example.com+22334455667

Mortgages

MortgageIDCustomerIDPropertyAddressMortgageAmountRepaymentPeriodInterestRateStartDateEndDate
(→ Customers.CustomerID)
11123 Main St200000.030 years4.52021-01-012051-01-01
22456 Elm Street350000.025 years42022-01-012047-01-01

HomeEquityLoans

LoanIDCustomerIDPropertyAddressLoanAmountRepaymentPeriodInterestRateStartDateEndDate
(→ Customers.CustomerID)
11123 Main St50000.020 years52021-01-012041-01-01
22456 Elm Street65000.030 years4.752022-01-012052-01-01

Accounts

AccountIDCustomerIDAccountTypeBalanceOpeningDateCloseDate
(→ Customers.CustomerID)
11Checking1000.02020-01-01None
22Savings2000.02019-01-01None
31CD5000.02018-01-012025-01-01
42Money Market10000.02017-01-012021-01-01

Transactions

TransactionIDAccountIDAmountDateDescription
(→ Accounts.AccountID)
11-200.02021-01-15Rent Payment
21500.02021-01-16Salary Credit
32-1500.02021-01-17Utility Bill Payment
422000.02021-01-18Paycheck Direct Deposit
51300.02021-01-19Grocery Shopping