Design ideas for MySQL commodity table (Object-oriented table: Classes and objects)

Learning Address

http://www.jtthink.com/course/play/352

Main Table: Prop_main

Do not say more carefully, normal business will be involved and considered relatively comprehensive. Characters commonly used segment "Product ID" "Product name" "Product Profile" "Product category" "Add Time" "hits/Likes/purchases/bad reviews"

The point is that "clicks/likes/purchases/Bad reviews" are updated regularly. But for speed and efficiency when reading, it is very scientific to put it in the commodity table as a redundant field.

Focus on the design of "commodity category"

Product Type table: Prop_class

This is also common, and each product must be subordinate to a certain type. The usual field design is simply "Category ID" "Category name"

Commodity class Attribute table: prop_class_attr

Product attribute table: prop_attr

Design ideas for MySQL commodity table (Object-oriented table: Classes and objects)