## Age_Group

id | name
--- | ---
1 | 0-4
2 | 5-9
3 | 10-13
4 | 14-17
5 | 18+

## Health_Condition

id | condition_name
--- | ---
1 | Diabetes
2 | Hypertension
3 | Asthma
4 | Allergy
5 | Obesity

## Vaccine

id | vaccine_name | age_group_id | health_condition_id
--- | --- | --- | ---
|  | (→ Age_Group.id) | (→ Health_Condition.id)
1 | Flu | 2 | 4
2 | Pneumonia | 3 | 1
3 | Hepatitis B | 1 | 3
4 | Meningococcal | 4 | 2
5 | Varicella | 1 | 5

## Patient

patient_id | first_name | last_name | birthdate | phone_number | age_group_id
--- | --- | --- | --- | --- | ---
|  |  |  |  | (→ Age_Group.id)
1 | John | Doe | 1995-06-15 | 555-123-4567 | 3
2 | Jane | Smith | 2000-07-20 | 555-987-6543 | 5
3 | Michael | Brown | 1990-08-25 | 555-555-5555 | 4
4 | Emily | Green | 1988-09-15 | 555-333-3333 | 2
5 | William | Black | 1975-10-20 | 555-222-2222 | 6

## Doctor

doctor_id | first_name | last_name | specialty
--- | --- | --- | ---
1 | Dr. | Jones | Cardiology
2 | Dr. | Garcia | Endocrinology
3 | Dr. | Lee | Pediatrics
4 | Dr. | Taylor | Neurology
5 | Dr. | Adams | Nephrology

## Appointment

appointment_id | date | patient_id | doctor_id | medicalrecord_id
--- | --- | --- | --- | ---
|  | (→ Patient.patient_id) | (→ Doctor.doctor_id) | (→ MedicalRecord.medicalrecord_id)
1 | 2022-10-12 10:00:00 | 1 | 1 | 1
2 | 2022-10-13 14:00:00 | 2 | 2 | 2
3 | 2022-10-14 16:00:00 | 3 | 3 | 3
4 | 2022-10-15 18:00:00 | 4 | 4 | 4
5 | 2022-10-16 20:00:00 | 5 | 5 | 5

## MedicalRecord

medicalrecord_id | patient_id | diagnosis | treatment_plan
--- | --- | --- | ---
| (→ Patient.patient_id) |  |
1 | 1 | Type 2 Diabetes | Diet and Exercise
2 | 2 | Epilepsy | Antiepileptic Drugs
3 | 3 | Anxiety Disorder | Counseling and Medication
4 | 4 | Depression | Antidepressants
5 | 5 | Asthma | Inhalers