dchain_aoxiang_skus

店铺SKU映射表

所属应用: dchain

表结构

ColumnName	Comment	Type	Not null	Default	Autoincrement
sid	SKUID	varchar(32)	Y		N
pid	映射ID	varchar(32)	N		N
shop_id	来源店铺	varchar(32)	N		N
product_id	商品ID	int(10) unsigned	N		N
product_bn	商品编码	varchar(50)	N		N
product_name	店铺宝贝标题	varchar(200)	N		N
shop_iid	店铺商品ID	varchar(50)	N		N
shop_sku_id	店铺货品ID	varchar(50)	N		N
mapping	关联状态 0:未映射;1:已映射;	enum('0','1')	N	0	N
bind	是否捆绑 0:普通类型;1:组合类型;	enum('0','1')	N	0	N
create_time	创建时间	int(10) unsigned	N		N
last_modified	最后修改时间	int(10) unsigned	N		N
mapping_status	商货品关联状态 none:未关联;fail:关联失败;succ:关联成功;running:关联中;invalid:无效的;	enum('none','fail','succ','running','invalid')	N	none	N
mapping_time	商货品关联时间	int(10) unsigned	N		N
sync_msg	同步失败原因	text	N		N
fail_nums	失败次数	mediumint(8) unsigned	N	0	N
delete_status	删除状态 none:默认;fail:删除失败;succ:删除成功;running:删除中;	enum('none','fail','succ','running')	N	none	N

索引

Key name	Column names	Unique	Comment
primary	sid	Y
uni_shop_sku	shop_id, product_bn, shop_iid, shop_sku_id	Y
ind_mapping_status	shop_id, mapping_status	N
ind_shop_sku	shop_id, product_bn	N
ind_shop_iid	shop_id, shop_iid	N
ind_create_time	create_time	N
ind_last_modified	last_modified	N
ind_shop_productid	shop_id, product_id	N
idx_c_pid	pid	N
idx_c_shop_id	shop_id	N