## Patient

patientID | firstName | lastName
--- | --- | ---
1 | John | Doe
2 | Jane | Smith
3 | Michael | Brown
4 | Emily | White
5 | David | Black

## Doctor

doctorID | firstName | lastName
--- | --- | ---
1 | Dr. | Aaron
2 | Dr. | Elizabeth
3 | Dr. | Robert
4 | Dr. | Nancy
5 | Dr. | Kenneth

## Prescription

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

## Common_Side_Effects

sideEffectID | description
--- | ---
1 | Diarrhea
2 | Vomiting
3 | Nausea
4 | Headache
5 | Dizziness

## Serious_Side_Effects

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

## Antibiotic

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