## 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