Healthcare_Centers

CenterIDCenterNameAddress
1Center1Address1
2Center2Address2
3Center3Address3
4Center4Address4
5Center5Address5

Programs

ProgramIDProgramType
1Wellness_Initiatives
2Disease_Prevention
3Hospitality
4Fitness
5Emergency

Patients

PatientIDFirstNameLastNameAgeCenterID
(→ Healthcare_Centers.CenterID)
1JohnDoe301
2JaneSmith282
3MikeBrown263
4EmmaWilson324
5DavidJackson405

Doctors

DoctorIDNameSpecializationCenterID
(→ Healthcare_Centers.CenterID)
1Dr. SmithCardiology1
2Dr. JohnsonNeurology2
3Dr. WilliamsOrthopedics3
4Dr. ThompsonPediatrics4
5Dr. BrownGastroenterology5

Appointments

AppointmentIDPatientIDDoctorIDDate
(→ Patients.PatientID)(→ Doctors.DoctorID)
1112022-07-15 10:00:00
2222022-07-18 14:00:00
3332022-07-20 09:00:00
4442022-07-22 15:00:00
5552022-07-24 16:00:00

MedicalHistory

HistoryIDPatientIDDiagnosisTreatment
(→ Patients.PatientID)
11DiabetesInsulin Injections
22High Blood PressureMedication
33AsthmaInhaler
44Broken ArmCast
55AnemiaIron Supplements

Healthcare_Centers_Programs

CenterIDProgramIDStartDateEndDate
(→ Healthcare_Centers.CenterID)(→ Programs.ProgramID)
112022-06-012022-08-31
122022-09-012022-11-30
212022-06-012022-08-31
222022-09-012022-11-30
312022-06-012022-08-31
322022-09-012022-11-30
412022-06-012022-08-31
422022-09-012022-11-30
512022-06-012022-08-31
522022-09-012022-11-30