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 |