| 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 |
| id | shift_hours | specialty | experience |
|---|---|---|---|
| (→ Shifts.name) | |||
| 1 | Morning Shift | Emergency Care | 5 |
| 2 | Afternoon Shift | Pediatrics | 8 |
| 3 | Night Shift | ICU | 3 |
| 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 |
| id | name | department | years_experience |
|---|---|---|---|
| 1 | Dr. Smith | Cardiology | 7 |
| 2 | Dr. Johnson | Orthopedics | 10 |
| 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 |
| id | name |
|---|---|
| 1 | Day Shift |
| 2 | Evening Shift |
| 3 | Night Shift |