| 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 |