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 |
branch_id | branch_manager | Location | number_of_branches |
---|---|---|---|
1 | John Smith | 1st Ave | 1 |
2 | Jane Doe | Broadway | 2 |
3 | Alice Brown | Madison Ave | 3 |
4 | Charlie White | Central Park West | 4 |
5 | David Black | Washington Blvd | 5 |
6 | None | None | 6 |