## Pharmacies

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

## Medications

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

## Prescriptions

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_Prescriptions

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_Medications

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