From 06a17c236d4cb9b8da75fce43af938cb7ea510bf Mon Sep 17 00:00:00 2001
From: wlzboy <66905212@qq.com>
Date: 星期一, 15 十二月 2025 09:50:12 +0800
Subject: [PATCH] feat: 优化企业微信判断,优化gps分断处理
---
sql/sys_task_emergency.sql | 9 +++++++++
1 files changed, 9 insertions(+), 0 deletions(-)
diff --git a/sql/sys_task_emergency.sql b/sql/sys_task_emergency.sql
index fcbd5b2..8288b3d 100644
--- a/sql/sys_task_emergency.sql
+++ b/sql/sys_task_emergency.sql
@@ -40,6 +40,15 @@
passenger_contact VARCHAR(100) COMMENT '涔樺鑱旂郴浜�',
passenger_phone VARCHAR(20) COMMENT '涔樺鑱旂郴鐢佃瘽',
+ -- 鐥呮儏璇婃柇淇℃伅
+ disease_ids VARCHAR(500) COMMENT '鐥呮儏ID鍒楄〃锛圛CD-10鐤剧梾ID鍒楄〃锛岄�楀彿鍒嗛殧锛岀敤浜庡悓姝ヨ皟搴﹀崟鐨凮rdICD_ID鍙傛暟锛�',
+
+ -- 鏃х郴缁熷悓姝ュ瓧娈�
+ legacy_dispatch_ord_no VARCHAR(50) COMMENT '鏃х郴缁熻皟搴﹀崟缂栧彿',
+ legacy_service_ns_time DATETIME COMMENT '鏃х郴缁熸湇鍔¢�氱煡鏃堕棿',
+ legacy_dispatch_ns_time DATETIME COMMENT '鏃х郴缁熻皟搴﹂�氱煡鏃堕棿',
+ legacy_dispatch_ord_class VARCHAR(50) COMMENT '鏃х郴缁熻皟搴﹀崟鍒嗙被',
+
-- 绯荤粺瀛楁
create_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
update_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿',
--
Gitblit v1.9.1