id | name |
---|---|
1 | Western Medical Center |
2 | Eastern General Hospital |
3 | Northern Healthcare |
4 | Central Care Clinic |
5 | City Urgent Care |
id | title | description | location | salary | hospital_id |
---|---|---|---|---|---|
(→ Hospitals.id) | |||||
1 | CT Scan Technician | Perform CT scans on patients. | New York City | 90000 | 1 |
2 | MRI Tech | Operate MRI machines. | New York City | 85000 | 1 |
3 | ER Physician | Treat emergency cases. | New York City | 200000 | 1 |
4 | Anesthesia Nurse | Monitor patient during surgeries. | New York City | 100000 | 1 |
5 | Pharmacist | Dispense medications. | New York City | 95000 | 1 |
6 | Family Medicine Doctor | Diagnose and treat illnesses. | Chicago | 160000 | 2 |
7 | Dietitian | Create diet plans for patients. | Chicago | 70000 | 2 |
id | name | specialist_doctor | hospital_id |
---|---|---|---|
(→ Hospitals.id) | |||
1 | Dr. Jane Smith | Radiologist | 1 |
2 | Dr. John Brown | Radiologist | 2 |
3 | Ms. Mary Johnson | Ultrasound Technician | 1 |
4 | Mr. Mike Davis | Ultrasound Technician | 2 |
5 | Dr. Sarah Wilson | Cardiologist | 3 |
6 | Dr. James White | Gastroenterologist | 4 |
7 | Dr. Jennifer Green | Neurologist | 1 |
8 | Dr. David Black | Orthopedic Surgeon | 2 |