Patient

patientIDfirstNamelastName
1JohnDoe
2JaneSmith
3MichaelBrown
4EmilyWhite
5DavidBlack

Doctor

doctorIDfirstNamelastName
1Dr.Aaron
2Dr.Elizabeth
3Dr.Robert
4Dr.Nancy
5Dr.Kenneth

Prescription

prescriptionIDantibioticIDpatientIDdoctorIDdatePrescribed
(→ Antibiotic.antibioticID)(→ Patient.patientID)(→ Doctor.doctorID)
11112024-02-19 12:44:17
22222024-02-19 12:44:17
33332024-02-19 12:44:17
44442024-02-19 12:44:17
55552024-02-19 12:44:17

Common_Side_Effects

sideEffectIDdescription
1Diarrhea
2Vomiting
3Nausea
4Headache
5Dizziness

Serious_Side_Effects

seriousSideEffectIDdescription
1Allergic reactions
2Liver damage
3Stevens-Johnson syndrome
4Anaphylaxis
5Toxic epidermal necrolysis

Antibiotic

antibioticIDnamecommonSideEffectsseriousSideEffects
(→ Common_Side_Effects.sideEffectID)(→ Serious_Side_Effects.seriousSideEffectID)
1Amoxicillin13
2Azithromycin54
3Cephalexin54
4Clindamycin23
5Erythromycin13