Home > Article > Backend Development > How to design a product SKU table in PHP
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