From b50d902f52b5107457a1eba2dcd2f8346e936b28 Mon Sep 17 00:00:00 2001
From: tuqin <tuqin@tuqin.cn>
Date: 星期一, 26 十月 2026 09:26:30 +0800
Subject: [PATCH] docs(环保门禁): 存档地磅建表与车辆采集照片字段 DDL

---
 doc/sql/hbmjxt_ddl.sql |   49 +++++++++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 49 insertions(+), 0 deletions(-)

diff --git a/doc/sql/hbmjxt_ddl.sql b/doc/sql/hbmjxt_ddl.sql
new file mode 100644
index 0000000..e148353
--- /dev/null
+++ b/doc/sql/hbmjxt_ddl.sql
@@ -0,0 +1,49 @@
+-- ============================================================
+-- 鐜繚闂ㄧ绯荤粺 hbmjxt锛�10.136.58.73锛塂DL 瀛樻。
+-- 鎵ц搴擄細mis-ruoyi
+-- 璇存槑锛氫互涓� DDL 宸插湪 10.136.58.73 鎵ц瀹屾瘯锛屾澶勫瓨妗d究浜庣幆澧冮噸寤�
+-- ============================================================
+
+-- ------------------------------------------------------------
+-- 1. 鏃犱汉鍊煎畧鍦扮绉伴噸璁板綍琛紙鎶ヨ〃涓績鐨勬暟鎹潵婧愶級
+-- ------------------------------------------------------------
+CREATE TABLE IF NOT EXISTS env_weighbridge_system (
+  id BIGINT NOT NULL AUTO_INCREMENT COMMENT '涓婚敭',
+  plate_number VARCHAR(50) NOT NULL COMMENT '杞︾墝鍙�',
+  weight_time DATETIME NOT NULL COMMENT '绉伴噸鏃堕棿',
+  tare_weight DECIMAL(12,2) DEFAULT NULL COMMENT '鐨噸(kg)',
+  gross_weight DECIMAL(12,2) DEFAULT NULL COMMENT '姣涢噸(kg)',
+  net_weight DECIMAL(12,2) DEFAULT NULL COMMENT '鍑�閲�(kg)',
+  position_offset INT DEFAULT NULL COMMENT '鍋忕搴�(1-100)',
+  driver_name VARCHAR(50) DEFAULT NULL COMMENT '鍙告満濮撳悕',
+  contact_phone VARCHAR(30) DEFAULT NULL COMMENT '鑱旂郴鐢佃瘽',
+  cargo_name VARCHAR(100) DEFAULT NULL COMMENT '璐х墿鍚嶇О',
+  weighbridge_number VARCHAR(50) DEFAULT NULL COMMENT '鍦扮缂栧彿',
+  remark VARCHAR(500) DEFAULT NULL COMMENT '澶囨敞',
+  create_time DATETIME DEFAULT NULL COMMENT '鍒涘缓鏃堕棿',
+  create_user BIGINT DEFAULT NULL COMMENT '鍒涘缓浜�',
+  update_time DATETIME DEFAULT NULL COMMENT '鏇存柊鏃堕棿',
+  update_user BIGINT DEFAULT NULL COMMENT '鏇存柊浜�',
+  tenant_id BIGINT DEFAULT NULL COMMENT '绉熸埛id',
+  PRIMARY KEY (id),
+  KEY idx_weight_time (weight_time),
+  KEY idx_tenant (tenant_id)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='鐜繚闂ㄧ-鏃犱汉鍊煎畧鍦扮绉伴噸璁板綍';
+
+-- ------------------------------------------------------------
+-- 2. 杞﹁締淇℃伅閲囬泦瀹℃牳锛氭柊澧炵収鐗囧瓧娈碉紙鎵嬫満绔噰闆嗘媿鐓э級
+-- ------------------------------------------------------------
+ALTER TABLE vehicle_information_collection_review
+  ADD COLUMN plate_photo   VARCHAR(500) NULL COMMENT '杞︾墝鐓х墖'     AFTER fuel_type,
+  ADD COLUMN license_photo VARCHAR(500) NULL COMMENT '琛岄┒璇佺収鐗�'   AFTER plate_photo,
+  ADD COLUMN scene_photo   VARCHAR(500) NULL COMMENT '杞﹁締鍏ㄦ櫙鐓х墖' AFTER license_photo;
+
+-- ------------------------------------------------------------
+-- 3. 渚濊禆鐨勬棦鏈夎〃锛堝嬁鍒狅紝宸℃/闂ㄧ/杩滅▼鐩戞帶/璁惧鏁呴殰鍧囦緷璧栵級
+-- ------------------------------------------------------------
+-- env_inspection                        鏅鸿兘宸℃鍙拌处锛堝惈 ai_analysis / uav_data锛�
+-- env_access_vehicle                    闂ㄧ杞﹁締锛坴ehicle_type 1杩涘嚭鍘� / 2鍘傚唴 / 3闈為亾璺級
+-- env_device_command                    璁惧杩滅▼鎺у埗鎸囦护
+-- device_defect_record                  璁惧鏁呴殰璁板綍锛堥棬绂佺鐞�-璁惧鏁呴殰 + 杩滅▼鐩戞帶-寮傚父鎶ヨ 鍏卞悓鏁版嵁婧愶級
+-- device_ledger                         璁惧鍙拌处锛堣繙绋嬬洃鎺ц澶囧垪琛ㄣ�佽繙绋嬫帶鍒跺璞★級
+-- vehicle_information_collection_review 杞﹁締淇℃伅閲囬泦瀹℃牳

--
Gitblit v1.9.3