Home  >  Article  >  Backend Development  >  How to design a product SKU table in PHP

How to design a product SKU table in PHP

WBOY
WBOYOriginal
2016-10-18 08:41:573182browse

Now there are four pieces of clothing, such as pants, jacket, underwear and socks

Then each product has different colors
For example, pants are available in black, blue and white

<code>外套有  白色 棕色  红色 
内衣有 黑色 白色  粉红色
袜子有 花色 藏青色 
</code>

Then each product is divided into men and women
The size is male X XL XXL

For women, size s (one size smaller than X) X XL

We also need inventory with different attributes for each product.
How to design such a table? Please give me some advice and design a database

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn