There are four pieces of clothing, such as trousers, coats, underwear, and so, and each item has a different color. for example, the trousers are black, blue, and white. {code ...} then the size of each item is divided into men and women. XXLXXL female is s (a code smaller than X). XXL also requires the database of different properties of each item... there are four clothes, such as trousers, coats, underwear, and so.
Then each item has a different color.
For example, the trousers are black, blue, and white.
White, brown, red, underwear, black, white, pink, so, navy blue
Then each item is divided into male and female
Size: Male X XL XXL
Female: s (one code smaller than X) X XL
The inventory of different properties of each item is also required.
How to design such a table? could you please give me some advice on designing a database?
