From 12313d5b8a2b6eaa2c7562291cf08f23644ef1d7 Mon Sep 17 00:00:00 2001
From: yangys <y_ys79@sina.com>
Date: 星期一, 22 九月 2025 19:30:48 +0800
Subject: [PATCH] 解决回传工控网记录无法查看文件的问题
---
doc/sql/mdm/mdm.mysql.all.create.sql | 42 ++++++++++++++++++++++++++++++++++++++----
1 files changed, 38 insertions(+), 4 deletions(-)
diff --git a/doc/sql/mdm/mdm.mysql.all.create.sql b/doc/sql/mdm/mdm.mysql.all.create.sql
index f77f7a2..c73905b 100644
--- a/doc/sql/mdm/mdm.mysql.all.create.sql
+++ b/doc/sql/mdm/mdm.mysql.all.create.sql
@@ -21,7 +21,7 @@
`tenant_id` varchar(6) DEFAULT NULL COMMENT '鎵�灞炵鎴�',
`code` varchar(100) NOT NULL COMMENT '鏈哄簥缂栧彿',
`name` varchar(100) NOT NULL COMMENT '鏈哄簥鎻忚堪/鍨嬪彿',
- `avatar` varchar(400) DEFAULT NULL COMMENT '鍥剧墖鍦板潃',
+ `equipment_code` varchar(100) DEFAULT NULL COMMENT '璁惧缂栧彿',
`machine_group_code` varchar(255) NOT NULL COMMENT '鎵�灞炴満搴婄粍浠ｇ爜锛�,鍦ㄤ笟鍔″瓧鍏搁厤缃紙key=machine_group锛�',
`machine_spec` varchar(40) DEFAULT NULL COMMENT '鏈哄櫒瑙勬牸:01杞﹀簥/02閾ｅ簥,鍦ㄤ笟鍔″瓧鍏搁厤缃紙key=machine_spec锛�',
`operator` varchar(100) COMMENT '鎿嶄綔鍛橈紝鏂囨湰褰曞叆',
@@ -179,6 +179,7 @@
`parent_ids` varchar(200) DEFAULT NULL COMMENT '涓婄骇鑺傜偣ID闆嗗悎锛宨d閫楀彿鍒嗛殧',
`node_type` varchar(20) DEFAULT NULL COMMENT '鑺傜偣绫诲瀷锛氫笟鍔″瓧鍏稿畾涔�',
`product_model` varchar(100) NULL COMMENT '浜у搧鍨嬪彿',
+ `program_no` varchar(20) NULL COMMENT '绋嬪簭缂栧彿,鍙湁绋嬪簭鍖呭悕鑺傜偣鎵嶆湁鍊�',
`his_serial` bigint NULL COMMENT '鍘嗗彶搴忓垪鍙凤紝搴忓垪鍙风浉鍚屽睘浜庡悓涓�鍘嗗彶鍒楄〃',
`flow_program_file_id` bigint NULL COMMENT '鍏宠仈鐨勬祦绋嬬▼搴忔枃浠秈d锛岀▼搴忔枃浠剁被鍨嬬殑鑺傜偣鎵嶆湁鍊�',
`process_instance_id` varchar(64) NULL COMMENT '鍏宠仈鐨勬祦绋嬪疄渚媔d锛岀▼搴忓寘 绫诲瀷鐨勮妭鐐规墠鏈夊��',
@@ -201,6 +202,7 @@
`process_name` varchar(20) NULL COMMENT '宸ュ簭鍚嶇О',
`process_no` varchar(100) NULL COMMENT '宸ュ簭鍙�',
`machine_code` varchar(100) DEFAULT NULL COMMENT '璁惧缂栧彿/鏈哄簥缂栧彿',
+ `equipment_code` varchar(100) DEFAULT NULL COMMENT '璁惧缂栧彿',
`drawing_no` varchar(100) NULL COMMENT '闆剁粍浠剁紪鍙�/鍥惧彿',
`process_edition` varchar(40) DEFAULT NULL COMMENT '宸ュ簭鐗堟锛屽崌鐗堝氨鏄彉鏇存敼璇ュ瓧娈碉紝闇�瑕佷繚鐣欏巻鍙茶褰�',
`craft_edition` varchar(40) DEFAULT NULL COMMENT '宸ヨ壓鐗堟',
@@ -210,7 +212,8 @@
`err_msg` varchar(200) NULL COMMENT '閿欒鎴栬�呮彁绀轰俊鎭�',
`process_instance_id` varchar(64) NULL COMMENT '鍏宠仈鐨勬祦绋嬪疄渚媔d锛屾祦绋嬪彂璧峰悗濉厖',
`program_no` varchar(20) NULL COMMENT '鏁版帶绋嬪簭缂栧彿锛屾祦绋嬪彂璧峰悗濉厖',
- `mes_task_id` varchar(100) NULL COMMENT 'MES浠诲姟鍞竴鏍囪瘑',
+ `operation_id` varchar(100) NULL COMMENT '宸ュ簭鍞竴鐮�(MES鍙戦��)',
+ `process_card` varchar(40) NULL COMMENT '杩囩▼鍗″彿锛坢es鎻愪緵锛�',
`inspector` varchar(40) NULL COMMENT '妫�楠屽憳锛坢es鎻愪緵锛�',
`check_time` datetime DEFAULT NULL COMMENT '妫�楠屾椂闂�',
`operator` varchar(40) NULL COMMENT '鎿嶄綔鑰咃紙mes鎻愪緵锛�',
@@ -384,8 +387,6 @@
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='宸ユ帶缃戞満搴婃枃浠朵慨鏀瑰巻鍙�';
-
-
DROP TABLE IF EXISTS `mdm_file_send_record`;
CREATE TABLE `mdm_file_send_record` (
`id` bigint NOT NULL,
@@ -419,3 +420,36 @@
PRIMARY KEY (`drawing_no`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='闆剁粍浠跺彿涓嬫媺鏁版嵁';
+
+DROP TABLE IF EXISTS `mdm_program_on_machine`;
+CREATE TABLE `mdm_program_on_machine` (
+ `id` bigint NOT NULL,
+ `tenant_id` varchar(6) DEFAULT NULL COMMENT '鎵�灞炵鎴�',
+ `drawing_no` varchar(100) NULL COMMENT '闆剁粍浠剁紪鍙�/鍥惧彿',
+ `process_no` varchar(100) NULL COMMENT '宸ュ簭鍙�',
+ `process_edition` varchar(40) DEFAULT NULL COMMENT '宸ュ簭鐗堟',
+ `machine_code` varchar(100) DEFAULT NULL COMMENT '鏈哄簥缂栧彿',
+ `deviation` varchar(100) DEFAULT NULL COMMENT '涓存椂鏇存敼鍗�',
+ `process_instance_id` varchar(64) DEFAULT NULL COMMENT '娴佺▼瀹炰緥id',
+ `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_mes_sync`;
+CREATE TABLE `mdm_mes_sync` (
+ `id` bigint NOT NULL,
+ `operation_id` varchar(100) NULL COMMENT '宸ュ簭鍞竴鐮�',
+ `program_no` varchar(100) NOT NULL COMMENT '绋嬪簭缂栧彿',
+ `cured_time` datetime NOT NULL COMMENT '鍥哄寲鏃堕棿',
+ `try_times` int NOT NULL DEFAULT 0 COMMENT '閲嶈瘯娆℃暟',
+ `status` int NOT NULL COMMENT '鐘舵�侊細1:鍒濆鍏ュ簱; 2:鍚屾鎴愬姛;3:鍚屾澶辫触',
+ `create_time` datetime NOT NULL COMMENT '鍒涘缓鏃堕棿',
+ `update_time` datetime NOT NULL COMMENT '鏇存柊鏃堕棿',
+ PRIMARY KEY (`id`) USING BTREE
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='鍚慚ES鍥炰紶鏁版嵁';
--
Gitblit v1.9.3