DROP TABLE IF EXISTS `blade_ng_reason_info`; CREATE TABLE `blade_ng_reason_info` ( `id` bigint(20) NOT NULL COMMENT 'id', `tenant_id` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '000000' COMMENT '租户ID', `type_id` bigint(20) NULL DEFAULT NULL COMMENT '父类型id(暂没用,现使用的是公共组表做关联)', `reason_code` varchar(24) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '原因编号', `reason_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '原因名称', `create_user` bigint(20) NULL DEFAULT NULL COMMENT '创建人', `create_dept` bigint(20) NULL DEFAULT NULL COMMENT '创建单位', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `update_user` bigint(20) NULL DEFAULT NULL COMMENT '更新人', `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注', `is_deleted` int(11) NULL DEFAULT NULL, `status` int(11) NULL DEFAULT NULL COMMENT '业务状态', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uniqueCodeIndex` (`reason_code`, `is_deleted`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = 'NG原因维护信息表' ROW_FORMAT = Dynamic; DROP TABLE IF EXISTS `blade_trace_flow_record`; CREATE TABLE `blade_trace_flow_record` ( `id` bigint NOT NULL AUTO_INCREMENT, `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '备注', `create_user` bigint DEFAULT NULL, `create_dept` bigint DEFAULT NULL, `create_time` datetime DEFAULT NULL, `update_user` bigint DEFAULT NULL, `update_time` datetime DEFAULT NULL, `status` int DEFAULT NULL, `is_deleted` int DEFAULT NULL, `tenant_id` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '000000', `part_no` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '工件编号', `flow_code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '流程编号', `flow_display_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '流程名称', `flow_state` int DEFAULT NULL COMMENT '流程状态:1 完成 2 进行中', `flow_tag` int DEFAULT NULL COMMENT '流程标识:1 质检合格 2 质检不合格', `trace_flow_setting_id` bigint DEFAULT NULL COMMENT '流程设定ID', `workstation_id` bigint DEFAULT NULL COMMENT '工位id', `workstation_code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '工位编号', `workstation_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '工位名称', `workbench_id` bigint DEFAULT NULL COMMENT '工作台id', `workbench_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '工作台名称', `entry_time` datetime DEFAULT NULL COMMENT '进入时间', `left_time` datetime DEFAULT NULL COMMENT '离开时间', `extension_data` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '数据', `archive_table` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `position` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '位置', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 12 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC COMMENT ='工件流程记录'; DROP TABLE IF EXISTS `blade_trace_catalog`; CREATE TABLE `blade_trace_catalog` ( `id` bigint NOT NULL AUTO_INCREMENT, `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '备注', `create_user` bigint DEFAULT NULL, `create_dept` bigint DEFAULT NULL, `create_time` datetime DEFAULT NULL, `update_user` bigint DEFAULT NULL, `update_time` datetime DEFAULT NULL, `status` int DEFAULT NULL, `is_deleted` int DEFAULT NULL, `tenant_id` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '000000', `part_no` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '工件编号', `batch_number` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '批次号', `online_time` datetime DEFAULT NULL COMMENT '上线时间', `offline_time` datetime DEFAULT NULL COMMENT '下线时间', `qualified` tinyint DEFAULT NULL COMMENT '是否合格：0 否 1 是', `is_rework_part` tinyint DEFAULT NULL COMMENT '是否返工：0 否 1 是', `shift_index` int DEFAULT NULL COMMENT '班次下标', `shift_index_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '班次下标别名', `plan_id` int DEFAULT NULL COMMENT '计划id,无计划填0', `trace_status` int DEFAULT NULL COMMENT '工件转态：1 已下线 2 未下线 3 未知', `workstation_group_id` bigint DEFAULT NULL COMMENT '工位组id', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 34 DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC COMMENT ='工件上线记录'; DROP TABLE IF EXISTS `blade_trace_flow_settings`; CREATE TABLE `blade_trace_flow_settings` ( `id` bigint NOT NULL, `tenant_id` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '所属租户', `code` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '流程编号', `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '流程名称', `flow_seq` int DEFAULT NULL COMMENT '流程顺序', `station_type` int DEFAULT NULL COMMENT '工位类型 0-其他 1-打标 2-测量 3-清洗 4-装卸站 5-加工 6-搬运 7-三坐标', `workstation_group_id` bigint DEFAULT NULL COMMENT '工位组id', `pre_flow_id` bigint DEFAULT NULL COMMENT '上一流程id', `next_flow_id` bigint DEFAULT NULL COMMENT '下一流程id', `flow_type` int(10) unsigned zerofill DEFAULT NULL COMMENT '流程类别 1-上线流程 2-途径流程 3-下线流程 4-可选流程', `trigger_end_flow_style` int DEFAULT NULL COMMENT '结束流程方式 1-仅本流程 2-仅上个流程 3-本流程和上个流程', `quality_result_offline` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '按质量结果下线 1-OK下线 2-NG下线', `quality_maker_flow_id` bigint DEFAULT NULL COMMENT '质量责任归属到特定流程', `is_deleted` int DEFAULT NULL, `create_time` datetime DEFAULT NULL COMMENT '创建时间', `create_user` bigint DEFAULT NULL COMMENT '创建人', `update_time` datetime DEFAULT NULL COMMENT '更新时间', `update_user` bigint DEFAULT NULL COMMENT '更新人', `create_dept` bigint DEFAULT NULL COMMENT '创建部门', `status` int DEFAULT NULL COMMENT '业务状态', `extension_data` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '数据', PRIMARY KEY (`id`) USING BTREE, UNIQUE KEY `uniqueCodeIndex` (`code`, `is_deleted`) USING BTREE ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC COMMENT ='流程维护'; -- 追溯关联工位 DROP TABLE IF EXISTS `blade_trace_related_workstation`; CREATE TABLE `blade_trace_related_workstation` ( `id` bigint NOT NULL, `workstation_id` bigint NOT NULL COMMENT '工位id', `workbench_id` bigint NOT NULL COMMENT '工作台id', `trace_flow_setting_id` bigint NOT NULL COMMENT '流程设定ID', `machining_position` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '加工位置', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '追溯关联工位' ROW_FORMAT = DYNAMIC; -- 工件追溯NG表 DROP TABLE if EXISTS `blade_trace_record_ng_reason`; CREATE TABLE `blade_trace_record_ng_reason` ( `id` bigint NOT NULL, `record_id` bigint DEFAULT NULL COMMENT '工件流程记录id', `bad_part_id` bigint DEFAULT NULL COMMENT '不良部位id', `bad_part` varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '不良部位', `reason_id` bigint DEFAULT NULL COMMENT '原因id', `reason_code` varchar(24) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '原因编号', `reason_name` varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '原因名称', `create_user_name` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '创建用户名称', `tenant_id` varchar(12) COLLATE utf8mb4_general_ci DEFAULT '000000' COMMENT '租户ID', `status` tinyint DEFAULT '1' COMMENT '业务状态 1激活 0 冻结', `is_deleted` bigint unsigned DEFAULT NULL COMMENT '删除标记：0-未删除，1-已删除', `create_user` bigint DEFAULT NULL COMMENT '创建人', `create_dept` bigint DEFAULT NULL COMMENT '创建部门', `create_time` datetime DEFAULT NULL COMMENT '创建时间', `update_user` bigint DEFAULT NULL COMMENT '更新人', `update_time` datetime DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`) ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT ='工件流程NG原因表'; INSERT INTO `blade_menu`(`id`, `parent_id`, `code`, `name`, `alias`, `path`, `source`, `sort`, `category`, `action`, `is_open`, `remark`, `is_deleted`, `belong_application`, `keep_alive`) VALUES (1518863601934606338, 0, 'trace', '工件追溯', 'trace', '/trace', 'iconfont saber-zhushuju', 8, 0, 0, 1, '', 0, 'CPS', 1), (1518864188126339074, 1518863601934606338, 'trace_query', '追溯查询', 'trace_query', '/trace/query/index', 'iconfont iconicon_search', 1, 1, 0, 1, '', 0, 'CPS', 1), (1519183072176939010, 1518863601934606338, 'processMaintenance', '流程维护', 'processMaintenance', '/trace/maintain/index', 'iconfont saber-caijifenxi', 3, 1, 0, 1, '', 0, 'CPS', 1), (1522377449602215938, 1518863601934606338, 'ng', 'NG原因维护', 'ng', '/trace/ng-info/index', 'iconfont iconicon_setting', 4, 1, 0, 1, '', 0, 'CPS', 1), (1523465621521539073, 1518863601934606338, 'ng_trace', 'NG工件追溯', 'ng_trace', '/trace/ng-trace/index', 'iconfont iconicon_ding', 99, 1, 0, 1, '', 0, 'CPS', 1); CREATE UNIQUE INDEX default_index ON `blade_trace_catalog` (`part_no`, `batch_number`, `workstation_group_id`, `online_time`, `offline_time`) USING BTREE; CREATE INDEX time_index ON `blade_trace_catalog` (`online_time`, `offline_time`, `part_no`, `batch_number`) USING BTREE; CREATE INDEX default_index ON `blade_trace_flow_record` (`part_no`, `workstation_id`, `entry_time`) USING BTREE; CREATE INDEX flag_index ON `blade_trace_flow_record` (`flow_tag`, `part_no`, `workstation_id`) USING BTREE; CREATE INDEX default_index ON `blade_trace_record_ng_reason` (`record_id`) USING BTREE;