Shifts

IDShiftName
1Night Shift
2Day Shift
3Early Morning Shift

StaffTypes

IDTypeName
1Registered Nurse
2Licensed Practical Nurse
3Physical Therapist

NursePostings

IDShiftIDStaffTypeID
(→ Shifts.ID)(→ StaffTypes.ID)
111
222
333

PhysicalTherapistPostings

IDShiftIDStaffTypeID
(→ Shifts.ID)(→ StaffTypes.ID)
111
222
333

JobRequirements

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

PostedJobs

IDTitleLocationStartDateEndDateNurseJobIdPhysiotherapistJobIdRequirementsId
(→ NursePostings.ID)(→ PhysicalTherapistPostings.ID)(→ JobRequirements.ID)
1Nursing Position at Hospital ANew York City2023-06-012023-07-311None1
2Licensed Practical Nurse at Clinic BLos Angeles2023-08-012023-12-312None2
3Physical Therapy Opportunity at Rehab Center CChicago2023-09-012024-03-31None33
4Nurse Manager Role at Hospital DMiami2023-10-012023-11-301None4
5Orthopedic Physical Therapist at Sports Medicine EBoston2023-12-012024-04-30None45