Employers
id | name | address |
1 | Employer A | 123 Main St |
2 | Employer B | 456 Elm St |
3 | Employer C | 789 Oak St |
Locations
id | city | state |
1 | City X | State AA |
2 | City Y | State BB |
3 | City Z | State CC |
Skills
id | skillName |
1 | Skill A |
2 | Skill B |
3 | Skill C |
4 | Skill D |
5 | Skill E |
Requirements
id | requirement |
1 | Requirement 1 |
2 | Requirement 2 |
3 | Requirement 3 |
4 | Requirement 4 |
5 | Requirement 5 |
JobPostings
id | title | description | healthcare | shift | employerId | locationId | skillsIds | requirementsIds |
| | | | | (→ Employers.id) | (→ Locations.id) | | |
1 | Job 1 | Description of Job 1 | Nurse | Day Shift | 1 | 1 | A,B | 1,2 |
2 | Job 2 | Description of Job 2 | Nurse | Night Shift | 1 | 2 | C,D | 3,4 |
3 | Job 3 | Description of Job 3 | Physical Therapist | Day Shift | 2 | 1 | E | 5 |
4 | Job 4 | Description of Job 4 | Physical Therapist | Night Shift | 2 | 2 | | 6 |
5 | Job 5 | Description of Job 5 | Software Engineer | Flexible | 3 | 3 | A,C,E | 7,8 |