| id | name | location |
|---|---|---|
| 1 | Ace Medical Center | 123 Main St |
| 2 | Beechwood Pharmacy | 456 Elm St |
| 3 | Cedar Health Solutions | 789 Oak St |
| 4 | Dogwood Apothecary | 098 Pine St |
| 5 | Evergreen Care Center | 675 Maple Ave |
| medication_id | type | dosage | side_effects |
|---|---|---|---|
| 1 | Pain Relievers | As directed | Allergic reactions, stomach upset |
| 2 | Anti-Inflammatories | As directed | Stomach bleeding, dizziness |
| 3 | Respiratory Medications | As directed | Dry mouth, headache |
| 4 | Cardiovascular Drugs | As directed | Dizziness, fatigue |
| 5 | Gastrointestinal Medications | As directed | Nausea, diarrhea |
| prescription_id | pharmacy_id | patient_name | date |
|---|---|---|---|
| (→ Pharmacies.id) | |||
| 1 | None | John Doe | 2021-10-01 |
| 2 | None | Jane Smith | 2021-10-02 |
| 3 | None | Michael Johnson | 2021-10-03 |
| 4 | None | Emily Davis | 2021-10-04 |
| 5 | None | David Brown | 2021-10-05 |
| 6 | 1 | John Doe | 2021-10-01 |
| 7 | 1 | Jane Smith | 2021-10-02 |
| 8 | 2 | Michael Johnson | 2021-10-03 |
| 9 | 2 | Emily Davis | 2021-10-04 |
| 10 | 3 | David Brown | 2021-10-05 |
| pharmacy_prescription_id | pharmacy_id | prescription_id | quantity |
|---|---|---|---|
| (→ Pharmacies.id) | (→ Prescriptions.prescription_id) | ||
| 1 | 1 | 1 | 10 |
| 2 | 1 | 2 | 15 |
| 3 | 2 | 3 | 20 |
| 4 | 2 | 4 | 25 |
| 5 | 3 | 5 | 30 |
| pharmacy_medication_id | pharmacy_id | medication_id |
|---|---|---|
| (→ Pharmacies.id) | (→ Medications.medication_id) | |
| 1 | 1 | 1 |
| 2 | 1 | 2 |
| 3 | 2 | 1 |
| 4 | 2 | 3 |
| 5 | 3 | 1 |
| 6 | 4 | 1 |
| 7 | 5 | 1 |