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 |
