omeanalysts_products_sale

产品销售排行榜

所属应用: omeanalysts

表结构

ColumnName	Comment	Type	Not null	Default	Autoincrement
id	ID	int(10) unsigned	Y		Y
shop_id	来源店铺	varchar(32)	N		N
bn	货号	varchar(60)	N	0	N
name	货品名称(规格)	varchar(200)	N	0	N
sales_num	销售量	mediumint(8) unsigned	N	0	N
sales_amount	销售额	decimal(20,3)	N	0	N
brand_id	品牌	mediumint(8) unsigned	N		N
sales_time	销售时间	int(10) unsigned	N		N

索引

Key name	Column names	Unique	Comment
primary	id	Y
ind_bnsalestime	bn, sales_time	N
idx_c_shop_id	shop_id	N
idx_c_brand_id	brand_id	N