Pharmacies

idnamelocation
1Ace Medical Center123 Main St
2Beechwood Pharmacy456 Elm St
3Cedar Health Solutions789 Oak St
4Dogwood Apothecary098 Pine St
5Evergreen Care Center675 Maple Ave

Medications

medication_idtypedosageside_effects
1Pain RelieversAs directedAllergic reactions, stomach upset
2Anti-InflammatoriesAs directedStomach bleeding, dizziness
3Respiratory MedicationsAs directedDry mouth, headache
4Cardiovascular DrugsAs directedDizziness, fatigue
5Gastrointestinal MedicationsAs directedNausea, diarrhea

Prescriptions

prescription_idpharmacy_idpatient_namedate
(→ Pharmacies.id)
1NoneJohn Doe2021-10-01
2NoneJane Smith2021-10-02
3NoneMichael Johnson2021-10-03
4NoneEmily Davis2021-10-04
5NoneDavid Brown2021-10-05
61John Doe2021-10-01
71Jane Smith2021-10-02
82Michael Johnson2021-10-03
92Emily Davis2021-10-04
103David Brown2021-10-05

Pharmacy_Prescriptions

pharmacy_prescription_idpharmacy_idprescription_idquantity
(→ Pharmacies.id)(→ Prescriptions.prescription_id)
11110
21215
32320
42425
53530

Pharmacy_Medications

pharmacy_medication_idpharmacy_idmedication_id
(→ Pharmacies.id)(→ Medications.medication_id)
111
212
321
423
531
641
751