patientID | firstName | lastName |
---|---|---|
1 | John | Doe |
2 | Jane | Smith |
3 | Michael | Brown |
4 | Emily | White |
5 | David | Black |
doctorID | firstName | lastName |
---|---|---|
1 | Dr. | Aaron |
2 | Dr. | Elizabeth |
3 | Dr. | Robert |
4 | Dr. | Nancy |
5 | Dr. | Kenneth |
prescriptionID | antibioticID | patientID | doctorID | datePrescribed |
---|---|---|---|---|
(→ Antibiotic.antibioticID) | (→ Patient.patientID) | (→ Doctor.doctorID) | ||
1 | 1 | 1 | 1 | 2024-02-19 12:44:17 |
2 | 2 | 2 | 2 | 2024-02-19 12:44:17 |
3 | 3 | 3 | 3 | 2024-02-19 12:44:17 |
4 | 4 | 4 | 4 | 2024-02-19 12:44:17 |
5 | 5 | 5 | 5 | 2024-02-19 12:44:17 |
sideEffectID | description |
---|---|
1 | Diarrhea |
2 | Vomiting |
3 | Nausea |
4 | Headache |
5 | Dizziness |
seriousSideEffectID | description |
---|---|
1 | Allergic reactions |
2 | Liver damage |
3 | Stevens-Johnson syndrome |
4 | Anaphylaxis |
5 | Toxic epidermal necrolysis |
antibioticID | name | commonSideEffects | seriousSideEffects |
---|---|---|---|
(→ Common_Side_Effects.sideEffectID) | (→ Serious_Side_Effects.seriousSideEffectID) | ||
1 | Amoxicillin | 1 | 3 |
2 | Azithromycin | 5 | 4 |
3 | Cephalexin | 5 | 4 |
4 | Clindamycin | 2 | 3 |
5 | Erythromycin | 1 | 3 |