tgkpi_pick

拣货绩效

所属应用: tgkpi

表结构

ColumnName	Comment	Type	Not null	Default	Autoincrement
pick_id	ID	mediumint(8) unsigned	Y		Y
product_id	商品ID	int(10) unsigned	Y		N
product_bn	货号	varchar(32)	N		N
product_pick_level	捡货难度	float(4,2)	N		N
pick_num	货品数量	int(8)	Y		N
pick_owner	工号	varchar(32)	Y		N
pick_start_time	拣货开始时间	int(10) unsigned	Y		N
check_start_time	校验开始时间	int(10) unsigned	N		N
check_op_id	check_op_id	mediumint(8) unsigned	N		N
check_op_name	校验员	varchar(30)	N		N
op_name	最终发货人	varchar(30)	N		N
pick_end_time	校验完成时间	int(10) unsigned	N		N
pick_error_num	拣错次数	mediumint(8)	Y		N
pick_status	状态 running:捡货中;checking:校验中;finish:校验完成;deliveryed:发货完成;error:校验错误;cancel:已取消;	enum('running','checking','finish','deliveryed','error','cancel')	Y		N
delivery_id	发货单编号	int(10) unsigned	Y		N
print_ident	发货单打印的批次号	varchar(64)	Y		N
print_ident_dly	批次号序列	varchar(64)	Y		N
delivery_sku_num	SKU数	mediumint(8)	Y		N
branch_id	仓库ID	mediumint(8) unsigned	N		N
pos_id	货位ID	mediumint(8) unsigned	N		N
branch_pos_position	货位位置	varchar(20)	N		N
cost_time	拣货耗时	mediumint(8) unsigned	N		N
check_cost_time	校验耗时	mediumint(8) unsigned	N		N

索引

Key name	Column names	Unique	Comment
primary	pick_id	Y
idx_pick_owner	pick_owner	N
idx_delivery_id	delivery_id	N
idx_op_name	op_name	N
idx_pick_start_time	pick_start_time	N
idx_c_product_id	product_id	N
idx_c_check_op_id	check_op_id	N
idx_c_delivery_id	delivery_id	N
idx_c_branch_id	branch_id	N
idx_c_pos_id	pos_id	N