| 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 |