zqm_goods
- 商品表
字段 | 类型 | 允许空 | 默认 | 注释 |
---|---|---|---|---|
goods_id | int(10) unsigned | NO | NULL | 商品id(SKU) |
goods_commonid | int(10) unsigned | NO | NULL | 商品公共表id |
goods_name | varchar(50) | NO | NULL | 商品名称( 规格名称) |
goods_jingle | varchar(150) | YES | 商品广告词 | |
store_id | int(10) unsigned | NO | NULL | 店铺id |
store_name | varchar(50) | NO | NULL | 店铺名称 |
gc_id | int(10) unsigned | NO | NULL | 商品分类id |
gc_id_1 | int(10) unsigned | NO | NULL | 一级分类id |
gc_id_2 | int(10) unsigned | NO | NULL | 二级分类id |
gc_id_3 | int(10) unsigned | NO | NULL | 三级分类id |
brand_id | int(10) unsigned | YES | 0 | 品牌id |
goods_price | decimal(10,2) | NO | NULL | 商品价格 |
goods_promotion_price | decimal(10,2) | NO | NULL | 商品促销价格 |
goods_promotion_type | tinyint(3) unsigned | NO | 0 | 促销类型 0无促销,1团购,2限时折扣 |
goods_marketprice | decimal(10,2) | NO | NULL | 市场价 |
goods_serial | varchar(50) | YES | 商品货号 | |
goods_storage_alarm | tinyint(3) unsigned | NO | NULL | 库存报警值 |
goods_click | int(10) unsigned | NO | 0 | 商品点击数量 |
goods_salenum | int(10) unsigned | NO | 0 | 销售数量 |
goods_collect | int(10) unsigned | NO | 0 | 收藏数量 |
goods_spec | text | NO | NULL | 商品规格序列化 |
goods_storage | int(10) unsigned | NO | 0 | 商品库存 |
goods_image | varchar(100) | NO | 商品主图 | |
goods_state | tinyint(3) unsigned | NO | NULL | 商品状态 0下架,1正常,10违规(禁售) |
goods_verify | tinyint(3) unsigned | NO | NULL | 商品审核 1通过,0未通过,10审核中 |
goods_addtime | int(10) unsigned | NO | NULL | 商品添加时间 |
goods_edittime | int(10) unsigned | NO | NULL | 商品编辑时间 |
areaid_1 | int(10) unsigned | NO | NULL | 一级地区id |
areaid_2 | int(10) unsigned | NO | NULL | 二级地区id |
color_id | int(10) unsigned | NO | 0 | 颜色规格id |
transport_id | mediumint(8) unsigned | NO | NULL | 运费模板id |
goods_freight | decimal(10,2) unsigned | NO | 0.00 | 运费 0为免运费 |
goods_vat | tinyint(3) unsigned | NO | 0 | 是否开具增值税发票 1是,0否 |
goods_commend | tinyint(3) unsigned | NO | 0 | 商品推荐 1是,0否 默认0 |
goods_stcids | varchar(255) | YES | 店铺分类id 首尾用,隔开 | |
evaluation_good_star | tinyint(3) unsigned | NO | 5 | 好评星级 |
evaluation_count | int(10) unsigned | NO | 0 | 评价数 |
is_virtual | tinyint(3) unsigned | NO | 0 | 是否为虚拟商品 1是,0否 |
virtual_indate | int(10) unsigned | NO | NULL | 虚拟商品有效期 |
virtual_limit | tinyint(3) unsigned | NO | NULL | 虚拟商品购买上限 |
virtual_invalid_refund | tinyint(3) unsigned | NO | 1 | 是否允许过期退款, 1是,0否 |
is_fcode | tinyint(4) | NO | 0 | 是否为F码商品 1是,0否 |
is_appoint | tinyint(3) unsigned | NO | 0 | 是否是预约商品 1是,0否 |
is_presell | tinyint(3) unsigned | NO | 0 | 是否是预售商品 1是,0否 |
have_gift | tinyint(3) unsigned | NO | 0 | 是否拥有赠品 |
is_own_shop | tinyint(3) unsigned | NO | 0 | 是否为平台自营 |
zc_id | mediumint(9) unsigned | NO | NULL | 学校id |
zc_name | varchar(10) | NO | NULL | 学校名称 |
delivery | enum('nursery','primary','junior_high','senior_high','secondary','junior_college','university') | NO | primary | 适用范围(nursery:幼儿园,primary:小学,junior_high:初中,senior_high:高中,secondary中专,junior_college:大专,university:大学) |
grade | tinyint(2) | NO | NULL | 年级 |
school_type | enum('3','4','5','6') | NO | NULL | 年制 |
sys_id | varchar(50) | NO | NULL | 助手id |
author | varchar(50) | NO | 著作 | |
translator | varchar(50) | NO | 译者 | |
publishing_company | varchar(255) | NO | 出版社 | |
isbn | varchar(50) | NO | ISBN | |
revision | tinyint(1) unsigned | NO | 1 | 版次 |
packing | varchar(50) | NO | 包装 | |
folio | varchar(50) | NO | 开本 | |
publication_time | int(10) unsigned | NO | 0 | 出版时间 |
printing_time | int(10) unsigned | NO | 0 | 印刷时间 |
paper | varchar(50) | NO | 纸张 | |
num_count | int(10) unsigned | NO | 0 | 字数 |
page_count | int(10) unsigned | NO | 0 | 页数 |
impression | tinyint(10) unsigned | NO | 0 | 印次 |
binding | varchar(100) | NO | 装帧 | |
body_language | varchar(100) | NO | 正文语种 | |
foreign_language | varchar(100) | NO | 外语名 | |
goods_barcode | varchar(20) | YES | 商品条形码 | |
spec_name | varchar(255) | NO | NULL | 规格名称 |
goods_body | text | NO | NULL | 商品描述 |
mobile_body | text | NO | NULL | 手机端商品描述 |
presell_deliverdate | int(11) | NO | 0 | 预售商品发货时间 |
is_book | tinyint(4) | NO | 0 | 是否为预定商品,1是,0否 |
book_down_payment | decimal(10,2) | NO | 0.00 | 定金金额 |
book_final_payment | decimal(10,2) | NO | 0.00 | 尾款金额 |
book_down_time | int(11) | NO | 0 | 预定结束时间 |
book_buyers | mediumint(9) | YES | 0 | 预定人数 |
contract_1 | tinyint(1) | NO | 0 | 消费者保障服务状态 0关闭 1开启 |
contract_2 | tinyint(1) | NO | 0 | 消费者保障服务状态 0关闭 1开启 |
contract_3 | tinyint(1) | NO | 0 | 消费者保障服务状态 0关闭 1开启 |
contract_4 | tinyint(1) | NO | 0 | 消费者保障服务状态 0关闭 1开启 |
contract_5 | tinyint(1) | NO | 0 | 消费者保障服务状态 0关闭 1开启 |
contract_6 | tinyint(1) | NO | 0 | 消费者保障服务状态 0关闭 1开启 |
contract_7 | tinyint(1) | NO | 0 | 消费者保障服务状态 0关闭 1开启 |
contract_8 | tinyint(1) | NO | 0 | 消费者保障服务状态 0关闭 1开启 |
contract_9 | tinyint(1) | NO | 0 | 消费者保障服务状态 0关闭 1开启 |
contract_10 | tinyint(1) | NO | 0 | 消费者保障服务状态 0关闭 1开启 |
is_chain | tinyint(3) unsigned | NO | 0 | 是否为门店商品 1是,0否 |
goods_trans_v | decimal(10,2) unsigned | NO | 0.00 | 重量或体积 |
erp_id | varchar(100) | YES | NULL | erp货号 |
buy_limit | int(10) unsigned | YES | 0 | 商品限购数量 |
show_app | tinyint(3) unsigned | YES | 0 | 商品上架展示平台 1教育 2幼教 100全终端 |