## customers

id | first_name | last_name | email | 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

## accounts

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

## transactions

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

## loans

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

## branches

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

## employees

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