## Jobs

id | title | description | location
--- | --- | --- | ---
1 | Cardiologist | Experienced Cardiologist needed for full time position. | New York
2 | Dentist | General Dentist required for part-time role. | Los Angeles
3 | Radiographer | Seeking experienced Radiographer for a temporary assignment. | Chicago

## Nurses

id | shift_hours | specialty | experience
--- | --- | --- | ---
| (→ Shifts.name) |  |
1 | Morning Shift | Emergency Care | 5
2 | Afternoon Shift | Pediatrics | 8
3 | Night Shift | ICU | 3

## Physical_therapists

id | shift_hours | specialty | certifications
--- | --- | --- | ---
| (→ Shifts.name) |  |
1 | Morning Shift | Neurological Rehab | 10
2 | Afternoon Shift | Musculoskeletal Disorders | 12
3 | Night Shift | Cardiac Rehabilitation | 9

## Doctors

id | name | department | years_experience
--- | --- | --- | ---
1 | Dr. Smith | Cardiology | 7
2 | Dr. Johnson | Orthopedics | 10

## Patients

id | age | condition | doctor_id | nurse_id | therapist_id
--- | --- | --- | --- | --- | ---
|  |  | (→ Doctors.id) | (→ Nurses.id) | (→ Physical_therapists.id)
1 | 34 | Diabetes | 1 | None | None
2 | 68 | Heart Disease | 1 | 2 | None
3 | 42 | Arthritis | 1 | None | 2

## Shifts

id | name
--- | ---
1 | Day Shift
2 | Evening Shift
3 | Night Shift