From dc0fea5a5f163e6bfcf7cb887b741b13d86728c4 Mon Sep 17 00:00:00 2001 From: yangys <y_ys79@sina.com> Date: 星期三, 11 六月 2025 16:50:01 +0800 Subject: [PATCH] 增加dnc导入 --- doc/sql/mdm/mdm.all.create.sql | 51 +++++++++++++++++++++++++++++++++++++++------------ 1 files changed, 39 insertions(+), 12 deletions(-) diff --git a/doc/sql/mdm/mdm.all.create.sql b/doc/sql/mdm/mdm.all.create.sql index a0ac7b1..27fbbd2 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,27 +11,54 @@ `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_id` bigint NOT NULL COMMENT '鎵�灞炴満搴婄粍ID', + `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_plan` ( + `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_program` ( `id` bigint NOT NULL, @@ -50,7 +77,7 @@ `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='鏁版帶绋嬪簭'; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='鏁版帶绋嬪簭'; CREATE TABLE `mdm_task_receive` ( @@ -68,4 +95,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