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 |