log_pack_info_setting 源表结构 CREATE TABLE `log_pack_info_setting` ( `log_pack_info_setting_id` bigint NOT NULL AUTO_INCREMENT COMMENT '生产包装信息日志主键', `pack_info_setting_id` bigint NOT NULL COMMENT '生产包装信息的ID(pack_info_setting)', `operator_id` bigint NOT NULL COMMENT '操作人(sys_user)', `log_content` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '日志内容(JSON格式)', `operation_type` tinyint NOT NULL DEFAULT '0' COMMENT '操作类型(0新增,1修改,2删除,3启用,4禁用,5导入,6导出)', `operation_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '操作时间', PRIMARY KEY (`log_pack_info_setting_id`) USING BTREE, KEY `nk_associated_id` (`pack_info_setting_id`) USING BTREE COMMENT '关联ID的普通索引' ) ENGINE=InnoDB AUTO_INCREMENT=28167 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='记录生产包装信息改动 - 2021年9月27日 16:26:24' 目标表结构 CREATE TABLE `production_order_support_detail` ( `id` bigint NOT NULL AUTO_INCREMENT, `order_num` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '订单号', `production_order_num` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '工单号', `workshop_id` bigint NOT NULL COMMENT '车间id', `table_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '库.表名', `create_time` datetime NOT NULL, `update_time` datetime DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `uniq` (`production_order_num`,`table_name`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=1103449 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci -------------------------------------------------------------------------------------------------------------------------------------------------------------- work_position 源表结构 CREATE TABLE `work_position` ( `work_position_id` bigint NOT NULL AUTO_INCREMENT COMMENT '工位id', `work_position_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '工位名称', `work_step_type_code` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '工步类型', `work_position_code` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '工位code', `work_step_id` bigint DEFAULT NULL COMMENT '工步id', `production_line_id` bigint DEFAULT NULL COMMENT '产线id', `production_line_code` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '产线code', `create_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `create_time` datetime NOT NULL, `update_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `update_time` datetime DEFAULT NULL, `del_flag` tinyint DEFAULT '0' COMMENT '删除状态 0否1删除', `able` tinyint NOT NULL DEFAULT '1' COMMENT '状态0 禁用 1启用', `workshop_id` bigint DEFAULT NULL COMMENT '车间id', `is_mul_line` tinyint DEFAULT NULL COMMENT '是否多产线', `desk_count` int DEFAULT '1' COMMENT '机台数', `is_multiple` tinyint(1) DEFAULT '0' COMMENT '支持多组件(0否 1是)', PRIMARY KEY (`work_position_id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=433 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='工位' 目标表结构 CREATE TABLE `work_position` ( `work_position_id` bigint NOT NULL AUTO_INCREMENT COMMENT '工位id', `work_position_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '工位名称', `work_step_type_code` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '工步类型', `work_position_code` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '工位code', `work_step_id` bigint DEFAULT NULL COMMENT '工步id', `production_line_id` bigint DEFAULT NULL COMMENT '产线id', `production_line_code` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '产线code', `create_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `create_time` datetime NOT NULL, `update_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `update_time` datetime DEFAULT NULL, `del_flag` tinyint DEFAULT '0' COMMENT '删除状态 0否1删除', `able` tinyint NOT NULL DEFAULT '1' COMMENT '状态0 禁用 1启用', `workshop_id` bigint DEFAULT NULL COMMENT '车间id', `is_mul_line` tinyint DEFAULT NULL COMMENT '是否多产线', `desk_count` int DEFAULT '1' COMMENT '机台数', `is_multiple` tinyint DEFAULT '0' COMMENT '支持多组件(0否 1是)', PRIMARY KEY (`work_position_id`) ) ENGINE=InnoDB AUTO_INCREMENT=433 DEFAULT CHARSET=utf8mb3 COMMENT='工位' ---------------------------------------------------------------------------------------------------------------------------- order_material 源表结构 CREATE TABLE `order_material` ( `order_material_id` bigint unsigned NOT NULL AUTO_INCREMENT, `material_id` bigint DEFAULT NULL COMMENT '物料id(产品表产品id)', `material_count` int NOT NULL COMMENT '需求数量', `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '备注', `order_id` bigint NOT NULL COMMENT '销售订单id', `delivery_date` date DEFAULT NULL COMMENT '交货日期', `del_flag` tinyint(1) unsigned zerofill NOT NULL DEFAULT '0' COMMENT '0 正常 1 删除', `product_id` bigint DEFAULT NULL COMMENT '产品表id', `production_count` int unsigned DEFAULT '0' COMMENT '已投产数量', `finish_count` int unsigned DEFAULT '0' COMMENT '已完成数量', `finish_date` date DEFAULT NULL, `hedge_count` int unsigned DEFAULT '0' COMMENT '对冲数量', `plan_material_count` int DEFAULT '0' COMMENT '计划订单数量', `order_num` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '订单号(数据同步用)', `material_code` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '物料号(产品号,数据同步用)', `order_row` varchar(255) DEFAULT NULL COMMENT '订单行号', `in_storage_check_status` int DEFAULT '0' COMMENT '入库卡控状态,0:不启用,1:启用', PRIMARY KEY (`order_material_id`) USING BTREE, KEY `order_and_material_id` (`material_id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=4819 DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='订单成品表(成品也看成是一种物料)' 目标表结构 CREATE TABLE `order_material` ( `order_material_id` bigint unsigned NOT NULL AUTO_INCREMENT, `material_id` bigint DEFAULT NULL COMMENT '物料id(产品表产品id)', `material_count` int NOT NULL COMMENT '需求数量', `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '备注', `order_id` bigint NOT NULL COMMENT '销售订单id', `delivery_date` date DEFAULT NULL COMMENT '交货日期', `del_flag` tinyint(3) unsigned zerofill NOT NULL DEFAULT '000' COMMENT '0 正常 1 删除', `product_id` bigint DEFAULT NULL COMMENT '产品表id', `production_count` int unsigned DEFAULT '0' COMMENT '已投产数量', `finish_count` int unsigned DEFAULT '0' COMMENT '已完成数量', `finish_date` date DEFAULT NULL, `hedge_count` int unsigned DEFAULT '0' COMMENT '对冲数量', `plan_material_count` int DEFAULT '0' COMMENT '计划订单数量', `order_num` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '订单号(数据同步用)', `material_code` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '物料号(产品号,数据同步用)', `order_row` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '订单行号', `in_storage_check_status` int DEFAULT '0' COMMENT '入库卡控状态,0:不启用,1:启用', PRIMARY KEY (`order_material_id`), KEY `order_and_material_id` (`material_id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=4819 DEFAULT CHARSET=utf8mb3 COMMENT='订单成品表(成品也看成是一种物料)'