## customers

id | firstName | lastName | email | 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

## rates

id | interestRate
--- | ---
1 | 15.0
2 | 10.0
3 | 20.0
4 | 12.0
5 | 17.0

## loans

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