Hospitals
id | name | location |
1 | St. Marys Hospital | 123 Main St |
2 | New York General | 456 Broadway St |
3 | Metro Medical Center | 789 Central Ave |
4 | Cedars Sinai | 1011 Ocean Blvd |
5 | John Hopkins | 2020 University Pl |
Departments
id | departmentName |
1 | Cardiology |
2 | Neurology |
3 | Gastroenterology |
4 | Orthopedics |
5 | Pulmonary Medicine |
Doctors
id | name | specialtyId | hospitalId |
| | (→ Departments.id) | (→ Hospitals.id) |
1 | Dr. Smith | 1 | 1 |
2 | Dr. Johnson | 2 | 1 |
3 | Dr. Brown | 3 | 2 |
4 | Dr. Davis | 4 | 2 |
5 | Dr. Miller | 5 | 3 |
Patients
id | firstName | lastName | age | illnessText |
1 | Jane | Doe | 35 | Flu |
2 | Michael | Smith | 45 | Broken Arm |
3 | Emily | Johnson | 25 | Anxiety |
4 | David | Brown | 65 | Diabetes |
5 | Karen | Miller | 55 | Asthma |
Appointments
id | patientId | doctorId | date | time | reasonForVisit |
| (→ Patients.id) | (→ Doctors.id) | | | |
1 | 1 | 1 | 2022-01-01 10:00:00 | 10:00 AM | Influenza A |
2 | 2 | 2 | 2022-01-02 02:00:00 PM | 02:00 PM | Fractured wrist |
3 | 3 | 3 | 2022-01-03 03:00:00 PM | 03:00 PM | Panic attack |
4 | 4 | 4 | 2022-01-04 04:00:00 PM | 04:00 PM | Shortness of breath |
5 | 5 | 5 | 2022-01-05 05:00:00 PM | 05:00 PM | Allergies |
Hospitals_Departments
hospitalId | departmentId |
(→ Hospitals.id) | (→ Departments.id) |
1 | 1 |
1 | 2 |
2 | 1 |
2 | 3 |
3 | 4 |
3 | 5 |
3 | 1 |
4 | 1 |
5 | 1 |