ome_goods

商品表

所属应用: ome

表结构

ColumnName	Comment	Type	Not null	Default	Autoincrement
goods_id	ID	int(10) unsigned	Y		Y
bn	商品编号	varchar(200)	N		N
name	商品名称	varchar(200)	Y		N
cat_id	分类	mediumint(8) unsigned	Y	0	N
type_id	类型	mediumint(8) unsigned	N		N
goods_type	销售类型 normal:普通商品;bind:捆绑商品;	enum('normal','bind')	Y	normal	N
brand_id	品牌	mediumint(8) unsigned	N		N
brief	商品简介	varchar(255)	N		N
intro	详细介绍	longtext	N		N
barcode	条形码	varchar(32)	N		N
mktprice	市场价	decimal(20,3)	N		N
cost	成本价	decimal(20,3)	N	0	N
price	销售价	decimal(20,3)	N	0	N
serial_number	唯一码	enum('true','false')	Y	false	N
marketable	上架	enum('true','false')	Y	true	N
weight	重量	decimal(20,2)	N		N
unit	单位	varchar(20)	N		N
score_setting	score_setting percent:百分比;number:实际值;	enum('percent','number')	N	number	N
score	积分	mediumint(8) unsigned	N		N
spec_desc	物品	longtext	N		N
params	params	longtext	N		N
uptime	上架时间	int(10) unsigned	N		N
downtime	下架时间	int(10) unsigned	N		N
last_modify	更新时间	int(10) unsigned	N		N
disabled	是否失效	enum('true','false')	Y	false	N
p_order	排序	mediumint(8) unsigned	Y	30	N
d_order	排序	mediumint(8) unsigned	Y	30	N
p_1	p_1	mediumint(8) unsigned	N		N
p_2	p_2	mediumint(8) unsigned	N		N
p_3	p_3	mediumint(8) unsigned	N		N
p_4	p_4	mediumint(8) unsigned	N		N
p_5	p_5	mediumint(8) unsigned	N		N
p_6	p_6	mediumint(8) unsigned	N		N
p_7	p_7	mediumint(8) unsigned	N		N
p_8	p_8	mediumint(8) unsigned	N		N
p_9	p_9	mediumint(8) unsigned	N		N
p_10	p_10	mediumint(8) unsigned	N		N
p_11	p_11	mediumint(8) unsigned	N		N
p_12	p_12	mediumint(8) unsigned	N		N
p_13	p_13	mediumint(8) unsigned	N		N
p_14	p_14	mediumint(8) unsigned	N		N
p_15	p_15	mediumint(8) unsigned	N		N
p_16	p_16	mediumint(8) unsigned	N		N
p_17	p_17	mediumint(8) unsigned	N		N
p_18	p_18	mediumint(8) unsigned	N		N
p_19	p_19	mediumint(8) unsigned	N		N
p_20	p_20	mediumint(8) unsigned	N		N
p_21	p_21	varchar(255)	N		N
p_22	p_22	varchar(255)	N		N
p_23	p_23	varchar(255)	N		N
p_24	p_24	varchar(255)	N		N
p_25	p_25	varchar(255)	N		N
p_26	p_26	varchar(255)	N		N
p_27	p_27	varchar(255)	N		N
p_28	p_28	varchar(255)	N		N
taobao_num_iid	淘宝商品ID	bigint(20)	N		N
picurl	商品预览图片	varchar(255)	N		N
visibility	可视状态 false:隐藏;true:显示;	enum('false','true')	Y	true	N

索引

Key name	Column names	Unique	Comment
primary	goods_id	Y
uni_bn	bn	N
idx_c_cat_id	cat_id	N
idx_c_type_id	type_id	N
idx_c_brand_id	brand_id	N