| 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 |