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 |