omeanalysts_ome_goodsamount

商品表

所属应用: omeanalysts

表结构

ColumnName	Comment	Type	Not null	Default	Autoincrement
id	ID	int(10) unsigned	Y		Y
goods_bn	商品货号	varchar(200)	N		N
name	商品名称	varchar(200)	Y		N
brand_id	品牌	mediumint(8) unsigned	N		N
sales_num	销量	mediumint(8) unsigned	N	0	N
store	当天库存	mediumint(8) unsigned	N	0	N
purchase_num	采购入库数量	mediumint(8) unsigned	N	0	N
allocation_num	调拨入库数量	mediumint(8) unsigned	N	0	N
shop_id	所属店铺	varchar(32)	N		N
spec_info	规格	varchar(250)	N		N
createtime	所属时间	int(10) unsigned	N		N

索引

Key name	Column names	Unique	Comment
primary	id	Y
ind_goods_bn	goods_bn	N
idx_c_brand_id	brand_id	N
idx_c_shop_id	shop_id	N