dchain_aoxiang_branch

仓库映射表

所属应用: dchain

表结构

ColumnName	Comment	Type	Not null	Default	Autoincrement
bid	映射ID	int(10) unsigned	N		Y
shop_id	来源店铺	varchar(32)	N		N
shop_type	店铺类型	varchar(50)	N		N
branch_id	仓库	mediumint(8) unsigned	N		N
branch_bn	仓库编码	varchar(32)	N		N
create_time	创建时间	int(10) unsigned	N		N
last_modified	最后修改时间	int(10) unsigned	N		N
sync_status	同步状态 none:未同步;fail:同步失败;succ:同步成功;	enum('none','fail','succ')	N	none	N
sync_msg	同步失败原因	text	N		N
fail_nums	失败次数	mediumint(8) unsigned	N	0	N
seller_id	seller_id	varchar(32)	N		N

索引

Key name	Column names	Unique	Comment
primary	bid	Y
ind_shop_sync	shop_id, sync_status	N
ind_branch_bn	branch_bn	N
ind_create_time	create_time	N
ind_last_modified	last_modified	N
ind_shop_branch	shop_id, branch_id	N
idx_c_shop_id	shop_id	N
idx_c_branch_id	branch_id	N