From 62a079a15b46925283581f6caaf631b5a4558927 Mon Sep 17 00:00:00 2001
From: wlzboy <66905212@qq.com>
Date: 星期三, 24 九月 2025 11:00:10 +0800
Subject: [PATCH] feat: 初始化app
---
sql/task_tables.sql | 11 +++++++++--
1 files changed, 9 insertions(+), 2 deletions(-)
diff --git a/sql/task_tables.sql b/sql/task_tables.sql
index 4983473..ab8e4d3 100644
--- a/sql/task_tables.sql
+++ b/sql/task_tables.sql
@@ -16,6 +16,13 @@
departure_address VARCHAR(500) COMMENT '鍑哄彂鍦板潃',
destination_address VARCHAR(500) COMMENT '鐩殑鍦板潃',
+ -- GPS鍧愭爣淇℃伅
+ departure_longitude DECIMAL(10,7) COMMENT '鍑哄彂鍦扮粡搴�',
+ departure_latitude DECIMAL(10,7) COMMENT '鍑哄彂鍦扮含搴�',
+ destination_longitude DECIMAL(10,7) COMMENT '鐩殑鍦扮粡搴�',
+ destination_latitude DECIMAL(10,7) COMMENT '鐩殑鍦扮含搴�',
+ estimated_distance DECIMAL(8,2) COMMENT '棰勮鍏噷鏁�',
+
-- 鏃堕棿淇℃伅
planned_start_time DATETIME COMMENT '璁″垝寮�濮嬫椂闂�',
planned_end_time DATETIME COMMENT '璁″垝缁撴潫鏃堕棿',
@@ -28,8 +35,8 @@
dept_id BIGINT NOT NULL COMMENT '褰掑睘閮ㄩ棬ID',
-- 绯荤粺瀛楁
- create_time DATETIME NOT NULL COMMENT '鍒涘缓鏃堕棿',
- update_time DATETIME NOT NULL COMMENT '鏇存柊鏃堕棿',
+ create_time DATETIME NOT NULL COMMENT '鍒涘缓鏃堕棿',
+ update_time DATETIME NOT NULL COMMENT '鏇存柊鏃堕棿',
create_by VARCHAR(64) NOT NULL COMMENT '鍒涘缓鑰�',
update_by VARCHAR(64) COMMENT '鏇存柊鑰�',
remark VARCHAR(500) COMMENT '澶囨敞',
--
Gitblit v1.9.1