From 813f0f6d391b7f24682204c22c059ef69b124fa6 Mon Sep 17 00:00:00 2001
From: yangys <y_ys79@sina.com>
Date: 星期一, 30 六月 2025 23:59:15 +0800
Subject: [PATCH] 增加流程与程序关联查询

---
 doc/sql/mdm/mdm.mysql.all.create.sql |  110 +++++++++++++++++++++++++++++++++++++++++-------------
 1 files changed, 83 insertions(+), 27 deletions(-)

diff --git a/doc/sql/mdm/mdm.mysql.all.create.sql b/doc/sql/mdm/mdm.mysql.all.create.sql
index 41f0ffb..e8f4a07 100644
--- a/doc/sql/mdm/mdm.mysql.all.create.sql
+++ b/doc/sql/mdm/mdm.mysql.all.create.sql
@@ -60,40 +60,70 @@
     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='涓诲埗璁″垝琛�';
 
-
+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 '宸ュ簭鍚嶇О',
+   `machine_code` varchar(100) DEFAULT NULL COMMENT '璁惧缂栧彿/鏈哄簥缂栧彿',
+   `part_no` varchar(100) NULL COMMENT '闆剁粍浠剁紪鍙�/鍥惧彿',
+   `is_cured` int DEFAULT NULL COMMENT '鏄惁鍥哄寲,1鏄�;0鍚�',
+   `expire_date` date DEFAULT NULL COMMENT '鍒版湡鏃堕棿,鏍规嵁鏈夋晥鏈熸椂闀胯绠楄�屾潵',
+   `process_edition` varchar(40) DEFAULT NULL COMMENT '宸ュ簭鐗堟锛屽崌鐗堝氨鏄彉鏇存敼璇ュ瓧娈碉紝闇�瑕佷繚鐣欏巻鍙茶褰�',
+   `description` varchar(100) NOT NULL COMMENT '鎻忚堪',
+   `remark` varchar(200) NOT NULL COMMENT '澶囨敞',
+   `parent_id` bigint DEFAULT NULL COMMENT '涓婄骇鑺傜偣ID',
+   `parent_ids` varchar(100) DEFAULT NULL COMMENT '涓婄骇鑺傜偣ID闆嗗悎锛宨d閫楀彿鍒嗛殧',
+   `node_type` varchar(20) 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_process_prog_ref`;
+CREATE TABLE `mdm_process_prog_ref` (
+  `id` bigint NOT NULL,
+  `tenant_id` varchar(6) DEFAULT NULL COMMENT '鎵�灞炵鎴�',
+  `process_instance_id` varchar(64) NOT NULL COMMENT '娴佺▼瀹炰緥id',
+  `nc_program_id` bigint DEFAULT NULL COMMENT '鏁版帶绋嬪簭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_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 '绋嬪簭缂栧彿',
+  `nc_node_id` bigint DEFAULT NULL COMMENT '鎵�灞炶妭鐐筰d锛屽簲璇ュ睘浜庢煇涓暟鎺х▼搴忚妭鐐�',
+  `code` varchar(100) NULL COMMENT '绋嬪簭缂栧彿',
   `name` varchar(100) NOT NULL COMMENT '绋嬪簭鍚嶇О',
-  `package_name` varchar(100) NOT NULL COMMENT '绋嬪簭鍖呭悕',
+  `oss_name` varchar(100) NULL COMMENT 'oss涓殑鏂囦欢鍚�',
+  `category` varchar(2) NULL COMMENT '鏂囦欢鍒嗙被',
+  `process_name` varchar(20) NULL COMMENT '宸ュ簭鍚嶇О',
+  `remark` varchar(100) NULL COMMENT '澶囨敞',
+  `is_text_file` int DEFAULT NULL COMMENT '鏄惁鏂囨湰鏂囦欢',
   `url` varchar(400) NOT NULL COMMENT '鏂囦欢鍦板潃',
-  `machine_code` bigint DEFAULT NULL COMMENT '璁惧缂栧彿/鏈哄簥缂栧彿',
-  `part_no` varchar(100) NOT NULL COMMENT '闆剁粍浠剁紪鍙�',
+  `machine_code` varchar(100) DEFAULT NULL COMMENT '璁惧缂栧彿/鏈哄簥缂栧彿',
+  `part_no` varchar(100) 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:姝ｅ父',
+  `is_test` int DEFAULT NULL COMMENT '鏄惁娴嬭瘯绋嬪簭锛�1锛氭槸锛�0:鍚�',
   `task_assign_time` datetime DEFAULT NULL COMMENT '绋嬪簭鐨勪换鍔′笅鍙戠殑鏃堕棿锛堢敤浜庢鏌ユ槸鍚︿负閲嶅鐨勪换鍔★級',
   `status` int DEFAULT NULL COMMENT '涓氬姟鐘舵��',
   `create_dept` bigint DEFAULT NULL COMMENT '鍒涘缓鍗曚綅',
@@ -105,14 +135,33 @@
   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` (
+
+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 '鎵�灞炵鎴�',
+   `program_name` varchar(100) NOT NULL COMMENT '绋嬪簭鍚嶇О',
+   `program_id` bigint NOT NULL COMMENT '绋嬪簭id,鎸囧悜鏈�鏂扮殑绋嬪簭璁板綍',
+   `status` int DEFAULT NULL COMMENT '涓氬姟鐘舵��',
+   `exchange_type` int DEFAULT NULL COMMENT '浜ゆ崲绫诲瀷,1:涓嬪彂;2:鍥哄寲(dnc鍥炰紶)',
+   `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_exchange`;
+CREATE TABLE `mdm_nc_program_exchange` (
   `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 '鏂囦欢鍦板潃',
+  `name` varchar(100) NOT NULL COMMENT '绋嬪簭鍚嶇О',
   `status` int DEFAULT NULL COMMENT '涓氬姟鐘舵��',
+  `exchange_type` int DEFAULT NULL COMMENT '浜ゆ崲绫诲瀷,1:涓嬪彂;2:鍥哄寲(dnc鍥炰紶)',
   `create_dept` bigint DEFAULT NULL COMMENT '鍒涘缓鍗曚綅',
   `is_deleted` int DEFAULT NULL,
   `create_time` datetime DEFAULT NULL COMMENT '鍒涘缓鏃堕棿',
@@ -120,16 +169,23 @@
   `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='鏁版帶绋嬪簭鏂囦欢';
+) 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` (
     `id` bigint NOT NULL,
-    `filename` varchar(255) NOT NULL COMMENT '鏂囦欢鍚嶇О',
+    `program_id` varchar(255) NOT NULL COMMENT '绋嬪簭缂栫爜',
     `machine_code` bigint DEFAULT NULL COMMENT '鎵�灞炴満搴婁唬鐮�',
+    `confirm_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 '鏇存柊鏃堕棿',

--
Gitblit v1.9.3