From 3f883e8b83f48253f95c5fe474494e6a86405651 Mon Sep 17 00:00:00 2001
From: yangys <y_ys79@sina.com>
Date: 星期日, 03 八月 2025 14:50:45 +0800
Subject: [PATCH] 增加文件历史接口
---
doc/sql/mdm/mdm.mysql.all.create.sql | 54 +++++++++++++++++++++++++++++++++++++++++-------------
1 files changed, 41 insertions(+), 13 deletions(-)
diff --git a/doc/sql/mdm/mdm.mysql.all.create.sql b/doc/sql/mdm/mdm.mysql.all.create.sql
index 3bf9113..452025f 100644
--- a/doc/sql/mdm/mdm.mysql.all.create.sql
+++ b/doc/sql/mdm/mdm.mysql.all.create.sql
@@ -59,7 +59,7 @@
DROP TABLE IF EXISTS `mdm_qinzhe_fgb`;
CREATE TABLE `mdm_qinzhe_fgb` (
- `cph` varchar(40) NULL COMMENT '浜у搧鍙�',
+ `cph` varchar(80) NULL COMMENT '浜у搧鍙�',
`ljh` varchar(80) NULL COMMENT '闆朵欢鍙�',
`ljmc` varchar(100) NULL COMMENT '闆朵欢鍚嶇О',
`zz` varchar(40) NULL COMMENT '涓诲埗',
@@ -96,12 +96,11 @@
DROP TABLE IF EXISTS `mdm_produce_division`;
CREATE TABLE `mdm_produce_division` (
`id` bigint NOT NULL,
- `drawing_no` varchar(100) NULL COMMENT '鍥惧彿锛岄浂缁勪欢鍙�',
- `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 '瀹℃壒楂樺笀璐﹀彿',
-
+ `drawing_no` varchar(100) Not NULL COMMENT '鍥惧彿锛岄浂缁勪欢鍙�',
+ `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 '鍒涘缓鍗曚綅',
@@ -110,8 +109,7 @@
`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
+ PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='涓诲埗鍒嗗伐琛�';
@@ -121,16 +119,24 @@
`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 '璁惧缂栧彿/鏈哄簥缂栧彿',
`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 '浜у搧鍨嬪彿',
+ `flow_program_file_id` bigint NULL COMMENT '鍏宠仈鐨勬祦绋嬬▼搴忔枃浠秈d锛岀▼搴忔枃浠剁被鍨嬬殑鑺傜偣鎵嶆湁鍊�',
+ `process_instance_id` varchar(64) NULL COMMENT '鍏宠仈鐨勬祦绋嬪疄渚媔d锛岀▼搴忓寘 绫诲瀷鐨勮妭鐐规墠鏈夊��',
`status` int DEFAULT NULL COMMENT '涓氬姟鐘舵��',
`create_dept` bigint DEFAULT NULL COMMENT '鍒涘缓鍗曚綅',
`is_deleted` int DEFAULT NULL,
@@ -180,6 +186,26 @@
) 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鏂囦欢鍚�',
+
+ `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` (
@@ -209,11 +235,12 @@
`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 '浠诲姟鍚嶇О',
+ `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 '鍒涘缓鍗曚綅',
@@ -230,7 +257,8 @@
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',
+ `program_name` varchar(100) NOT NULL COMMENT '绋嬪簭鍚嶇О',
`status` int DEFAULT NULL COMMENT '涓氬姟鐘舵��',
`create_dept` bigint DEFAULT NULL COMMENT '鍒涘缓鍗曚綅',
`is_deleted` int DEFAULT NULL,
--
Gitblit v1.9.3