Consult the database design solution again. Consult the database design solution again. If you want to develop a clothing system by yourself, you may encounter a problem: a clothing may have multiple colors, multiple sizes (different numbers), and different colors (different numbers ), different sizes, different colors, and different prices. I would like to ask you how you can easily add products to the car purchasing function in this situation ?? ------ Solution ------------------ ID & nbsp; & consult the database design solution again.
Consult the database design solution again.
If you want to develop a clothing system on your own and encounter a problem,
That is, a clothing may have multiple colors, multiple sizes (different numbers), different colors (different numbers), different sizes, different colors, and different prices.
I would like to ask you how you can easily add products to the car purchasing function in this situation ??
------ 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 clothes in summer 01 kids_001 red 95 100
2 children's clothes in summer 02 kids_001 blue 98 100
3 children's clothes in summer 03 kids_001 purple 92 100
For customers and sellers, all products are independent and there is no such item. Only bundled sales are exceptions.