Consult the database design again.
Consult the database design again.
Want to develop a clothing system yourself, encounter a problem,
is a garment may have more than one color, there are a variety of sizes (number of different), a variety of colors (the number of different), different sizes and colors are different prices, I le a go.
Want to ask the heroes, you encounter this situation, how to dial, but also to facilitate the product to buy car function??
------Solution--------------------
ID Product name Product ID model color price Inventory quantity
ID pro_name pro_id pro_type pro_color pro_price pro_num
1 children's dress summer kids_001 Red 100
2 Kids Summer kids_001 Blue 98 100
3 Children's dress summer kids_001 Purple 100
For the customer and the merchant, all the goods are independent, there is no one. There's only one exception to the bundled sale.