E-commerce website product database design, e-commerce product database

E-commerce website product database design, e-commerce product database

1. I recently learned how to use java + mysql to create a small e-commerce project instance. First, I want to design a data table related to the product, as shown in figure

 

2. In general design, the product attributes will be placed in the product table, such as color, specification, and size. However, I have two separate tables for the attribute, one for the attribute name and the other for the attribute.

3. I was thinking about the brand table, but later I thought about how to place the brand in the Attribute Table, store the product as an attribute in the P_Property table, and then store the value corresponding to the brand to the attribute value table.

4. I don't know if there is any lack of such design. I hope that there will be great e-commerce experts who will guide you.