-- 更改 production_order_pick
|
|
ALTER TABLE `production_order_pick`
|
MODIFY COLUMN `quantity` decimal (20, 8) NULL DEFAULT NULL COMMENT '数量' AFTER `product_model_id`,
|
MODIFY COLUMN `demanded_quantity` decimal (20, 8) NULL DEFAULT NULL COMMENT '需求数量' AFTER `technology_operation_id`,
|
MODIFY COLUMN `feeding_qty` decimal (20, 8) NULL DEFAULT NULL COMMENT '补料总量' AFTER `is_returned`,
|
MODIFY COLUMN `return_qty` decimal (20, 8) NULL DEFAULT NULL COMMENT '退料数量' AFTER `feeding_qty`,
|
MODIFY COLUMN `actual_qty` decimal (20, 8) NULL DEFAULT NULL COMMENT '实际数量' AFTER `return_qty`;
|
|
-- 更改 production_order_pick_record
|
|
ALTER TABLE `production_order_pick_record`
|
MODIFY COLUMN `pick_quantity` decimal (20, 8) NULL DEFAULT NULL COMMENT '领料数量' AFTER `batch_no`,
|
MODIFY COLUMN `before_quantity` decimal (20, 8) NULL DEFAULT NULL COMMENT '领料前数量' AFTER `pick_quantity`,
|
MODIFY COLUMN `after_quantity` decimal (20, 8) NULL DEFAULT NULL COMMENT '领料后剩余数量' AFTER `before_quantity`;
|
