| id | name |
|---|---|
| 1 | 0-4 |
| 2 | 5-9 |
| 3 | 10-13 |
| 4 | 14-17 |
| 5 | 18+ |
| id | condition_name |
|---|---|
| 1 | Diabetes |
| 2 | Hypertension |
| 3 | Asthma |
| 4 | Allergy |
| 5 | Obesity |
| 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_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_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_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_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 |