From f6dc22517ad5a9285c8e0dc586c664d06c914823 Mon Sep 17 00:00:00 2001
From: yangys <y_ys79@sina.com>
Date: 星期三, 27 八月 2025 18:12:14 +0800
Subject: [PATCH] 异常任务增加排序
---
doc/sql/mdm/mdm.mysql.all.create.sql | 332 +++++++++++++++++++++++++++++++++++++++++++++++--------
1 files changed, 284 insertions(+), 48 deletions(-)
diff --git a/doc/sql/mdm/mdm.mysql.all.create.sql b/doc/sql/mdm/mdm.mysql.all.create.sql
index 1218e1d..e72829f 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 '鎵�灞炵鎴�',
@@ -27,8 +29,11 @@
`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,9 +114,9 @@
`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` (
@@ -66,16 +124,27 @@
`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 '璁惧缂栧彿/鏈哄簥缂栧彿',
- `part_no` varchar(100) 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 '宸ュ簭鐗堟锛屽崌鐗堝氨鏄彉鏇存敼璇ュ瓧娈碉紝闇�瑕佷繚鐣欏巻鍙茶褰�',
- `description` varchar(100) NOT NULL COMMENT '鎻忚堪',
- `remark` varchar(200) NOT 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 '绋嬪簭缂栧彿,鍙湁绋嬪簭鍖呭悕鑺傜偣鎵嶆湁鍊�',
+ `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,
@@ -86,40 +155,51 @@
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_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(100) NULL COMMENT '閿欒鎴栬�呮彁绀轰俊鎭�',
+ `process_instance_id` varchar(64) NULL COMMENT '鍏宠仈鐨勬祦绋嬪疄渚媔d锛屾祦绋嬪彂璧峰悗濉厖',
+ `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_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锛屽簲璇ュ睘浜庢煇涓暟鎺х▼搴忚妭鐐�',
+ `nc_node_id` bigint DEFAULT NULL COMMENT '鎵�灞炶妭鐐筰d锛屽簲璇ュ睘浜庢煇涓暟鎺х▼搴忚妭鐐圭殑涓嬬骇',
+ `bind_nc_node_id` bigint DEFAULT NULL COMMENT '缁戝畾鑺傜偣id锛岀粦瀹氳妭鐐逛笌鏂囦欢鍚嶅悓鍚嶏紝渚夸簬鏄剧ず鏍戠粨鏋�',
`code` varchar(100) NULL COMMENT '绋嬪簭缂栧彿',
`name` varchar(100) NOT NULL COMMENT '绋嬪簭鍚嶇О',
`oss_name` varchar(100) NULL COMMENT 'oss涓殑鏂囦欢鍚�',
`category` varchar(20) NULL COMMENT '鏂囦欢鍒嗙被',
`process_name` varchar(20) NULL COMMENT '宸ュ簭鍚嶇О',
+ `process_no` varchar(20) NULL COMMENT '宸ュ簭鍙�',
`remark` varchar(100) NULL COMMENT '澶囨敞',
`is_text_file` int DEFAULT NULL COMMENT '鏄惁鏂囨湰鏂囦欢',
`url` varchar(400) NOT NULL COMMENT '鏂囦欢鍦板潃',
`machine_code` varchar(100) DEFAULT NULL COMMENT '璁惧缂栧彿/鏈哄簥缂栧彿',
- `part_no` varchar(100) NULL COMMENT '闆剁粍浠剁紪鍙�/鍥惧彿',
- `part_no_edition` varchar(100) NULL COMMENT '鍥惧彿鐗堟',
- `craft_edition` varchar(20) NULL COMMENT '璁捐鐗堟',
+ `drawing_no` varchar(100) NULL COMMENT '闆剁粍浠剁紪鍙�/鍥惧彿',
+ `drawing_no_edition` varchar(100) NULL COMMENT '鍥惧彿鐗堟',
+ `craft_edition` varchar(20) NULL COMMENT '宸ヨ壓鐗堟',
`description` varchar(100) NULL COMMENT '鎻忚堪',
`is_cured` int DEFAULT NULL COMMENT '鏄惁鍥哄寲,1鏄�;0鍚�',
`expire_date` date DEFAULT NULL COMMENT '鍒版湡鏃堕棿,鏍规嵁鏈夋晥鏈熸椂闀胯绠楄�屾潵',
@@ -127,6 +207,7 @@
`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:鍚�',
+ `version_number` int DEFAULT NULL COMMENT '鐗堟湰鍙�',
`task_assign_time` datetime DEFAULT NULL COMMENT '绋嬪簭鐨勪换鍔′笅鍙戠殑鏃堕棿锛堢敤浜庢鏌ユ槸鍚︿负閲嶅鐨勪换鍔★級',
`status` int DEFAULT NULL COMMENT '涓氬姟鐘舵��',
`create_dept` bigint DEFAULT NULL COMMENT '鍒涘缓鍗曚綅',
@@ -138,6 +219,66 @@
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,
+ `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,
+ `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_replace_program_file`;
+CREATE TABLE `mdm_replace_program_file` (
+ `id` bigint NOT NULL,
+ `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鏂囦欢鍚�',
+ `temp_id` bigint NULL,
+ `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',
+ `process_definition_key` varchar(100) DEFAULT NULL COMMENT '娴佺▼瀹氫箟key',
+ `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='娴佺▼瀹炰緥涓庣▼搴忓叧鑱旇〃';
+
/**
娴佺▼瀹℃壒璁板綍琛紝瀹℃壒杩囩▼涓褰�
*/
@@ -147,12 +288,15 @@
`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 '瀹℃壒鐢ㄦ埛濮撳悕',
- `comment` 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,
@@ -168,7 +312,10 @@
CREATE TABLE `mdm_nc_program_approved` (
`id` bigint NOT NULL,
`tenant_id` varchar(6) DEFAULT NULL COMMENT '鎵�灞炵鎴�',
- `nc_program_id` bigint NOT NULL COMMENT '绋嬪簭id,鎸囧悜鏈�鏂扮殑绋嬪簭璁板綍',
+ `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,
@@ -186,7 +333,7 @@
`id` bigint NOT NULL,
`tenant_id` varchar(6) DEFAULT NULL COMMENT '鎵�灞炵鎴�',
`name` varchar(100) NOT NULL COMMENT '绋嬪簭鍚嶇О',
- `nc_program_id` bigint DEFAULT NULL COMMENT '绋嬪簭鏂囦欢id',
+ `nc_node_id` bigint DEFAULT NULL COMMENT '绋嬪簭鍖呭悕 鐨勮妭鐐筰d',
`status` int DEFAULT NULL COMMENT '涓氬姟鐘舵��',
`exchange_type` int DEFAULT NULL COMMENT '浜ゆ崲绫诲瀷,1:涓嬪彂;2:鍥哄寲(dnc鍥炰紶)',
`create_dept` bigint DEFAULT NULL COMMENT '鍒涘缓鍗曚綅',
@@ -200,16 +347,34 @@
-DROP TABLE IF EXISTS `mdm_machine_back_file`;
-CREATE TABLE `mdm_machine_back_file` (
+DROP TABLE IF EXISTS `mdm_dnc_back_fileold`;
+CREATE TABLE `mdm_dnc_back_fileold` (
+ `id` bigint NOT NULL,
+ `tenant_id` varchar(6) DEFAULT NULL COMMENT '鎵�灞炵鎴�',
+ `nc_node_id` bigint NOT NULL COMMENT '绋嬪簭鍖呭悕 鑺傜偣id',
+ `confirm_time` datetime DEFAULT NULL COMMENT '纭鏃堕棿',
+ `oss_name` varchar(100) NULL COMMENT 'oss涓殑鏂囦欢鍚�',
+ `url` varchar(400) 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='DNC鍥炰紶鏂囦欢璁板綍';
+
+
+DROP TABLE IF EXISTS `mdm_dnc_back_file`;
+CREATE TABLE `mdm_dnc_back_file` (
`id` bigint NOT NULL,
- `program_id` varchar(255) NOT NULL COMMENT '绋嬪簭缂栫爜',
- `machine_code` bigint DEFAULT NULL COMMENT '鎵�灞炴満搴婁唬鐮�',
- `confirm_time` datetime DEFAULT NULL COMMENT '纭鏃堕棿',
-
+ `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,
@@ -217,7 +382,78 @@
`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='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_program_node`;
+CREATE TABLE `mdm_program_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',
+ `parent_ids` varchar(200) DEFAULT NULL COMMENT '涓婄骇鑺傜偣ID闆嗗悎锛宨d閫楀彿鍒嗛殧',
+ `node_type` varchar(20) DEFAULT NULL COMMENT '10:鏅�氳妭鐐癸紙鏈烘瀯锛屾満搴婏級锛�60锛氱▼搴忓寘锛�70锛氱▼搴忔枃浠�',
+ `program_file_id` bigint NULL COMMENT '鍏宠仈鐨勬祦绋嬬▼搴忔枃浠秈d锛岀▼搴忔枃浠剁被鍨嬬殑鑺傜偣鎵嶆湁鍊�',
+
+ `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` (
+ `id` bigint NOT NULL,
+ `tenant_id` varchar(6) DEFAULT NULL COMMENT '鎵�灞炵鎴�',
+ `confirm_time` datetime DEFAULT NULL COMMENT '纭鏃堕棿',
+ `oss_name` varchar(100) NULL COMMENT 'oss涓殑鏂囦欢鍚�',
+ `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 '鎺ュ彈/鎷掔粷鐨勬椂闂�',
+ `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='宸ユ帶缃戞満搴婃枃浠�';
--
Gitblit v1.9.3