About the inventory in enters sells saves the subsidiary database design-CodePudding

company to develop a enters sells saves the ERP system, a detailed inventory query requirements, ask how to database design,

Prototype and business rules as shown in the figure below:

requirement:
1. How to design the database, or what kind of middleware, or cache, or code processing logic can efficiently achieve the demand of the figure described in,
2. I also need to provide an interface for other modules to query a commodity by the end of the day "the balance cost" and "account number",

please have this business experience predecessors advice,

CodePudding user response:

Inventory table, the unit price table, can completely solve the operating table

CodePudding user response:

reference 1st floor Xu Xiaotao _nice response:

inventory table, the unit price table, operation table can completely solve the

Can the auspicious said in detail

CodePudding user response:

references to stay up late on the second floor of the cat's reply:

Quote: refer to 1st floor Xu Xiaotao _nice response:

Inventory table, the unit price table, operation table can completely solve the

Can the auspicious elaborate said

is ordinary sku operation, brother