id | firstName | lastName | phoneNumber | |
---|---|---|---|---|
1 | John | Doe | john@example.com | 1234567890 |
2 | Jane | Smith | jane@example.com | 987654321 |
3 | Alice | Brown | alice@example.com | 1123456789 |
4 | Bob | White | bob@example.com | 987654320 |
5 | Charlie | Black | charlie@example.com | 1234567891 |
id | interestRate |
---|---|
1 | 15.0 |
2 | 10.0 |
3 | 20.0 |
4 | 12.0 |
5 | 17.0 |
id | customerId | loanType | amount | termYears | interestRateId |
---|---|---|---|---|---|
(→ customers.id) | (→ rates.id) | ||||
1 | 1 | Credit Card | 10000.0 | 5 | 1 |
2 | 2 | Credit Card | 5000.0 | 3 | 2 |
3 | 3 | Personal Loan | 20000.0 | 10 | 1 |
4 | 4 | Personal Loan | 15000.0 | 8 | 2 |
5 | 5 | Mortgage | 250000.0 | 25 | 3 |
6 | 6 | Car Loan | 20000.0 | 5 | 4 |
7 | 7 | Student Loan | 10000.0 | 10 | 5 |
8 | 8 | Business Loan | 50000.0 | 7 | 6 |
9 | 9 | Home Equity Line of Credit | 30000.0 | 10 | 7 |