## Customers

CustomerID | FirstName | LastName | Email | PhoneNumber
--- | --- | --- | --- | ---
1 | John | Doe | john.doe@example.com | +1234567890
2 | Jane | Smith | jane.smith@example.com | +0987654321
3 | Alice | Brown | alice.brown@example.com | +1112223334
4 | Bob | White | bob.white@example.com | +44556677889
5 | Charlie | Black | charlie.black@example.com | +22334455667

## Mortgages

MortgageID | CustomerID | PropertyAddress | MortgageAmount | RepaymentPeriod | InterestRate | StartDate | EndDate
--- | --- | --- | --- | --- | --- | --- | ---
| (→ Customers.CustomerID) |  |  |  |  |  |
1 | 1 | 123 Main St | 200000.0 | 30 years | 4.5 | 2021-01-01 | 2051-01-01
2 | 2 | 456 Elm Street | 350000.0 | 25 years | 4 | 2022-01-01 | 2047-01-01

## HomeEquityLoans

LoanID | CustomerID | PropertyAddress | LoanAmount | RepaymentPeriod | InterestRate | StartDate | EndDate
--- | --- | --- | --- | --- | --- | --- | ---
| (→ Customers.CustomerID) |  |  |  |  |  |
1 | 1 | 123 Main St | 50000.0 | 20 years | 5 | 2021-01-01 | 2041-01-01
2 | 2 | 456 Elm Street | 65000.0 | 30 years | 4.75 | 2022-01-01 | 2052-01-01

## Accounts

AccountID | CustomerID | AccountType | Balance | OpeningDate | CloseDate
--- | --- | --- | --- | --- | ---
| (→ Customers.CustomerID) |  |  |  |
1 | 1 | Checking | 1000.0 | 2020-01-01 | None
2 | 2 | Savings | 2000.0 | 2019-01-01 | None
3 | 1 | CD | 5000.0 | 2018-01-01 | 2025-01-01
4 | 2 | Money Market | 10000.0 | 2017-01-01 | 2021-01-01

## Transactions

TransactionID | AccountID | Amount | Date | Description
--- | --- | --- | --- | ---
| (→ Accounts.AccountID) |  |  |
1 | 1 | -200.0 | 2021-01-15 | Rent Payment
2 | 1 | 500.0 | 2021-01-16 | Salary Credit
3 | 2 | -1500.0 | 2021-01-17 | Utility Bill Payment
4 | 2 | 2000.0 | 2021-01-18 | Paycheck Direct Deposit
5 | 1 | 300.0 | 2021-01-19 | Grocery Shopping