From 5f0956f6a5bf753d8e0c0e6a7c530c65af1edf82 Mon Sep 17 00:00:00 2001 From: yangys <y_ys79@sina.com> Date: 星期一, 30 六月 2025 20:16:57 +0800 Subject: [PATCH] 流程与程序关联表插入数据 --- doc/sql/mdm/mdm.mysql.all.create.sql | 12 ++++++------ 1 files changed, 6 insertions(+), 6 deletions(-) diff --git a/doc/sql/mdm/mdm.mysql.all.create.sql b/doc/sql/mdm/mdm.mysql.all.create.sql index a5f3600..e8f4a07 100644 --- a/doc/sql/mdm/mdm.mysql.all.create.sql +++ b/doc/sql/mdm/mdm.mysql.all.create.sql @@ -87,12 +87,12 @@ ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='绋嬪簭鑺傜偣鐩綍'; /**娴佺▼瀹炰緥涓庤妭鐐瑰叧鑱旇〃锛岃褰曞垱寤烘椂鏈猴細鐢ㄦ埛鍦ㄧ▼搴忕紪鍒惰妭鐐规墜鍔ㄥ叧鑱�*/ -DROP TABLE IF EXISTS `mdm_process_node_ref`; -CREATE TABLE `mdm_process_node_ref` ( +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 '鎵�灞炵鎴�', - `nc_node_id` bigint DEFAULT NULL COMMENT '鑺傜偣id锛屽搴� 绋嬪簭鍖呭悕 鑺傜偣id', - `process_instance_id` varchar(100) NOT NULL COMMENT '娴佺▼瀹炰緥id', + `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, @@ -101,14 +101,14 @@ `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_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 '绋嬪簭缂栧彿', + `code` varchar(100) NULL COMMENT '绋嬪簭缂栧彿', `name` varchar(100) NOT NULL COMMENT '绋嬪簭鍚嶇О', `oss_name` varchar(100) NULL COMMENT 'oss涓殑鏂囦欢鍚�', `category` varchar(2) NULL COMMENT '鏂囦欢鍒嗙被', -- Gitblit v1.9.3