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