Jobs

idtitledescriptionlocation
1CardiologistExperienced Cardiologist needed for full time position.New York
2DentistGeneral Dentist required for part-time role.Los Angeles
3RadiographerSeeking experienced Radiographer for a temporary assignment.Chicago

Nurses

idshift_hoursspecialtyexperience
(→ Shifts.name)
1Morning ShiftEmergency Care5
2Afternoon ShiftPediatrics8
3Night ShiftICU3

Physical_therapists

idshift_hoursspecialtycertifications
(→ Shifts.name)
1Morning ShiftNeurological Rehab10
2Afternoon ShiftMusculoskeletal Disorders12
3Night ShiftCardiac Rehabilitation9

Doctors

idnamedepartmentyears_experience
1Dr. SmithCardiology7
2Dr. JohnsonOrthopedics10

Patients

idageconditiondoctor_idnurse_idtherapist_id
(→ Doctors.id)(→ Nurses.id)(→ Physical_therapists.id)
134Diabetes1NoneNone
268Heart Disease12None
342Arthritis1None2

Shifts

idname
1Day Shift
2Evening Shift
3Night Shift