From 7bc1d0f521c1d59246f29bcadcc4343f88ceef1c Mon Sep 17 00:00:00 2001
From: yangys <y_ys79@sina.com>
Date: 星期一, 15 九月 2025 11:29:30 +0800
Subject: [PATCH] 性能优化+bug调整

---
 doc/sql/mdm/mdm.mysql.all.create.sql |  432 ++++++++++++++++++++++++++++++++++++++++++++---------
 1 files changed, 357 insertions(+), 75 deletions(-)

diff --git a/doc/sql/mdm/mdm.mysql.all.create.sql b/doc/sql/mdm/mdm.mysql.all.create.sql
index 41f0ffb..061cd61 100644
--- a/doc/sql/mdm/mdm.mysql.all.create.sql
+++ b/doc/sql/mdm/mdm.mysql.all.create.sql
@@ -1,3 +1,5 @@
+
+DROP TABLE IF EXISTS `mdm_machine_group`;
 CREATE TABLE `mdm_machine_group` (
   `id` bigint NOT NULL COMMENT '涓婚敭',
   `tenant_id` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '000000' COMMENT '绉熸埛ID',
@@ -13,7 +15,7 @@
   PRIMARY KEY (`id`) USING BTREE
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE = utf8mb4_general_ci COMMENT='鏈哄簥缁�';
 
-
+DROP TABLE IF EXISTS `mdm_machine`;
 CREATE TABLE `mdm_machine` (
   `id` bigint NOT NULL,
   `tenant_id` varchar(6) DEFAULT NULL COMMENT '鎵�灞炵鎴�',
@@ -21,14 +23,17 @@
   `name` varchar(100) NOT NULL COMMENT '鏈哄簥鎻忚堪/鍨嬪彿',
   `avatar` varchar(400) DEFAULT NULL COMMENT '鍥剧墖鍦板潃',
   `machine_group_code` varchar(255) NOT NULL COMMENT '鎵�灞炴満搴婄粍浠ｇ爜锛�,鍦ㄤ笟鍔″瓧鍏搁厤缃紙key=machine_group锛�',
-  `machine_spec` varchar(20) DEFAULT NULL COMMENT '鏈哄櫒瑙勬牸:01杞﹀簥/02閾ｅ簥,鍦ㄤ笟鍔″瓧鍏搁厤缃紙key=machine_spec锛�',
+  `machine_spec` varchar(40) DEFAULT NULL COMMENT '鏈哄櫒瑙勬牸:01杞﹀簥/02閾ｅ簥,鍦ㄤ笟鍔″瓧鍏搁厤缃紙key=machine_spec锛�',
   `operator` varchar(100)  COMMENT '鎿嶄綔鍛橈紝鏂囨湰褰曞叆',
   `owner_dept` bigint DEFAULT NULL COMMENT '鎵�灞炲崟浣�/缁勭粐',
   `manufacturer` varchar(100)  COMMENT '鐢熶骇鍟�',
   `polling_hours` int(11) COMMENT '妫�鏌ョ▼搴忓洖浼犵殑杞鏃堕棿锛堝皬鏃讹級',
   `control_system` varchar(20) DEFAULT NULL COMMENT '鎺у埗绯荤粺锛堝鍙戦偅绉戯級锛屽湪涓氬姟瀛楀吀閰嶇疆(key=machine_controll_system)锛屼娇鐢ㄨ嫳鏂囧瓧姣�',
-  `prog_send_dir` varchar(100)  COMMENT '绋嬪簭涓嬪彂鐩綍',
-  `prog_receive_dir` varchar(100)  COMMENT '绋嬪簭鍥炰紶鐩綍',
+  `prog_send_dir` varchar(400)  COMMENT '绋嬪簭涓嬪彂鐩綍',
+  `send_dir_expiry_hours` int NOT NULL DEFAULT 8 COMMENT 'send鏂囦欢澶规枃浠舵湁鏁堟湡锛堝皬鏃�)',
+  `prog_receive_dir` varchar(400)  COMMENT '绋嬪簭鍥炰紶鐩綍',
+  `receive_dir_expiry_hours` varchar(255) NOT NULL DEFAULT 8 COMMENT 'receive鏂囦欢澶规枃浠舵湁鏁堟湡锛堝皬鏃讹級',
+  `prog_temp_dir` varchar(400)  COMMENT '绋嬪簭闀挎湡瀛樺偍鐩綍',
   `remark` varchar(200)  COMMENT '澶囨敞',
   `status` int DEFAULT NULL COMMENT '涓氬姟鐘舵�侊紝1锛氬惎鐢紱0绂佺敤',
   `create_dept` bigint DEFAULT NULL COMMENT '鍒涘缓鍗曚綅',
@@ -41,14 +46,67 @@
   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 `mdm_dbbak_config`;
+CREATE TABLE `mdm_dbbak_config` (
+    `id` bigint NOT NULL,
+    `name` varchar(100) NULL COMMENT '鍥惧彿锛岄浂缁勪欢鍙�',
+    `ip_addr` varchar(20) NOT NULL COMMENT '涓撲笟缁勯暱璐﹀彿',
+    `account` varchar(80) NOT NULL COMMENT '鏁版嵁搴撹处鍙�',
+    `passwd` varchar(80) NOT NULL COMMENT '鏁版嵁搴撳瘑鐮�',
+    `db_name` varchar(80) NOT NULL COMMENT '鏁版嵁搴撳悕绉�',
+    `db_port` int NOT NULL COMMENT '鏁版嵁搴撶鍙�',
+    `status` int DEFAULT NULL COMMENT '涓氬姟鐘舵��',
+    `is_deleted` int DEFAULT 0,
+    PRIMARY KEY (`id`) USING BTREE
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE = utf8mb4_general_ci  ROW_FORMAT=DYNAMIC COMMENT='鏁版嵁搴撳浠介厤缃�';
+
+
+DROP TABLE IF EXISTS `mdm_qinzhe_fgb`;
+CREATE TABLE `mdm_qinzhe_fgb` (
+   `cph` varchar(80) NULL COMMENT '浜у搧鍙�',
+   `ljh` varchar(80) NULL COMMENT '闆朵欢鍙�',
+   `ljmc` varchar(100) NULL COMMENT '闆朵欢鍚嶇О',
+   `zz` varchar(40) NULL COMMENT '涓诲埗',
+   `zzgd` varchar(40) NULL COMMENT '涓诲埗宸ユ',
+   `zggy` varchar(40) NULL COMMENT '涓荤宸ヨ壓',
+   `fg` varchar(40) NULL COMMENT '鍓',
+   `cjjhy` varchar(40) NULL COMMENT '杞﹂棿璁″垝鍛�',
+   `jhy` varchar(40) NULL COMMENT '璁″垝鍛�',
+   `source` varchar(5) NULL COMMENT '鏁版嵁鏉ユ簮',
+    update_time datetime null  COMMENT '鏇存柊鏃堕棿'
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE = utf8mb4_general_ci  ROW_FORMAT=DYNAMIC COMMENT='鍕ゅ摬鍒嗗伐琛ㄦ湰鍦颁复鏃惰〃';
+
+DROP TABLE IF EXISTS `v_寮犵珛铏巁2鍘備富鍒跺垎宸ヨ〃`;
+CREATE TABLE `v_寮犵珛铏巁2鍘備富鍒跺垎宸ヨ〃` (
+  `浜у搧鍙穈 varchar(40) NULL COMMENT '浜у搧鍙�',
+  `闆朵欢鍙穈 varchar(80) NULL COMMENT '闆朵欢鍙�',
+  `闆朵欢鍚嶇О` varchar(100) NULL COMMENT '闆朵欢鍚嶇О',
+  `涓诲埗` varchar(40) NULL COMMENT '涓诲埗',
+  `闆朵欢绛夌骇` varchar(40) NULL COMMENT '闆朵欢绛夌骇',
+  `鏈哄瀷` varchar(40) NULL COMMENT '鏈哄瀷',
+  `鍨嬪埆` varchar(40) NULL COMMENT '鍨嬪埆',
+  `渚濇嵁` varchar(40) NULL COMMENT '渚濇嵁',
+  `涓诲埗宸ユ` varchar(40) NULL COMMENT '涓诲埗宸ユ',
+  `涓荤宸ヨ壓` varchar(40) NULL COMMENT '涓荤宸ヨ壓',
+  `鍓` varchar(40) NULL COMMENT '鍓',
+  `鏄惁鍏抽敭浠禶 varchar(40) NULL COMMENT '鏄惁鍏抽敭浠�',
+  `澶囨敞` varchar(40) NULL COMMENT '澶囨敞',
+  `闆朵欢缂栧彿` varchar(40) NULL COMMENT '闆朵欢缂栧彿',
+  `杞﹂棿璁″垝鍛榒 varchar(40) NULL COMMENT '杞﹂棿璁″垝鍛�',
+  `璁″垝鍛榒 varchar(40) NULL COMMENT '璁″垝鍛�'
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE = utf8mb4_general_ci  ROW_FORMAT=DYNAMIC COMMENT='鍕ゅ摬鍒嗗伐琛ㄨ鍥炬ā鎷�';
+
+
+
+DROP TABLE IF EXISTS `mdm_produce_division`;
 CREATE TABLE `mdm_produce_division` (
     `id` bigint NOT NULL,
-    `team_leader_id` bigint NOT NULL COMMENT '涓撲笟缁勯暱璐﹀彿',
-    `programmer_id` bigint NOT NULL COMMENT '缂栧埗鍛樿处鍙�',
-    `checker_id` bigint NOT NULL COMMENT '鏍″鍛樿处鍙凤紙宸ヨ壓鍛樿鑹诧級',
-    `senior_id` bigint NOT NULL COMMENT '瀹℃壒楂樺笀璐﹀彿',
-
-	`tenant_id` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '000000' COMMENT '绉熸埛ID',
+    `team_leader_id` bigint  COMMENT '涓撲笟缁勯暱璐﹀彿',
+    `programmer_id` bigint  COMMENT '缂栧埗鍛樿处鍙�',
+    `checker_id` bigint COMMENT '鏍″鍛樿处鍙凤紙宸ヨ壓鍛樿鑹诧級',
+    `senior_id` bigint  COMMENT '瀹℃壒楂樺笀璐﹀彿',
+    `tenant_id` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '000000' COMMENT '绉熸埛ID',
     `status` int DEFAULT NULL COMMENT '涓氬姟鐘舵��',
     `create_dept` bigint DEFAULT NULL COMMENT '鍒涘缓鍗曚綅',
     `is_deleted` int DEFAULT 0,
@@ -56,77 +114,129 @@
     `create_user` bigint DEFAULT NULL COMMENT '鍒涘缓浜�',
     `update_time` datetime DEFAULT NULL COMMENT '鏇存柊鏃堕棿',
     `update_user` bigint DEFAULT NULL COMMENT '鏇存柊浜�',
-    PRIMARY KEY (`id`) USING BTREE,
-    UNIQUE KEY `uniqueCheckIndex` (`team_leader_id`,`programmer_id`,`checker_id`,`senior_id`,`is_deleted`) USING BTREE
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE = utf8mb4_general_ci  ROW_FORMAT=DYNAMIC COMMENT='涓诲埗璁″垝琛�';
+    PRIMARY KEY (`id`) USING BTREE
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE = utf8mb4_general_ci  ROW_FORMAT=DYNAMIC COMMENT='涓诲埗鍒嗗伐琛�';
 
 
+DROP TABLE IF EXISTS `mdm_nc_node`;
 CREATE TABLE `mdm_nc_node` (
-          `id` bigint NOT NULL,
-          `tenant_id` varchar(6) DEFAULT NULL COMMENT '鎵�灞炵鎴�',
-          `name` varchar(100) NOT NULL COMMENT '鑺傜偣鍚嶇О',
-          `parent_id` bigint DEFAULT NULL COMMENT '鎵�灞炴満搴婄粍ID',
-          `node_type` varchar(20) DEFAULT NULL COMMENT '鑺傜偣绫诲瀷锛歅RODUCT_MODEL(浜у搧鍨嬪彿)/PARTS_NO(闆剁粍浠跺彿)/CRAFT_EDITION(宸ヨ壓鐗堟)/PROCESS_NO(宸ュ簭鍙�)/MACHINE(鏈哄簥)/PACKAGE(绋嬪簭鍖呭悕)/PROGRAME(绋嬪簭鏂囦欢)',
-          `status` int DEFAULT NULL COMMENT '涓氬姟鐘舵��',
-          `create_dept` 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 '鏇存柊浜�'
-  PRIMARY KEY (`id`) USING BTREE,
-                                  UNIQUE KEY `uniqueCodeIndex` (`code`,`is_deleted`) USING BTREE,
+   `id` bigint NOT NULL,
+   `tenant_id` varchar(6) DEFAULT NULL COMMENT '鎵�灞炵鎴�',
+   `name` varchar(100) NOT NULL COMMENT '鑺傜偣鍚嶇О',
+   `process_name` varchar(20) NULL COMMENT '宸ュ簭鍚嶇О',
+   `process_no` varchar(100) NULL COMMENT '宸ュ簭鍙�',
+   `machine_code` varchar(100) DEFAULT NULL COMMENT '璁惧缂栧彿/鏈哄簥缂栧彿',
+   `machine_group_code` varchar(255) DEFAULT NULL COMMENT '鏈哄簥缁勫瓧鍏哥爜',
+   `drawing_no` varchar(100) NULL COMMENT '闆剁粍浠剁紪鍙�/鍥惧彿',
+   `is_cured` int DEFAULT NULL COMMENT '鏄惁鍥哄寲,1鏄�;0鍚�',
+   `is_locked` int DEFAULT NULL COMMENT '閿佸畾鐘舵�侊紝1锛氶攣瀹氾紱0:姝ｅ父',
+   `is_last_edition` int NULL COMMENT '鏄惁鏈�鏂扮増娆★紝1锛氭渶鏂扮増娆★紱0:鍘嗗彶鐗堟锛屼富瑕佸彇璇ュ瓧娈�=1鐨勬暟鎹紝0鏄巻鍙茬増娆�',
+   `expire_date` date DEFAULT NULL COMMENT '鍒版湡鏃堕棿,鏍规嵁鏈夋晥鏈熸椂闀胯绠楄�屾潵',
+   `process_edition` varchar(40) DEFAULT NULL COMMENT '宸ュ簭鐗堟锛屽崌鐗堝氨鏄彉鏇存敼璇ュ瓧娈碉紝闇�瑕佷繚鐣欏巻鍙茶褰�',
+   `craft_edition` varchar(40) DEFAULT NULL COMMENT '宸ヨ壓鐗堟',
+   `drawing_no_edition` varchar(100) NULL COMMENT '鍥惧彿鐗堟',
+   `description` varchar(100) NULL COMMENT '鎻忚堪',
+   `remark` varchar(200) NULL COMMENT '閿佸畾鍘熷洜',
+   `parent_id` bigint DEFAULT NULL COMMENT '涓婄骇鑺傜偣ID',
+   `parent_ids` varchar(200) DEFAULT NULL COMMENT '涓婄骇鑺傜偣ID闆嗗悎锛宨d閫楀彿鍒嗛殧',
+   `node_type` varchar(20) DEFAULT NULL COMMENT '鑺傜偣绫诲瀷锛氫笟鍔″瓧鍏稿畾涔�',
+   `product_model` varchar(100) NULL COMMENT '浜у搧鍨嬪彿',
+   `program_no` varchar(20) NULL COMMENT '绋嬪簭缂栧彿,鍙湁绋嬪簭鍖呭悕鑺傜偣鎵嶆湁鍊�',
+   `his_serial` bigint NULL COMMENT '鍘嗗彶搴忓垪鍙凤紝搴忓垪鍙风浉鍚屽睘浜庡悓涓�鍘嗗彶鍒楄〃',
+   `flow_program_file_id` bigint NULL COMMENT '鍏宠仈鐨勬祦绋嬬▼搴忔枃浠秈d锛岀▼搴忔枃浠剁被鍨嬬殑鑺傜偣鎵嶆湁鍊�',
+   `process_instance_id` varchar(64) NULL COMMENT '鍏宠仈鐨勬祦绋嬪疄渚媔d锛岀▼搴忓寘 绫诲瀷鐨勮妭鐐规墠鏈夊��',
+   `deviation` varchar(100) NULL COMMENT '鍋忕鍗曞彿',
+   `version_number` int DEFAULT NULL COMMENT '鐗堟湰鍙�',
+   `status` int DEFAULT NULL COMMENT '涓氬姟鐘舵��',
+   `create_dept` 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 '鏇存柊浜�',
+   PRIMARY KEY (`id`) USING BTREE
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='绋嬪簭鑺傜偣鐩綍';
 
-DROP TABLE IF EXISTS `mdm_nc_program`;
-CREATE TABLE `mdm_nc_program` (
-  `id` bigint NOT NULL,
-  `tenant_id` varchar(6) DEFAULT NULL COMMENT '鎵�灞炵鎴�',
-  `nc_node_id` bigint DEFAULT NULL COMMENT '鎵�灞炶妭鐐筰d',
-  `code` varchar(100) NOT NULL COMMENT '绋嬪簭缂栧彿',
-  `name` varchar(100) NOT NULL COMMENT '绋嬪簭鍚嶇О',
-  `package_name` varchar(100) NOT NULL COMMENT '绋嬪簭鍖呭悕',
-  `url` varchar(400) NOT NULL COMMENT '鏂囦欢鍦板潃',
-  `machine_code` bigint DEFAULT NULL COMMENT '璁惧缂栧彿/鏈哄簥缂栧彿',
-  `part_no` varchar(100) NOT NULL COMMENT '闆剁粍浠剁紪鍙�',
-  `is_cured` int DEFAULT NULL COMMENT '鏄惁鍥哄寲,1鏄�;0鍚�',
-  `expire_date` date DEFAULT NULL COMMENT '鍒版湡鏃堕棿,鏍规嵁鏈夋晥鏈熸椂闀胯绠楄�屾潵',
-  `process_edition` varchar(40) DEFAULT NULL COMMENT '宸ュ簭鐗堟锛屽崌鐗堝氨鏄彉鏇存敼璇ュ瓧娈碉紝闇�瑕佷繚鐣欏巻鍙茶褰�',
-  `is_last_edition` int NOT NULL COMMENT '鏄惁鏈�鏂扮増娆★紝1锛氭渶鏂扮増娆★紱0:鍘嗗彶鐗堟锛屼富瑕佸彇璇ュ瓧娈�=1鐨勬暟鎹紝0鏄巻鍙茬増娆�',
-  `is_locked` int DEFAULT NULL COMMENT '閿佸畾鐘舵�侊紝1锛氶攣瀹氾紱0:姝ｅ父',
-  `task_assign_time` datetime DEFAULT NULL COMMENT '绋嬪簭鐨勪换鍔′笅鍙戠殑鏃堕棿锛堢敤浜庢鏌ユ槸鍚︿负閲嶅鐨勪换鍔★級',
-  `status` int DEFAULT NULL COMMENT '涓氬姟鐘舵��',
-  `create_dept` 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 '鏇存柊浜�',
-  PRIMARY KEY (`id`) USING BTREE
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='鏁版帶绋嬪簭';
 
-DROP TABLE IF EXISTS `mdm_nc_program_file`;
-CREATE TABLE `mdm_nc_program_file` (
-  `id` bigint NOT NULL,
-  `tenant_id` varchar(6) DEFAULT NULL COMMENT '鎵�灞炵鎴�',
-  `program_id` varchar(100) NOT NULL COMMENT '鎵�灞炵▼搴廼d',
-  `name` varchar(100) NOT NULL COMMENT '鏂囦欢鍚嶇О',
-  `url` varchar(100) NOT NULL COMMENT '鏂囦欢鍦板潃',
-  `status` int DEFAULT NULL COMMENT '涓氬姟鐘舵��',
-  `create_dept` 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 '鏇存柊浜�',
-  PRIMARY KEY (`id`) USING BTREE
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='鏁版帶绋嬪簭鏂囦欢';
+DROP TABLE IF EXISTS `mdm_nc_node_his`;
+CREATE TABLE `mdm_nc_node_his` (
+   `id` bigint NOT NULL,
+   `tenant_id` varchar(6) DEFAULT NULL COMMENT '鎵�灞炵鎴�',
+   `name` varchar(100) NOT NULL COMMENT '鑺傜偣鍚嶇О',
+   `process_name` varchar(20) NULL COMMENT '宸ュ簭鍚嶇О',
+   `process_no` varchar(100) NULL COMMENT '宸ュ簭鍙�',
+   `machine_code` varchar(100) DEFAULT NULL COMMENT '璁惧缂栧彿/鏈哄簥缂栧彿',
+   `machine_group_code` varchar(255) DEFAULT NULL COMMENT '鏈哄簥缁勫瓧鍏哥爜',
+   `drawing_no` varchar(100) NULL COMMENT '闆剁粍浠剁紪鍙�/鍥惧彿',
+   `is_cured` int DEFAULT NULL COMMENT '鏄惁鍥哄寲,1鏄�;0鍚�',
+   `is_locked` int DEFAULT NULL COMMENT '閿佸畾鐘舵�侊紝1锛氶攣瀹氾紱0:姝ｅ父',
+   `is_last_edition` int NULL COMMENT '鏄惁鏈�鏂扮増娆★紝1锛氭渶鏂扮増娆★紱0:鍘嗗彶鐗堟锛屼富瑕佸彇璇ュ瓧娈�=1鐨勬暟鎹紝0鏄巻鍙茬増娆�',
+   `expire_date` date DEFAULT NULL COMMENT '鍒版湡鏃堕棿,鏍规嵁鏈夋晥鏈熸椂闀胯绠楄�屾潵',
+   `process_edition` varchar(40) DEFAULT NULL COMMENT '宸ュ簭鐗堟锛屽崌鐗堝氨鏄彉鏇存敼璇ュ瓧娈碉紝闇�瑕佷繚鐣欏巻鍙茶褰�',
+   `craft_edition` varchar(40) DEFAULT NULL COMMENT '宸ヨ壓鐗堟',
+   `drawing_no_edition` varchar(100) NULL COMMENT '鍥惧彿鐗堟',
+   `parent_id` bigint DEFAULT NULL COMMENT '涓婄骇鑺傜偣ID',
+   `parent_ids` varchar(200) DEFAULT NULL COMMENT '涓婄骇鑺傜偣ID闆嗗悎锛宨d閫楀彿鍒嗛殧',
+   `node_type` varchar(20) DEFAULT NULL COMMENT '鑺傜偣绫诲瀷锛氫笟鍔″瓧鍏稿畾涔�',
+   `product_model` varchar(100) NULL COMMENT '浜у搧鍨嬪彿',
+   `program_no` varchar(20) NULL COMMENT '绋嬪簭缂栧彿,鍙湁绋嬪簭鍖呭悕鑺傜偣鎵嶆湁鍊�',
+   `his_serial` bigint NULL COMMENT '鍘嗗彶搴忓垪鍙凤紝搴忓垪鍙风浉鍚屽睘浜庡悓涓�鍘嗗彶鍒楄〃',
+   `flow_program_file_id` bigint NULL COMMENT '鍏宠仈鐨勬祦绋嬬▼搴忔枃浠秈d锛岀▼搴忔枃浠剁被鍨嬬殑鑺傜偣鎵嶆湁鍊�',
+   `process_instance_id` varchar(64) NULL COMMENT '鍏宠仈鐨勬祦绋嬪疄渚媔d锛岀▼搴忓寘 绫诲瀷鐨勮妭鐐规墠鏈夊��',
+   `deviation` varchar(100) NULL COMMENT '鍋忕鍗曞彿',
+   `version_number` int DEFAULT NULL COMMENT '鐗堟湰鍙�',
+   `status` int DEFAULT NULL COMMENT '涓氬姟鐘舵��',
+   `create_dept` 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 '鏇存柊浜�',
+   PRIMARY KEY (`id`) USING BTREE
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='绋嬪簭鑺傜偣鐩綍鍘嗗彶琛�';
 
-DROP TABLE IF EXISTS `mdm_machine_back_file`;
-CREATE TABLE `mdm_machine_back_file` (
+DROP TABLE IF EXISTS `mdm_task_dispatch`;
+CREATE TABLE `mdm_task_dispatch` (
+   `id` bigint NOT NULL,
+   `tenant_id` varchar(6) DEFAULT NULL COMMENT '鎵�灞炵鎴�',
+   `process_name` varchar(20) NULL COMMENT '宸ュ簭鍚嶇О',
+   `process_no` varchar(100) NULL COMMENT '宸ュ簭鍙�',
+   `machine_code` varchar(100) DEFAULT NULL COMMENT '璁惧缂栧彿/鏈哄簥缂栧彿',
+   `drawing_no` varchar(100) NULL COMMENT '闆剁粍浠剁紪鍙�/鍥惧彿',
+   `process_edition` varchar(40) DEFAULT NULL COMMENT '宸ュ簭鐗堟锛屽崌鐗堝氨鏄彉鏇存敼璇ュ瓧娈碉紝闇�瑕佷繚鐣欏巻鍙茶褰�',
+   `craft_edition` varchar(40) DEFAULT NULL COMMENT '宸ヨ壓鐗堟',
+   `drawing_no_edition` varchar(100) NULL COMMENT '鍥惧彿鐗堟',
+   `product_model` varchar(100) NULL COMMENT '浜у搧鍨嬪彿',
+   `deviation` varchar(100) NULL COMMENT '鍋忕鍗曞彿',
+   `err_msg` varchar(200) NULL COMMENT '閿欒鎴栬�呮彁绀轰俊鎭�',
+   `process_instance_id` varchar(64) NULL COMMENT '鍏宠仈鐨勬祦绋嬪疄渚媔d锛屾祦绋嬪彂璧峰悗濉厖',
+   `program_no` varchar(20) NULL COMMENT '鏁版帶绋嬪簭缂栧彿锛屾祦绋嬪彂璧峰悗濉厖',
+   `mes_task_id` varchar(100) NULL COMMENT 'MES浠诲姟鍞竴鏍囪瘑',
+   `inspector` varchar(40) NULL COMMENT '妫�楠屽憳锛坢es鎻愪緵锛�',
+   `check_time` datetime DEFAULT NULL COMMENT '妫�楠屾椂闂�',
+   `operator` varchar(40) NULL COMMENT '鎿嶄綔鑰咃紙mes鎻愪緵锛�',
+   `operate_time` datetime DEFAULT NULL COMMENT '鎿嶄綔鏃堕棿',
+   `status` int DEFAULT NULL COMMENT '涓氬姟鐘舵�侊紝1锛氬垵濮嬪寲锛�2:娴佺▼宸插惎鍔� 3:閲嶅娲惧伐;4锛岄獙璇佸け璐�,5锛氬惎鍔ㄥ紓甯�',
+   `create_dept` 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 '鏇存柊浜�',
+   PRIMARY KEY (`id`) USING BTREE
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='浠诲姟娲惧伐琛�';
+
+
+DROP TABLE IF EXISTS `mdm_flow_program_file`;
+CREATE TABLE `mdm_flow_program_file` (
     `id` bigint NOT NULL,
-    `filename` varchar(255) NOT NULL COMMENT '鏂囦欢鍚嶇О',
-    `machine_code` bigint DEFAULT NULL COMMENT '鎵�灞炴満搴婁唬鐮�',
+    `tenant_id` varchar(6) DEFAULT NULL COMMENT '鎵�灞炵鎴�',
+    `process_instance_id` varchar(64) NOT NULL COMMENT '娴佺▼瀹炰緥id',
+    `name` varchar(100) DEFAULT NULL COMMENT '鏂囦欢鍚�',
+    `program_name` varchar(100) DEFAULT NULL COMMENT '绋嬪簭鍚�/绋嬪簭鍖呭悕',
+    `oss_name` varchar(400) DEFAULT NULL COMMENT 'oss鏂囦欢鍚�',
+    `file_type` varchar(10) DEFAULT NULL COMMENT '鏂囦欢绫诲瀷(program/other)',
+    `is_cured` int DEFAULT 0 COMMENT '鏄惁鍥哄寲鐨�,1鏄�;0鍚︼紝娴佺▼鍙戣捣鏃跺彂鐜板浐鍖栫▼搴忚嚜鍔ㄦ彃鍏ョ殑涓哄浐鍖�1',
     `status` int DEFAULT NULL COMMENT '涓氬姟鐘舵��',
     `create_dept` bigint DEFAULT NULL COMMENT '鍒涘缓鍗曚綅',
     `is_deleted` int DEFAULT NULL,
@@ -134,7 +244,179 @@
     `create_user` bigint DEFAULT NULL COMMENT '鍒涘缓浜�',
     `update_time` datetime DEFAULT NULL COMMENT '鏇存柊鏃堕棿',
     `update_user` bigint DEFAULT NULL COMMENT '鏇存柊浜�',
-  PRIMARY KEY (`id`) USING BTREE
+    PRIMARY KEY (`id`) USING BTREE
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='娴佺▼绋嬪簭鏂囦欢';
 
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='鏈哄簥鍥炰紶鏂囦欢';
+
+/**
+  娴佺▼瀹℃壒璁板綍琛紝瀹℃壒杩囩▼涓褰�
+ */
+DROP TABLE IF EXISTS `mdm_approve_record`;
+CREATE TABLE `mdm_approve_record` (
+   `id` bigint NOT NULL,
+   `tenant_id` varchar(6) DEFAULT NULL COMMENT '鎵�灞炵鎴�',
+   `nc_program_id` bigint NULL COMMENT '绋嬪簭id銆傛湭閫夋嫨绋嬪簭涔嬪墠鏄痭ull',
+   `process_instance_id` varchar(64) DEFAULT NULL COMMENT '娴佺▼瀹炰緥id',
+   `process_definition_key` varchar(100) DEFAULT NULL COMMENT '娴佺▼瀹氫箟key',
+   `task_definition_key` varchar(100) DEFAULT NULL COMMENT '浠诲姟瀹氫箟key',
+   `task_name` varchar(100) DEFAULT NULL COMMENT '浠诲姟鍚嶇О',
+   `operate_time` datetime DEFAULT NULL COMMENT '瀹℃壒鏃堕棿',
+   `operate_result` varchar(20) DEFAULT NULL COMMENT '瀹℃壒缁撴灉',
+   `user_id` bigint NOT NULL COMMENT '瀹℃壒鐢ㄦ埛id',
+   `user_nickname` varchar(100) NOT NULL COMMENT '瀹℃壒鐢ㄦ埛濮撳悕',
+   `nc_node_id` bigint  NULL COMMENT '瀹℃壒瀵瑰簲鐨勭▼搴忓寘鑺傜偣id',
+   `comment` varchar(100) NULL COMMENT '瀹℃壒澶囨敞',
+   `status` int DEFAULT NULL COMMENT '涓氬姟鐘舵��',
+   `create_dept` 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 '鏇存柊浜�',
+   PRIMARY KEY (`id`) USING BTREE
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='鏁版帶绋嬪簭瀹℃壒璁板綍';
+
+
+DROP TABLE IF EXISTS `mdm_nc_program_approved`;
+CREATE TABLE `mdm_nc_program_approved` (
+   `id` bigint NOT NULL,
+   `tenant_id` varchar(6) DEFAULT NULL COMMENT '鎵�灞炵鎴�',
+   `nc_node_id` bigint NOT NULL COMMENT '绋嬪簭鍖呭悕瀵瑰簲鐨刵odeid',
+   `programmer_id` bigint NOT NULL COMMENT '缂栫▼鍛樼敤鎴稩D',
+   `title` varchar(200) NOT NULL COMMENT '娴佺▼鏍囬',
+   `program_name` varchar(100) NOT NULL COMMENT '绋嬪簭鍚嶇О',
+   `status` int DEFAULT NULL COMMENT '涓氬姟鐘舵��',
+   `create_dept` 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 '鏇存柊浜�',
+   PRIMARY KEY (`id`) USING BTREE
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='鏁版帶绋嬪簭瀹℃壒琛�';
+
+
+DROP TABLE IF EXISTS `mdm_dnc_back_file`;
+CREATE TABLE `mdm_dnc_back_file` (
+    `id` bigint NOT NULL,
+    `tenant_id` varchar(6) DEFAULT NULL COMMENT '鎵�灞炵鎴�',
+    `nc_node_id` bigint NOT NULL COMMENT '绋嬪簭鍖呭悕 鑺傜偣id',
+    `oss_name` varchar(100) NULL COMMENT 'oss涓殑鏂囦欢鍚嶅洖浼犵殑zip鏂囦欢鍚�',
+    `status` int DEFAULT NULL COMMENT '涓氬姟鐘舵��',
+    `create_dept` 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 '鏇存柊浜�',
+    PRIMARY KEY (`id`) USING BTREE
+
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='DNC鍥炰紶鏂囦欢璁板綍鏂�';
+
+
+
+DROP TABLE IF EXISTS `mdm_file_locks`;
+CREATE TABLE `mdm_file_locks` (
+     `lock_id` int NOT NULL COMMENT '閿佸畾id锛屽浐瀹�1',
+     `locked_by` varchar(100)  DEFAULT NULL COMMENT '閿佸畾id',
+     `lock_time` datetime DEFAULT NULL COMMENT '閿佸畾鏃堕棿',
+     PRIMARY KEY (`lock_id`) USING BTREE
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='鏂囦欢鐩戞帶閿佸畾琛�';
+
+
+DROP TABLE IF EXISTS `mdm_machine_accepted_file`;
+CREATE TABLE `mdm_machine_accepted_file` (
+     `id` bigint NOT NULL,
+     `tenant_id` varchar(6) DEFAULT NULL COMMENT '鎵�灞炵鎴�',
+     `name` varchar(100) NOT NULL COMMENT '鏂囦欢鍚嶇О',
+     `export_time` datetime DEFAULT NULL COMMENT '瀵煎嚭鏃堕棿',
+     `oss_name` varchar(100) NULL COMMENT 'oss涓殑鏂囦欢鍚�',
+     `machine_file_id` bigint NOT NULL COMMENT '鏈哄簥鏂囦欢id(mdm_machine_file.id)',
+     `status` int DEFAULT NULL COMMENT '涓氬姟鐘舵��',
+     `create_dept` 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 '鏇存柊浜�',
+     PRIMARY KEY (`id`) USING BTREE
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='鏈哄簥宸叉帴鍙楁枃浠�';
+
+DROP TABLE IF EXISTS `mdm_machine_file`;
+CREATE TABLE `mdm_machine_file` (
+    `id` bigint NOT NULL,
+    `tenant_id` varchar(6) DEFAULT NULL COMMENT '鎵�灞炵鎴�',
+    `name` varchar(100) NOT NULL COMMENT '鏂囦欢鍚嶇О',
+    `dir_type` varchar(5) DEFAULT NULL COMMENT '鐩綍绫诲瀷锛歋END/REC/TEMP',
+    `machine_code` varchar(100) DEFAULT NULL COMMENT '鏈哄簥缂栫爜',
+    `file_create_time` datetime DEFAULT NULL COMMENT '鏂囦欢鍒涘缓鏃堕棿',
+    `file_modify_time` datetime DEFAULT NULL COMMENT '鏂囦欢鍒涘缓鏃堕棿',
+    `md5` varchar(32) DEFAULT NULL COMMENT 'md5 hex',
+    `file_size` bigint DEFAULT NULL COMMENT '鏂囦欢瀛楄妭鏁�',
+    `determine_time` datetime DEFAULT NULL COMMENT '鎺ュ彈/鎷掔粷鐨勬椂闂�',
+    `program_status` int  DEFAULT NULL COMMENT '绋嬪簭鐘舵�侊紙1璇曞垏锛�2鍥哄寲锛�3鍋忕锛�4鏈煡锛�',
+    `exception_type` int  DEFAULT NULL COMMENT 'REC鐩綍鏂囦欢寮傚父绫诲瀷锛�0/null:姝ｅ父; 1闈炴枃鏈牸寮忥紱2:鏂囦欢鍚嶆牸寮忎笉鍚堟硶锛�3:鏂囦欢纭け(娈垫暟涓嶅)锛�4:鏂囦欢娈垫暟涓庝笅鍙戣褰曚笉鍖归厤锛堣溅搴�/鐜板満缂栧埗闄ゅ)',
+    `status` int DEFAULT NULL COMMENT '涓氬姟鐘舵��',
+    `create_dept` 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 '鏇存柊浜�',
+    PRIMARY KEY (`id`) USING BTREE
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='宸ユ帶缃戞満搴婃枃浠�';
+
+
+DROP TABLE IF EXISTS `mdm_machine_file_change_his`;
+CREATE TABLE `mdm_machine_file_change_his` (
+    `id` bigint NOT NULL,
+    `tenant_id` varchar(6) DEFAULT NULL COMMENT '鎵�灞炵鎴�',
+    `oss_name` varchar(100) NOT NULL COMMENT '淇敼鍓峯ss鏂囦欢鍚嶇О锛堟枃浠跺浠斤級',
+    `oss_name_after` varchar(100) NOT NULL COMMENT '淇敼鍚庣殑oss鏂囦欢鍚嶇О',
+    `machine_file_id` bigint DEFAULT NULL COMMENT '淇敼鏂囦欢鐨刬d(mdm_machine_file.id)',
+    `status` int DEFAULT NULL COMMENT '涓氬姟鐘舵��',
+    `create_dept` 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 '鏇存柊浜�',
+    PRIMARY KEY (`id`) USING BTREE
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='宸ユ帶缃戞満搴婃枃浠朵慨鏀瑰巻鍙�';
+
+
+
+DROP TABLE IF EXISTS `mdm_file_send_record`;
+CREATE TABLE `mdm_file_send_record` (
+    `id` bigint NOT NULL,
+    `tenant_id` varchar(6) DEFAULT NULL COMMENT '鎵�灞炵鎴�',
+    `name` varchar(100) NOT NULL COMMENT '鏂囦欢鍚嶇О',
+    `machine_code` varchar(100) DEFAULT NULL COMMENT '鏈哄簥缂栫爜',
+    `file_size` bigint DEFAULT NULL COMMENT '鏂囦欢瀛楄妭鏁�',
+    `status` int DEFAULT NULL COMMENT '涓氬姟鐘舵��',
+    `create_dept` 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 '鏇存柊浜�',
+    PRIMARY KEY (`id`) USING BTREE
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='宸ユ帶缃戞枃浠朵笅鍙戣褰�';
+
+DROP TABLE IF EXISTS `mdm_file_monitor_record`;
+CREATE TABLE `mdm_file_monitor_record` (
+    `id` bigint NOT NULL,
+    `name` varchar(100) NOT NULL COMMENT '鏂囦欢鍚嶇О',
+    `dir_path` varchar(100) NOT NULL COMMENT '鏂囦欢鐩綍',
+    `event_type` int DEFAULT NULL COMMENT '浜嬩欢绫诲瀷锛�1:鍒涘缓;2锛氫慨鏀�;3鍒犻櫎',
+    `create_time` datetime DEFAULT NULL COMMENT '鍒涘缓鏃堕棿',
+    PRIMARY KEY (`id`) USING BTREE
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='宸ユ帶缃戞枃浠剁洃鎺ц褰�';
+
+DROP TABLE IF EXISTS `mdm_drawing_nos`;
+CREATE TABLE `mdm_drawing_nos` (
+   `drawing_no` varchar(100) NOT NULL COMMENT '闆剁粍浠跺彿',
+   PRIMARY KEY (`drawing_no`) USING BTREE
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='闆剁粍浠跺彿涓嬫媺鏁版嵁';
 

--
Gitblit v1.9.3