dchain_aoxiang_product

店铺商品映射表

所属应用: dchain

表结构

ColumnName	Comment	Type	Not null	Default	Autoincrement
pid	ID	varchar(32)	Y		N
shop_id	来源店铺	varchar(32)	N		N
shop_bn	店铺编码	varchar(20)	N		N
product_id	商品ID	int(10) unsigned	N		N
product_bn	商品编码	varchar(50)	N		N
barcode	条形码	varchar(50)	N		N
product_name	店铺宝贝标题	varchar(200)	N		N
product_type	商品类型 normal:普通;combine:组合;	enum('normal','combine')	N	normal	N
shop_iid	店铺商品ID	varchar(50)	N		N
product_mapping	OMS商品映射 0:未映射;1:已映射;2:映射失败;	enum('0','1','2')	N	0	N
approve_status	商品在架状态 onsale:上架;instock:下架;	enum('onsale','instock')	N	onsale	N
create_time	创建时间	int(10) unsigned	N		N
last_modified	最后修改时间	int(10) unsigned	N		N
sync_status	同步状态 none:未同步;fail:同步失败;succ:同步成功;running:同步中;lack:组合无子货品;	enum('none','fail','succ','running','lack')	N	none	N
sync_msg	同步失败原因	text	N		N
fail_nums	失败次数	mediumint(8) unsigned	N	0	N
mapping_status	商货品关联状态 none:未关联;fail:关联失败;succ:关联成功;running:关联中;splitting:部分关联;invalid:无效的;	enum('none','fail','succ','running','splitting','invalid')	N	none	N
mapping_time	商货品关联时间	int(10) unsigned	N		N
delete_status	删除状态 none:默认;fail:删除失败;succ:删除成功;running:删除中;	enum('none','fail','succ','running')	N	none	N
sync_stock_time	回写库存时间	int(10) unsigned	N	0	N

索引

Key name	Column names	Unique	Comment
primary	pid	Y
uni_shop_product	shop_id, product_type, product_bn	Y
ind_shop_product_bn	shop_id, product_bn	N
ind_shop_sync	shop_id, sync_status	N
ind_shop_sync_type	shop_id, sync_status, product_type	N
ind_shop_mapping	shop_id, sync_status, mapping_status	N
ind_create_time	create_time	N
ind_last_modified	last_modified	N
ind_sync_stocks	shop_id, sync_stock_time	N
ind_shop_productid	shop_id, product_id	N
idx_c_shop_id	shop_id	N