## Shifts

ID | ShiftName
--- | ---
1 | Night Shift
2 | Day Shift
3 | Early Morning Shift

## StaffTypes

ID | TypeName
--- | ---
1 | Registered Nurse
2 | Licensed Practical Nurse
3 | Physical Therapist

## NursePostings

ID | ShiftID | StaffTypeID
--- | --- | ---
| (→ Shifts.ID) | (→ StaffTypes.ID)
1 | 1 | 1
2 | 2 | 2
3 | 3 | 3

## PhysicalTherapistPostings

ID | ShiftID | StaffTypeID
--- | --- | ---
| (→ Shifts.ID) | (→ StaffTypes.ID)
1 | 1 | 1
2 | 2 | 2
3 | 3 | 3

## JobRequirements

ID | Description | RequiredSkills
--- | --- | ---
1 | Care for patients and provide medical assistance. | Strong communication skills, empathy, critical thinking.
2 | Assist patients in regaining mobility after injury or surgery. | Knowledge of anatomy, biomechanics, and exercise physiology.

## PostedJobs

ID | Title | Location | StartDate | EndDate | NurseJobId | PhysiotherapistJobId | RequirementsId
--- | --- | --- | --- | --- | --- | --- | ---
|  |  |  |  | (→ NursePostings.ID) | (→ PhysicalTherapistPostings.ID) | (→ JobRequirements.ID)
1 | Nursing Position at Hospital A | New York City | 2023-06-01 | 2023-07-31 | 1 | None | 1
2 | Licensed Practical Nurse at Clinic B | Los Angeles | 2023-08-01 | 2023-12-31 | 2 | None | 2
3 | Physical Therapy Opportunity at Rehab Center C | Chicago | 2023-09-01 | 2024-03-31 | None | 3 | 3
4 | Nurse Manager Role at Hospital D | Miami | 2023-10-01 | 2023-11-30 | 1 | None | 4
5 | Orthopedic Physical Therapist at Sports Medicine E | Boston | 2023-12-01 | 2024-04-30 | None | 4 | 5