DEV Community

Discussion on: Best way to store pharmacies + medicine in MySQL?

Collapse
 
newelement profile image
Don Jones  • Edited

You need a table to store all the pharmacies. You will need a table to store all the medicines. Then you need a pivot table to assign medicines to pharmacies. Please look into pivot tables and how to join your tables in a query.