Product attribute table
php-attr
##attr_name: attribute nameattr_type: Attribute type 0: Unique attribute 1: Single-select attribute attr_values: Attribute value type_id: Corresponding type idBrand table
php_brand
brand_logo:logo
brand_url:Link address
Inventory table
php_product
goods_id: Product ID
goods_number: Inventory quantity
goods_attr: Inventory attribute
Product List
##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
##goods_id: product id
original: original product Image
max_thumb: Large thumbnail
sm_thumb: Small thumbnail