id | name | address | phoneNumber |
---|---|---|---|
1 | Company A | 123 Main St. | 555-0100 |
2 | Company B | 456 Elm St. | 555-0101 |
3 | Company C | 789 Oak St. | 555-0102 |
4 | Company D | 101 Pine St. | 555-0103 |
5 | Company E | 321 Fir St. | 555-0104 |
id | title | description | postedDate | closingDate | companyId |
---|---|---|---|---|---|
(→ Company.id) | |||||
1 | Software Engineer | Experienced software engineer needed... | 2021-01-01 | 2021-01-31 | 1 |
2 | Data Analyst | Strong analytical skills required... | 2021-02-01 | 2021-02-28 | 2 |
3 | Project Manager | Proven track record managing projects... | 2021-03-01 | 2021-03-31 | 3 |
4 | QA Tester | Eye for detail needed for QA testing... | 2021-04-01 | 2021-04-30 | 4 |
5 | HR Specialist | Human resources experience a plus... | 2021-05-01 | 2021-05-31 | 5 |
id | firstName | lastName | hireDate | |
---|---|---|---|---|
1 | John | Doe | john.doe@example.com | 2020-06-01 |
2 | Jane | Smith | jane.smith@example.com | 2019-07-01 |
3 | Michael | Brown | michael.brown@example.com | 2018-08-01 |
4 | Emily | White | emily.white@example.com | 2020-09-01 |
5 | David | Black | david.black@example.com | 2017-10-01 |
id | employeeId | itSupportSkills | operatingSystemKnowledge | startDate | endDate |
---|---|---|---|---|---|
(→ Employee.id) | |||||
1 | 1 | Basic IT Support Skills | Windows | 2021-01-01 | 2021-12-31 |
2 | 2 | Advanced IT Support Skills | Linux | 2020-01-01 | 2021-12-31 |
3 | 3 | IT Support Technician I | MacOS | 2019-01-01 | 2020-12-31 |
4 | 4 | IT Support Technician II | Unix | 2018-01-01 | 2019-12-31 |
5 | 5 | IT Support Technician III | All OS | 2017-01-01 | 2018-12-31 |
id | employeeId | networkAdminSkills | operatingSystemKnowledge | startDate | endDate |
---|---|---|---|---|---|
(→ Employee.id) | |||||
1 | 1 | Cisco Router Configuration | Windows | 2021-01-01 | 2021-12-31 |
2 | 2 | Firewall Setup & Management | Linux | 2020-01-01 | 2021-12-31 |
3 | 3 | VPN Implementation | MacOS | 2019-01-01 | 2020-12-31 |
4 | 4 | Switch Configuration | Unix | 2018-01-01 | 2019-12-31 |
5 | 5 | Server Virtualization | All OS | 2017-01-01 | 2018-12-31 |