Database clothing inventory table design?

Hello
as shown in the following picture, the inventory table of the clothing industry like this, how to design the database, the color and size of each order may be different.

Mar.11,2021

you can set three fields: color, size type and size, such as

| color | size_type | size |
| Rice White | char | S |
| original White | length | 170 |


there should be a field in the order table that directly stores the information of all specifications in string form, such as
attr: black, M code.
this is just for convenience. Of course, you also need an accurate id,
for each item of each order, and then you have to have an "order specification form". The fields should include:
id,
order_id: order number.
goods_id: merchandise id
attr: merchandise attribute (specification), such as color, size
value: attribute value, such as white, M code

.


clipboard.png
main table of product: goods
option: attribute table, that is,
option_value: attribute value table of color, size, fabric, etc., that is, red, blue, L, M, S, pure cotton, etc.
product_variant: commodity SKU table
product_variant_option_value: commodity SKU corresponding attribute value table

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1b3350d-4d522.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1b3350d-4d522.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?