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 |