A, order once submitted to come over there will be A variety of products, such as: large number of small class A - A - goods, big B - small class B - the number of goods, big goods C - A small number of class C -
Two, processing commodity classification information, GET out the goods corresponding to the ID, inventory and small goods
Three, processing order information generated inventory, generate order ID
Goods 4, processing categories A and B categories of commodities, the categories of information C outbound goods
1, the categories of goods discrepancy information don't know how to design the database [later need for ins and outs of statistical correlation information]
2, at present the idea of
Table ID automatically associated order ID associated large commodity ID associated outbound order number associated procurement warehousing
ID ID ID number number
3, submitted an order goods more than N type
More than 4, should one-time insert data
5, the uncertainty of the order: update, invalid delete [each update order also need to deal with multiple one-off]
Table ID automatically associated order ID associated large commodity ID associated outbound order number associated procurement warehousing
New order ID detergent ID 1 out of 10
The new order ID 1 toothpaste ID 100
The new order ID 1 hand cream ID 1
6, update the order/red part is knocked out
Table ID automatically associated order ID associated large commodity ID associated outbound order number associated procurement warehousing
New order ID detergent ID 1 out of 10
The new order ID 1 toothpaste ID 100
The new order ID 1 hand cream ID 1
7, after the actual update orders should be
Table ID automatically associated order ID associated large commodity ID associated outbound order number associated procurement warehousing
New order ID detergent ID 1 out of 10
New detergent ID ID order 1 to 8

8, the classification of the categories of goods should be how to design a reasonable?



If each update orders need to update the quantity or remove the quantity, the table design is too unreasonable?