Premise that many goods corresponding to many stores, many-to-many relationship, a product can be in many stores at the same time,

Required to query the current position, from near to far store goods, the list of goods is not repeated, can according to the city at the same time, merchandise sales and other screening

Question: according to the above, how to design the relationship between goods and stores table

CodePudding user response:

Can store as a warehouse, store associated city
Build a table goods, warehouse building a table, a detailed inventory built a table, according to sales, sales of goods store, can be analyzed and then the city

Query the current position, from near to far stores goods, it is not very understand