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