From 3b4b290c72acb1cea56e7d3a2c7356577d410058 Mon Sep 17 00:00:00 2001 From: yangys <y_ys79@sina.com> Date: 星期五, 13 六月 2025 14:57:32 +0800 Subject: [PATCH] 计划表更名为分工表 --- doc/sql/mdm/mdm.all.create.sql | 99 +++++++++++++++++++++++++++++++++++++++++-------- 1 files changed, 82 insertions(+), 17 deletions(-) diff --git a/doc/sql/mdm/mdm.all.create.sql b/doc/sql/mdm/mdm.all.create.sql index a0ac7b1..47e0a57 100644 --- a/doc/sql/mdm/mdm.all.create.sql +++ b/doc/sql/mdm/mdm.all.create.sql @@ -1,8 +1,8 @@ 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', - `name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '鏈哄簥缁勫悕绉�', - `code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '鏈哄簥缁勭紪鍙�', + `name` varchar(20) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '鏈哄簥缁勫悕绉�', + `code` varchar(20) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '鏈哄簥缁勭紪鍙�', `create_user` bigint DEFAULT NULL COMMENT '鍒涘缓浜�', `create_dept` bigint DEFAULT NULL COMMENT '鍒涘缓閮ㄩ棬', `create_time` datetime DEFAULT NULL COMMENT '鍒涘缓鏃堕棿', @@ -11,46 +11,111 @@ `status` int DEFAULT '1' COMMENT '鐘舵��', `is_deleted` int DEFAULT '0' COMMENT '鏄惁宸插垹闄�', PRIMARY KEY (`id`) USING BTREE -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='鏈哄簥缁�'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE = utf8mb4_general_ci COMMENT='鏈哄簥缁�'; CREATE TABLE `mdm_machine` ( `id` bigint NOT NULL, `tenant_id` varchar(6) DEFAULT NULL COMMENT '鎵�灞炵鎴�', `code` varchar(100) NOT NULL COMMENT '鏈哄簥缂栧彿', - `name` varchar(100) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL COMMENT '鏈哄簥鍚嶇О', - `avatar` varchar(1000) DEFAULT NULL COMMENT '鍥剧墖鍦板潃', - `machine_group_id` bigint DEFAULT NULL COMMENT '鎵�灞炴満搴婄粍ID', - `status` int DEFAULT NULL COMMENT '涓氬姟鐘舵��', + `name` varchar(100) NOT NULL COMMENT '鏈哄簥鎻忚堪/鍨嬪彿', + `avatar` varchar(400) DEFAULT NULL COMMENT '鍥剧墖鍦板潃', + `machine_group_code` varchar(255) NOT NULL COMMENT '鎵�灞炴満搴婄粍浠ｇ爜锛�,鍦ㄤ笟鍔″瓧鍏搁厤缃紙key=machine_group锛�', + `machine_spec` varchar(20) DEFAULT NULL COMMENT '鏈哄櫒瑙勬牸:01杞﹀簥/02閾ｅ簥,鍦ㄤ笟鍔″瓧鍏搁厤缃紙key=machine_spec锛�', + `operator` varchar(100) COMMENT '鎿嶄綔鍛橈紝鏂囨湰褰曞叆', + `owner_dept` bigint DEFAULT NULL COMMENT '鎵�灞炲崟浣�/缁勭粐', + `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 '绋嬪簭鍥炰紶鐩綍', + `remark` varchar(200) COMMENT '澶囨敞', + `status` int DEFAULT NULL COMMENT '涓氬姟鐘舵�侊紝1锛氬惎鐢紱0绂佺敤', `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 '鏇存柊浜�' + `update_user` bigint DEFAULT NULL COMMENT '鏇存柊浜�', PRIMARY KEY (`id`) USING BTREE, - UNIQUE KEY `uniqueCodeIndex` (`code`,`is_deleted`) USING BTREE, -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='鏈哄簥'; + UNIQUE KEY `uniqueCodeIndex` (`code`,`is_deleted`) USING BTREE +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='鏈哄簥'; +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', + `status` int DEFAULT NULL COMMENT '涓氬姟鐘舵��', + `create_dept` bigint DEFAULT NULL COMMENT '鍒涘缓鍗曚綅', + `is_deleted` int DEFAULT 0, + `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 `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='涓诲埗璁″垝琛�'; + + +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, +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='绋嬪簭鑺傜偣鐩綍'; 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 '绋嬪簭缂栧彿', `name` varchar(100) NOT NULL COMMENT '绋嬪簭鍚嶇О', - `machine_group_id` bigint DEFAULT NULL COMMENT '鎵�灞炴満搴婄粍ID', - `flow_task_id` bigint DEFAULT NULL COMMENT '浠诲姟ID锛屾帴鏀朵笅鍙戜换鍔℃椂纭畾鐨勪换鍔d锛岄潪娴佺▼绀轰緥id', + `package_name` varchar(100) NOT NULL COMMENT '绋嬪簭鍖呭悕', + `machine_code` bigint DEFAULT 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:姝ｅ父', `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, -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC 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='鏁版帶绋嬪簭'; + +CREATE TABLE `mdm_nc_program_file` ( + `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 '鏂囦欢鍦板潃', + `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='鏁版帶绋嬪簭鏂囦欢'; CREATE TABLE `mdm_task_receive` ( @@ -68,4 +133,4 @@ `update_user` bigint DEFAULT NULL COMMENT '鏇存柊浜�' PRIMARY KEY (`id`) USING BTREE, UNIQUE KEY `uniqueCodeIndex` (`name`,`is_deleted`) USING BTREE, -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='浠诲姟鎺ユ敹琛�'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='浠诲姟鎺ユ敹琛�'; -- Gitblit v1.9.3