## Specialists

specialist_id | specialty | hospital_name | years_of_experience | salary
--- | --- | --- | --- | ---
1 | Radiologist | Western Medical Center | 7 | 80000.0
2 | Radiologist | St. Luke's Hospital | 6 | 90000.0
3 | Ultrasound Technician | Western Medical Center | 5 | 60000.0
4 | Ultrasound Technician | Memorial Hospital | 4 | 55000.0

## Hospitals

hospital_id | name | location | number_of_beds | annual_revenue
--- | --- | --- | --- | ---
1 | Western Medical Center | California | 250 | 200000000.0
2 | St. Luke's Hospital | New York | 300 | 150000000.0
3 | Memorial Hospital | Florida | 150 | 100000000.0

## Departments

department_id | name | description | budget
--- | --- | --- | ---
1 | Medical Imaging Department | This department provides diagnostic imaging services using X-ray machines, ultrasounds, MRI scanners etc. | 100000.0
2 | Surgery Department | A team of surgeons perform various operations including open surgery and minimally invasive procedures. | 200000.0

## Jobs

job_id | title | description | required_skills | starting_salary | posted_date
--- | --- | --- | --- | --- | ---
1 | Radiologist | A radiologist interprets x-rays, CT scans, MRIs, and other medical images to diagnose disease. | Knowledge of anatomy, strong problem-solving skills, excellent communication skills. | 80000.0 | 2024-03-07 21:24:38
2 | Ultrasound Technician | An ultrasonographer operates ultrasound equipment to visualize internal organs and tissues, guide biopsies and other needle procedures. | Strong technical skills, physical stamina, good bedside manner. | 60000.0 | 2024-03-07 21:24:38

## Applications

application_id | applicant_name | email | phone_number | resume | cover_letter | applied_on
--- | --- | --- | --- | --- | --- | ---
1 | John Doe | johndoe@gmail.com | 555-123-4567 | resume.pdf | cover_letter.txt | 2021-01-01 00:00:00
2 | Jane Smith | janesmith@yahoo.com | 555-987-6543 | resumeworker.docx | cov_let.odt | 2021-01-10 00:00:00