Mall constructi...LOGIN

Mall construction table (Part 2)

Product attribute table

php-attr

QQ截图20170624145646.png

##attr_name: attribute name

attr_type: Attribute type 0: Unique attribute 1: Single-select attribute

attr_values: Attribute value

type_id: Corresponding type id

Brand table

php_brand

品牌.png

##brand_name:Name

brand_logo:logo

brand_url:Link address

Inventory table

php_product

库存表.png

goods_id: Product ID

goods_number: Inventory quantity

goods_attr: Inventory attribute

Product List

商品.png##goods_name: Product name

##goods_sn: Product number

original: Original image

sm_thumb: Small thumbnail

mid_thumb: Medium thumbnail

##max_thumb: Large thumbnail

market_price: Market price

shop_price: Our store price

onsale: Whether to put on the shelves '1', '0'

cate_id: column

brand_id: Brand

type_id: Product type

##goods_desc:Detailed description

goods_weight: Product weight

weight_unit: Weight unit

addtime: Shelf time

updatetime: Modification time

Product picture table

php_goods_pic

商品图片表.png

##goods_id: product id

original: original product Image

max_thumb: Large thumbnail

sm_thumb: Small thumbnail

Next Section

submitReset Code
ChapterCourseware