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