| id | first_name | last_name | phone | address_id | |
|---|---|---|---|---|---|
| 1 | John | Doe | john.doe@example.com | 123-456-7890 | 1 |
| 2 | Jane | Smith | jane.smith@example.com | 098-765-4321 | 2 |
| 3 | Alice | Brown | alice.brown@example.com | 555-123-4567 | 3 |
| 4 | Charlie | White | charlie.white@example.com | 555-987-6543 | 4 |
| 5 | David | Black | david.black@example.com | 555-555-5555 | 5 |
| account_number | account_type | balance | customer_id |
|---|---|---|---|
| (→ customers.id) | |||
| 1 | Checking | 1000.0 | 1 |
| 2 | Savings | 5000.0 | 2 |
| 3 | Money Market | 20000.0 | 3 |
| 4 | CD | 15000.0 | 4 |
| 5 | IRA | 40000.0 | 5 |
| transaction_id | date | amount | description | account_id |
|---|---|---|---|---|
| (→ accounts.account_number) | ||||
| 1 | 2021-01-01 00:00:00 | -500.0 | Initial Deposit | 1 |
| 2 | 2021-01-02 00:00:00 | 200.0 | Paycheck Deposit | 1 |
| 3 | 2021-01-03 00:00:00 | -150.0 | Rent Payment | 1 |
| 4 | 2021-01-04 00:00:00 | 300.0 | Online Shopping | 1 |
| 5 | 2021-01-05 00:00:00 | -50.0 | Groceries | 1 |
| loan_number | loan_amount | interest_rate | term | due_date | customer_id |
|---|---|---|---|---|---|
| (→ customers.id) | |||||
| 1 | 10000.0 | 5.0 | 36 | 2023-01-01 00:00:00 | 1 |
| 2 | 15000.0 | 6.0 | 48 | 2024-01-01 00:00:00 | 2 |
| 3 | 20000.0 | 4.5 | 60 | 2026-01-01 00:00:00 | 3 |
| 4 | 25000.0 | 5.5 | 60 | 2027-01-01 00:00:00 | 4 |
| 5 | 30000.0 | 6.0 | 72 | 2029-01-01 00:00:00 | 5 |
| branch_id | branch_manager | street_name | neighborhood | number_of_branches |
|---|---|---|---|---|
| 1 | John Smith | 1st Ave | Uptown | 1 |
| 2 | Jane Doe | Broadway | Downtown | 2 |
| 3 | Alice Brown | Madison Ave | Midtown | 3 |
| 4 | Charlie White | Central Park West | Upper West Side | 4 |
| 5 | David Black | Washington Blvd | Lower Manhattan | 5 |
| 6 | None | None | None | 6 |
| employee_id | first_name | last_name | position | hire_date | branch_id |
|---|---|---|---|---|---|
| (→ branches.branch_id) | |||||
| 1 | John | Doe | Branch Manager | 2021-01-01 00:00:00 | 1 |
| 2 | Jane | Doe | Teller | 2021-02-01 00:00:00 | 1 |
| 3 | Alice | Doe | Head Teller | 2021-03-01 00:00:00 | 2 |
| 4 | Charlie | Doe | Customer Service Representative | 2021-04-01 00:00:00 | 3 |
| 5 | David | Doe | Teller | 2021-05-01 00:00:00 | 4 |