## Hospital

id | name
--- | ---
1 | Western Medical Center
2 | Eastern General Hospital
3 | Northern Healthcare System
4 | Central Valley Clinic

## Radiologist

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

## Ultrasound_Tech

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

## JobPosting

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

## RadiologistJob

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

## TechJob

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