| ID | ShiftName |
|---|---|
| 1 | Night Shift |
| 2 | Day Shift |
| 3 | Early Morning Shift |
| ID | TypeName |
|---|---|
| 1 | Registered Nurse |
| 2 | Licensed Practical Nurse |
| 3 | Physical Therapist |
| ID | ShiftID | StaffTypeID |
|---|---|---|
| (→ Shifts.ID) | (→ StaffTypes.ID) | |
| 1 | 1 | 1 |
| 2 | 2 | 2 |
| 3 | 3 | 3 |
| ID | ShiftID | StaffTypeID |
|---|---|---|
| (→ Shifts.ID) | (→ StaffTypes.ID) | |
| 1 | 1 | 1 |
| 2 | 2 | 2 |
| 3 | 3 | 3 |
| 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. |
| 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 |