## 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