dchain_aoxiang_delivery

发货单表

所属应用: dchain

表结构

ColumnName	Comment	Type	Not null	Default	Autoincrement
did	映射ID	int(10) unsigned	N		Y
shop_id	来源店铺	varchar(32)	N		N
shop_type	店铺类型	varchar(50)	N		N
delivery_id	发货单	int(10) unsigned	N		N
delivery_bn	发货单号	varchar(32)	N		N
create_time	创建时间	int(10) unsigned	N		N
last_modified	最后修改时间	int(10) unsigned	N		N
sync_status	同步状态 none:未同步;fail:同步失败;succ:同步成功;cancel_fail:取消失败;cancel_succ:取消成功;	enum('none','fail','succ','cancel_fail','cancel_succ')	N	none	N
sync_msg	同步失败原因	text	N		N
fail_nums	失败次数	mediumint(8) unsigned	N	0	N

索引

Key name	Column names	Unique	Comment
primary	did	Y
ind_shop_sync	shop_id, sync_status	N
ind_shop_delivery	shop_id, delivery_id	N
ind_delivery_bn	delivery_bn	N
ind_create_time	create_time	N
idx_c_shop_id	shop_id	N