Mall building table
As a large website, the fields of the mall need to be well designed to cope with large traffic visits. Our mall will imitate Use the ecshop mall to create a table.
Type table
php_type
##type_name: Type name
product Attribute table
php_attr
id: auto-increment id
attr_name: attribute name
attr_type: Attribute type 0: Unique attribute 1: Single-select attribute
attr_values: Attribute value
type_id: Corresponding type id
Member table
php_member
username:user name
password:user password
email: Email
check_mail: Whether it has been verified 0: Not verified 1: Verified
mail_str: Email verification string
sex: 0: Confidential 1: Male 2: Female
points: points
money: balance
regtime: registration time
Member level table
php_member_level
#level_name :Level name
points_min: Points lower limit
points_max: Points upper limit
rate: Discount Rate
Member Price List
##php_member_level
price: member level price
level_id: level id
goods_id: product id
Next Section