From 7cd9dbf45e8e29f3bb0c00ac4f14d5588029c3ba Mon Sep 17 00:00:00 2001
From: maven <2163098428@qq.com>
Date: 星期六, 11 十月 2025 17:45:02 +0800
Subject: [PATCH] yys 新增车牌字段
---
main-business/src/main/resources/db/migration/postgresql/V20250614134700__create_table_inspection_task.sql | 15 ++++++++++-----
1 files changed, 10 insertions(+), 5 deletions(-)
diff --git a/main-business/src/main/resources/db/migration/postgresql/V20250614134700__create_table_inspection_task.sql b/main-business/src/main/resources/db/migration/postgresql/V20250614134700__create_table_inspection_task.sql
index 68aab45..3918bfb 100644
--- a/main-business/src/main/resources/db/migration/postgresql/V20250614134700__create_table_inspection_task.sql
+++ b/main-business/src/main/resources/db/migration/postgresql/V20250614134700__create_table_inspection_task.sql
@@ -3,13 +3,14 @@
(
id BIGSERIAL PRIMARY KEY, -- 浠诲姟ID (涓婚敭锛岃嚜澧為暱)
task_name VARCHAR(255), -- 浠诲姟鍚嶇О
- inspector_id BIGINT, -- 宸℃浜哄憳id
+ inspector_id VARCHAR(255), -- 宸℃浜哄憳id
inspector VARCHAR(100), -- 宸℃浜哄憳
- port TEXT, -- 宸℃鍦扮偣
remarks TEXT, -- 澶囨敞璇存槑
registrant_id BIGINT, -- 鐧昏浜哄憳id
registrant VARCHAR(100), -- 鐧昏浜哄憳
- frequency VARCHAR(100), -- 棰戞
+ frequency_type VARCHAR(100), -- 棰戞
+ inspection_location VARCHAR(255), -- 宸℃鍦扮偣璇︾粏鎻忚堪
+ frequency_detail VARCHAR(255), -- 鏃堕棿缁嗚妭
deleted INT NOT NULL DEFAULT 0, -- 杞垹闄ゆ爣蹇楋細0=鏈垹闄わ紝1=宸插垹闄�
create_by VARCHAR(255), -- 鍒涘缓浜虹敤鎴峰悕
@@ -29,11 +30,15 @@
COMMENT
ON COLUMN inspection_task.inspector IS '鎵ц宸℃鐨勪汉鍛樺鍚�';
COMMENT
-ON COLUMN inspection_task.port IS '宸℃鍦扮偣璇︾粏鎻忚堪';
-COMMENT
ON COLUMN inspection_task.remarks IS '浠诲姟闄勫姞璇存槑鎴栫壒娈婃儏鍐佃褰�';
COMMENT
ON COLUMN inspection_task.registrant IS '浠诲姟鐧昏浜哄鍚�';
+COMMENT
+ON COLUMN inspection_task.frequency_type IS '棰戞';
+COMMENT
+ON COLUMN inspection_task.inspection_location IS '宸℃鍦扮偣璇︾粏鎻忚堪';
+COMMENT
+ON COLUMN inspection_task.frequency_detail IS '鏃堕棿缁嗚妭';
COMMENT
ON COLUMN inspection_task.deleted IS '杞垹闄ゆ爣蹇楋紝0=鏈垹闄わ紝1=宸插垹闄�';
--
Gitblit v1.9.3