Age_Group

idname
10-4
25-9
310-13
414-17
518+

Health_Condition

idcondition_name
1Diabetes
2Hypertension
3Asthma
4Allergy
5Obesity

Vaccine

idvaccine_nameage_group_idhealth_condition_id
(→ Age_Group.id)(→ Health_Condition.id)
1Flu24
2Pneumonia31
3Hepatitis B13
4Meningococcal42
5Varicella15

Patient

patient_idfirst_namelast_namebirthdatephone_numberage_group_id
(→ Age_Group.id)
1JohnDoe1995-06-15555-123-45673
2JaneSmith2000-07-20555-987-65435
3MichaelBrown1990-08-25555-555-55554
4EmilyGreen1988-09-15555-333-33332
5WilliamBlack1975-10-20555-222-22226

Doctor

doctor_idfirst_namelast_namespecialty
1Dr.JonesCardiology
2Dr.GarciaEndocrinology
3Dr.LeePediatrics
4Dr.TaylorNeurology
5Dr.AdamsNephrology

Appointment

appointment_iddatepatient_iddoctor_idmedicalrecord_id
(→ Patient.patient_id)(→ Doctor.doctor_id)(→ MedicalRecord.medicalrecord_id)
12022-10-12 10:00:00111
22022-10-13 14:00:00222
32022-10-14 16:00:00333
42022-10-15 18:00:00444
52022-10-16 20:00:00555

MedicalRecord

medicalrecord_idpatient_iddiagnosistreatment_plan
(→ Patient.patient_id)
11Type 2 DiabetesDiet and Exercise
22EpilepsyAntiepileptic Drugs
33Anxiety DisorderCounseling and Medication
44DepressionAntidepressants
55AsthmaInhalers