CustomerID | FirstName | LastName | 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 |
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 |
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 |
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 |
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 |