wms_pda_pick

---

所属应用: wms

表结构

ColumnName	Comment	Type	Not null	Default	Autoincrement
id	id	int(10) unsigned	Y		Y
delivery_id	delivery_id	int(10) unsigned	Y		N
delivery_bn	发货单号	varchar(32)	N		N
box	篮子号	varchar(50)	N		N
status	拣货认领状态 0:未拣货;1:拣货中;2:已拣货;	enum('0','1','2')	N	0	N
create_time	单据生成时间	int(10) unsigned	N		N
op_id	op_id	varchar(50)	N		N

索引

Key name	Column names	Unique	Comment
primary	id	Y
ind_delivery_bn	delivery_bn	Y
idx_c_delivery_id	delivery_id	N