From f445c5ba99d8ffb6d78a03af40c74b218a6d2162 Mon Sep 17 00:00:00 2001
From: yangys <y_ys79@sina.com>
Date: 星期六, 02 八月 2025 11:27:21 +0800
Subject: [PATCH] 程序上传接口3
---
doc/sql/mdm/mdm.mysql.all.create.sql | 74 +++++++++++++++++++++++++++++++-----
1 files changed, 63 insertions(+), 11 deletions(-)
diff --git a/doc/sql/mdm/mdm.mysql.all.create.sql b/doc/sql/mdm/mdm.mysql.all.create.sql
index 5ebce10..f1fb379 100644
--- a/doc/sql/mdm/mdm.mysql.all.create.sql
+++ b/doc/sql/mdm/mdm.mysql.all.create.sql
@@ -42,16 +42,66 @@
) 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 '璁″垝鍛�',
+ 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,
- `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 '瀹℃壒楂樺笀璐﹀彿',
-
- `tenant_id` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '000000' COMMENT '绉熸埛ID',
+ `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 '鍒涘缓鍗曚綅',
`is_deleted` int DEFAULT 0,
@@ -59,9 +109,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
+ 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` (
@@ -100,13 +150,14 @@
`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 '璁惧缂栧彿/鏈哄簥缂栧彿',
`drawing_no` varchar(100) NULL COMMENT '闆剁粍浠剁紪鍙�/鍥惧彿',
`drawing_no_edition` varchar(100) NULL COMMENT '鍥惧彿鐗堟',
- `craft_edition` varchar(20) 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 '鍒版湡鏃堕棿,鏍规嵁鏈夋晥鏈熸椂闀胯绠楄�屾潵',
@@ -155,7 +206,8 @@
`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_name` varchar(100) DEFAULT NULL COMMENT '浠诲姟鍚嶇О',
+ `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',
--
Gitblit v1.9.3