How to design the product table and product attributes in the mall is better

My product is like an iPhone 6 s mobile phone, and the color is Champagne, silver, and gray. There are 16G, 32G, and 64G in different colors. You think it is a color + version + product ID. in this way, a product has many products, such as the details of public products, etc. what is not public is the product phase... my iphone 6 s is like champagne, silver, and gray. There are 16G, 32G, and 64G in different colors.
You think it is color + version + product ID = a product. in this way, a product has many products, such as the details of public products, product photos, and introductions.
In this case, we should treat all the color versions as a commodity ID.

Reply content:

My iphone 6 s is like champagne, silver, and gray. There are 16G, 32G, and 64G in different colors.
You think it is color + version + product ID = a product. in this way, a product has many products, such as the details of public products, product photos, and introductions.
In this case, we should treat all the color versions as a commodity ID.

The color and capacity are equal. The attributes of a product.
The product table + product attribute table should be ready.
The product attribute table includes the property name (such as color) and property value (black ).
The commodity table is simple. Some inherent attributes, such as inventory and price

Separate two tables, one 6s, and multiple attributes. if you do not separate other attributes such as the speed, it will be too messy to create an attachment table for easy management.

Get the spu, and the sku will be ready.