Patient

patientIDfirstNamelastNamedateOfBirth
1JohnDoe2000-07-16
2JaneSmith1985-03-20
3EmilyJohnson1998-01-12

Doctor

doctorIDfirstNamelastNamespecialty
1Dr.AhnCardiology
2Dr.MartinezNeurology
3Dr.LeePediatrics

Prescription

prescriptionIDpatientIDdrugIDquantity
(→ Patient.patientID)(→ Drug.drugID)
11130
22215
33345

MedicalRecord

recordIDpatientIDdiagnosistreatmentPlan
(→ Patient.patientID)
11HypertensionMonitor blood pressure and take medication as prescribed.
22MigraineTake pain relievers and avoid known triggers.

Drug

drugIDnamedosagesideEffectIDeffectivenessID
(→ Side_Effects.sideEffectID)(→ Effectiveness.effectivenessID)
1Lisinopril5mg11
2Sumatriptan50mg22
3Aspirin325mg33

Side_Effects

sideEffectIDeffectTextseverity
1NauseaModerate
2HeadacheMild

Effectiveness

effectivenessIDpercentage
180
270
390