## Patient

patientID | firstName | lastName | dateOfBirth
--- | --- | --- | ---
1 | John | Doe | 2000-07-16
2 | Jane | Smith | 1985-03-20
3 | Emily | Johnson | 1998-01-12

## Doctor

doctorID | firstName | lastName | specialty
--- | --- | --- | ---
1 | Dr. | Ahn | Cardiology
2 | Dr. | Martinez | Neurology
3 | Dr. | Lee | Pediatrics

## Prescription

prescriptionID | patientID | drugID | quantity
--- | --- | --- | ---
| (→ Patient.patientID) | (→ Drug.drugID) |
1 | 1 | 1 | 30
2 | 2 | 2 | 15
3 | 3 | 3 | 45

## MedicalRecord

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.

## Drug

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

## Side_Effects

sideEffectID | effectText | severity
--- | --- | ---
1 | Nausea | Moderate
2 | Headache | Mild

## Effectiveness

effectivenessID | percentage
--- | ---
1 | 80
2 | 70
3 | 90