id | name |
---|---|
1 | Western Medical Center |
2 | Eastern General Hospital |
3 | Northern Healthcare System |
4 | Central Valley Clinic |
id | hospital_id | first_name | last_name |
---|---|---|---|
(→ Hospital.id) | |||
1 | 1 | John | Doe |
2 | 2 | Jane | Smith |
3 | 3 | Alice | Brown |
4 | 4 | Michael | Johnson |
id | hospital_id | first_name | last_name |
---|---|---|---|
(→ Hospital.id) | |||
1 | 1 | Emma | Jones |
2 | 2 | David | Williams |
3 | 3 | Lisa | Martin |
4 | 4 | Robert | Thomas |
id | title | description | salary | post_date |
---|---|---|---|---|
1 | Radiologist | Perform diagnostic imaging procedures. | 80000.0 | 2022-01-01 |
2 | Ultrasound Technician | Operate ultrasound equipment for medical imaging. | 60000.0 | 2022-01-02 |
3 | Radiographer | Produce X-ray images and other diagnostic images. | 70000.0 | 2022-01-03 |
4 | Diagnostic Medical Sonographer | Conduct ultrasound examinations on patients. | 65000.0 | 2022-01-04 |
5 | Healthcare Administrator | Manage healthcare facility operations and staff. | 55000.0 | 2022-01-05 |
radiologist_id | job_posting_id | start_date | end_date |
---|---|---|---|
(→ Radiologist.id) | (→ JobPosting.id) | ||
1 | 1 | 2022-01-15 | 2023-01-15 |
2 | 2 | 2022-01-20 | 2023-01-20 |
3 | 3 | 2022-01-25 | 2023-01-25 |
4 | 4 | 2022-01-30 | 2023-01-30 |
tech_id | job_posting_id | start_date | end_date |
---|---|---|---|
(→ Ultrasound_Tech.id) | (→ JobPosting.id) | ||
1 | 1 | 2022-01-16 | 2023-01-16 |
2 | 2 | 2022-01-21 | 2023-01-21 |
3 | 3 | 2022-01-26 | 2023-01-26 |
4 | 4 | 2022-01-31 | 2023-01-31 |