Hospitals

idnamelocation
1St. Marys Hospital123 Main St
2New York General456 Broadway St
3Metro Medical Center789 Central Ave
4Cedars Sinai1011 Ocean Blvd
5John Hopkins2020 University Pl

Departments

iddepartmentName
1Cardiology
2Neurology
3Gastroenterology
4Orthopedics
5Pulmonary Medicine

Doctors

idnamespecialtyIdhospitalId
(→ Departments.id)(→ Hospitals.id)
1Dr. Smith11
2Dr. Johnson21
3Dr. Brown32
4Dr. Davis42
5Dr. Miller53

Patients

idfirstNamelastNameageillnessText
1JaneDoe35Flu
2MichaelSmith45Broken Arm
3EmilyJohnson25Anxiety
4DavidBrown65Diabetes
5KarenMiller55Asthma

Appointments

idpatientIddoctorIddatetimereasonForVisit
(→ Patients.id)(→ Doctors.id)
1112022-01-01 10:00:0010:00 AMInfluenza A
2222022-01-02 02:00:00 PM02:00 PMFractured wrist
3332022-01-03 03:00:00 PM03:00 PMPanic attack
4442022-01-04 04:00:00 PM04:00 PMShortness of breath
5552022-01-05 05:00:00 PM05:00 PMAllergies

Hospitals_Departments

hospitalIddepartmentId
(→ Hospitals.id)(→ Departments.id)
11
12
21
23
34
35
31
41
51