id | name | location |
---|---|---|
1 | University A | City X |
2 | High School B | City Y |
3 | College C | City Z |
4 | Primary School D | City W |
5 | Technical School E | City V |
job_id | title | description |
---|---|---|
1 | Teacher | A teacher who teaches various subjects. |
2 | Principal | The principal manages a school. |
3 | Counselor | A counselor provides guidance to students. |
4 | Librarian | A librarian manages library resources. |
5 | IT Specialist | An IT specialist maintains computer systems. |
employee_id | first_name | last_name | job_title | school_id |
---|---|---|---|---|
(→ Schools.id) | ||||
1 | John | Doe | Teacher | 1 |
2 | Jane | Smith | Principal | 2 |
3 | Mike | Brown | Counselor | 3 |
4 | Alice | Green | Librarian | 4 |
5 | Tom | Black | IT Specialist | 5 |
school_job_id | school_id | job_id | start_date | end_date |
---|---|---|---|---|
(→ Schools.id) | (→ Educational_Jobs.job_id) | |||
1 | 1 | 1 | 2021-08-01 | None |
2 | 1 | 2 | 2021-08-01 | None |
3 | 2 | 3 | 2021-08-01 | None |
4 | 2 | 4 | 2021-08-01 | None |
5 | 3 | 5 | 2021-08-01 | None |
8 | 4 | 5 | None | None |
9 | 5 | 5 | None | None |
10 | 2 | 5 | None | None |
11 | 3 | 5 | None | None |
12 | 1 | 5 | None | None |
employee_education_id | employee_id | education_level | major | degree_year |
---|---|---|---|---|
(→ School_Employees.employee_id) | ||||
1 | 1 | PhD | Mathematics | 2019 |
2 | 1 | Master | Physics | 2017 |
3 | 2 | Doctorate | English Literature | 2020 |
4 | 2 | Bachelor | History | 2016 |
5 | 3 | Master | Psychology | 2018 |