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 |