Mall construction table (Part 1)

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