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 |