From 722f3d8cfd48e3db2836578b36cff648dee1f72a Mon Sep 17 00:00:00 2001 From: liu <2021943741@qq.com> Date: 星期二, 03 十一月 2026 13:22:09 +0800 Subject: [PATCH] feat: 设备遥测实时采集与报警推送 --- doc/unattended_upgrade.sql | 23 +++++++++++++++++++++++ 1 files changed, 23 insertions(+), 0 deletions(-) diff --git a/doc/unattended_upgrade.sql b/doc/unattended_upgrade.sql index 0b10a79..f1c5a96 100644 --- a/doc/unattended_upgrade.sql +++ b/doc/unattended_upgrade.sql @@ -99,6 +99,29 @@ KEY `idx_access_plate` (`plate_number`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='闂ㄧ杩涘嚭璁板綍'; +CREATE TABLE IF NOT EXISTS `access_vehicle` ( + `id` bigint NOT NULL AUTO_INCREMENT, + `plate_number` varchar(32) NOT NULL COMMENT '杞︾墝鍙�', + `plate_color` varchar(16) DEFAULT NULL COMMENT '杞︾墝棰滆壊', + `rfid_tag` varchar(64) DEFAULT NULL COMMENT 'RFID鏍囩', + `carrier_name` varchar(120) DEFAULT NULL COMMENT '鎵胯繍鍟�', + `vehicle_type` varchar(64) DEFAULT NULL COMMENT '杞﹁締绫诲瀷', + `driver_name` varchar(64) DEFAULT NULL COMMENT '鍙告満濮撳悕', + `driver_phone` varchar(32) DEFAULT NULL COMMENT '鍙告満鐢佃瘽', + `valid_start` date DEFAULT NULL COMMENT '鏈夋晥鏈熷紑濮�', + `valid_end` date DEFAULT NULL COMMENT '鏈夋晥鏈熺粨鏉�', + `status` varchar(16) DEFAULT 'valid' COMMENT '鐘舵�� valid/disabled', + `remark` varchar(255) DEFAULT NULL, + `create_user` bigint DEFAULT NULL, + `create_time` datetime DEFAULT NULL, + `update_user` bigint DEFAULT NULL, + `update_time` datetime DEFAULT NULL, + `tenant_id` bigint DEFAULT NULL, + PRIMARY KEY (`id`), + KEY `idx_access_vehicle_plate` (`plate_number`), + KEY `idx_access_vehicle_rfid` (`rfid_tag`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='杞﹁締閫氳鎺堟潈'; + -- ------------------------------------------------------------ -- 3. 鏃犱汉鍊煎畧鍦扮锛氭墿灞曞瓧娈� -- ------------------------------------------------------------ -- Gitblit v1.9.3