| id | name |
|---|---|
| 1 | Western Medical Center |
| 2 | Eastern General Hospital |
| 3 | Northern Healthcare |
| 4 | Central Care Clinic |
| 5 | City Urgent Care |
| id | name |
|---|---|
| 1 | Cardiology |
| 2 | Gastroenterology |
| 3 | Neurology |
| 4 | Orthopedics |
| 5 | Pulmonology |
| id | name | specialist_doctor | hospital_id |
|---|---|---|---|
| (→ Specialties.name) | (→ 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 |
| 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 |
| application_id | doctor_id | job_id | status |
|---|---|---|---|
| (→ Doctors.id) | (→ Jobs.id) | ||
| 1 | 1 | 1 | Accepted |
| 2 | 2 | 5 | Rejected |
| 3 | 3 | 6 | In Review |
| 4 | 4 | 7 | Interviewing |
| 5 | 5 | 1 | Rejected |
| 6 | 6 | 2 | Accepted |
| 7 | 7 | 3 | In Review |
| 8 | 8 | 4 | Rejected |