patientID | firstName | lastName | dateOfBirth |
---|---|---|---|
1 | John | Doe | 2000-07-16 |
2 | Jane | Smith | 1985-03-20 |
3 | Emily | Johnson | 1998-01-12 |
doctorID | firstName | lastName | specialty |
---|---|---|---|
1 | Dr. | Ahn | Cardiology |
2 | Dr. | Martinez | Neurology |
3 | Dr. | Lee | Pediatrics |
prescriptionID | patientID | drugID | quantity |
---|---|---|---|
(→ Patient.patientID) | (→ Drug.drugID) | ||
1 | 1 | 1 | 30 |
2 | 2 | 2 | 15 |
3 | 3 | 3 | 45 |
recordID | patientID | diagnosis | treatmentPlan |
---|---|---|---|
(→ Patient.patientID) | |||
1 | 1 | Hypertension | Monitor blood pressure and take medication as prescribed. |
2 | 2 | Migraine | Take pain relievers and avoid known triggers. |
drugID | name | dosage | sideEffectID | effectivenessID |
---|---|---|---|---|
(→ Side_Effects.sideEffectID) | (→ Effectiveness.effectivenessID) | |||
1 | Lisinopril | 5mg | 1 | 1 |
2 | Sumatriptan | 50mg | 2 | 2 |
3 | Aspirin | 325mg | 3 | 3 |
sideEffectID | effectText | severity |
---|---|---|
1 | Nausea | Moderate |
2 | Headache | Mild |
effectivenessID | percentage |
---|---|
1 | 80 |
2 | 70 |
3 | 90 |