Consult the database design solution again

Source: Internet
Author: User
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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.