o2o_product_store

门店货品库存表

所属应用: o2o

表结构

ColumnName	Comment	Type	Not null	Default	Autoincrement
id	id	mediumint(8) unsigned	Y		Y
branch_id	branch_id	mediumint(8) unsigned	Y		N
bm_id	bm_id	int(10) unsigned	Y		N
store	线上在售库存	mediumint(8) unsigned	N	0	N
store_freeze	线上在售冻结	mediumint(8) unsigned	N	0	N
share_store	共享库存	mediumint(8) unsigned	N	0	N
share_freeze	共享库存冻结	mediumint(8) unsigned	N	0	N
arrive_store	在途库存	mediumint(8) unsigned	N	0	N
last_modified	最后更新时间	int(10) unsigned	N		N
store_bn	门店编码	varchar(20)	N		N
store_mode	门店类型 normal:正价店铺;discount:奥莱店铺;	enum('normal','discount')	N	normal	N
min_store	MIN最小库存	mediumint(8) unsigned	N	0	N
max_store	MAX最大库存	mediumint(8) unsigned	N	0	N

索引

Key name	Column names	Unique	Comment
primary	id	Y
ind_branch_id_bm_id	branch_id, bm_id	Y
ind_store_bn	store_bn	N
ind_store_bm_id	store_bn, bm_id	N
idx_c_branch_id	branch_id	N
idx_c_bm_id	bm_id	N