From 0acd500f0a2e2e34ff199472dd5575723afb6358 Mon Sep 17 00:00:00 2001
From: zhizhijie <zhizhijie@users.noreply.gitee.com>
Date: 星期日, 27 九月 2026 17:48:04 +0800
Subject: [PATCH] fix(汇总表母版): 157 格文本型数字改为数值(公交 AF/M 各68 + G 17、轨道轮渡 4)；重新生成验证仅 68 格类型变化、值不变。并记录排名页块顺序/辅助列定位

---
 deploy-templates/db/init.sql |  619 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 619 insertions(+), 0 deletions(-)

diff --git a/deploy-templates/db/init.sql b/deploy-templates/db/init.sql
new file mode 100644
index 0000000..f75c5d7
--- /dev/null
+++ b/deploy-templates/db/init.sql
@@ -0,0 +1,619 @@
+-- 浜ら�氱粺璁℃姤琛ㄥ鏍哥郴缁� - 鏁版嵁搴撳垵濮嬪寲鑴氭湰 v3
+-- Demo鑼冨洿锛氫氦浼佺粺H203-2琛╛閬撹矾璐х墿杩愯緭鏈堝害鐢熶骇鎯呭喌
+
+CREATE DATABASE IF NOT EXISTS traffic_audit DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
+USE traffic_audit;
+
+-- ============================================
+-- 涓�銆佺敤鎴锋潈闄愭ā鍧楋紙鍚笁鍛橈級
+-- ============================================
+
+-- 閮ㄩ棬琛�
+DROP TABLE IF EXISTS sys_dept;
+CREATE TABLE sys_dept (
+    id BIGINT AUTO_INCREMENT PRIMARY KEY,
+    dept_name VARCHAR(100) NOT NULL COMMENT '閮ㄩ棬鍚嶇О',
+    dept_code VARCHAR(20) NOT NULL COMMENT '琛屾斂鍖哄垝浠ｇ爜',
+    parent_id BIGINT DEFAULT 0 COMMENT '涓婄骇閮ㄩ棬',
+    dept_level TINYINT COMMENT '1鐪� 2甯� 3鍘�',
+    sort_order INT DEFAULT 0
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
+
+-- 瑙掕壊琛�
+DROP TABLE IF EXISTS sys_role;
+CREATE TABLE sys_role (
+    id BIGINT AUTO_INCREMENT PRIMARY KEY,
+    role_name VARCHAR(50) NOT NULL COMMENT '瑙掕壊鍚�',
+    role_code VARCHAR(50) NOT NULL COMMENT 'SYS_ADMIN/SEC_OFFICER/AUDITOR/PROVINCE/CITY/COUNTY',
+    role_type VARCHAR(20) DEFAULT 'BUSINESS' COMMENT 'SYSTEM(涓夊憳)/BUSINESS(涓氬姟)',
+    role_level TINYINT DEFAULT 1 COMMENT '0涓夊憳 1鐪佸巺 2甯傚眬 3鍘垮尯',
+    is_mutex TINYINT DEFAULT 0 COMMENT '1涓夊憳浜掓枼 0鏅��'
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
+
+-- 鐢ㄦ埛琛�
+DROP TABLE IF EXISTS sys_user;
+CREATE TABLE sys_user (
+    id BIGINT AUTO_INCREMENT PRIMARY KEY,
+    username VARCHAR(50) NOT NULL UNIQUE,
+    password VARCHAR(200) NOT NULL COMMENT 'BCrypt',
+    real_name VARCHAR(50),
+    modules VARCHAR(255) DEFAULT NULL COMMENT '璐熻矗鎶ヨ〃妯″潡锛堥�楀彿鍒嗛殧锛�',
+    phone VARCHAR(20),
+    dept_id BIGINT,
+    status TINYINT DEFAULT 1 COMMENT '0绂佺敤 1鍚敤',
+    created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
+    updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
+
+-- 鐢ㄦ埛瑙掕壊鍏宠仈
+DROP TABLE IF EXISTS sys_user_role;
+CREATE TABLE sys_user_role (
+    id BIGINT AUTO_INCREMENT PRIMARY KEY,
+    user_id BIGINT NOT NULL,
+    role_id BIGINT NOT NULL
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
+
+-- ============================================
+-- 浜屻�佷笟鍔℃暟鎹ā鍧�
+-- ============================================
+
+-- 娓呯悊鏃х増閬楃暀琛紙v2 schema锛�
+DROP TABLE IF EXISTS report_enterprise_monthly;
+
+-- 浜や紒缁烪203-2琛細閬撹矾璐х墿杩愯緭鏈堝害鐢熶骇鎯呭喌锛圖emo鏍稿績琛級
+DROP TABLE IF EXISTS h2032_enterprise_monthly;
+CREATE TABLE h2032_enterprise_monthly (
+    id BIGINT AUTO_INCREMENT PRIMARY KEY,
+    report_period VARCHAR(20) NOT NULL COMMENT '鎶ヨ〃鏈� 2026-06',
+    region_code VARCHAR(20) COMMENT '鎵�灞炲湴鍖�',
+    enterprise_code VARCHAR(50) COMMENT '浼佷笟浠ｇ爜',
+    enterprise_name VARCHAR(200) COMMENT '浼佷笟鍚嶇О',
+    unified_credit_code VARCHAR(50) COMMENT '缁熶竴绀句細淇＄敤浠ｇ爜',
+    report_unit VARCHAR(200) COMMENT '濉姤鍗曚綅',
+
+    -- 杞﹁締鏁颁笌鍚ㄤ綅鏁�
+    vehicle_total INT COMMENT '杞﹁締鏁癬鎬昏',
+    tons_total DOUBLE COMMENT '鏍囪鍚ㄤ綅鏁癬鎬昏',
+    vehicle_tractor INT COMMENT '杞﹁締鏁癬鐗靛紩杞�',
+    vehicle_trailer INT COMMENT '杞﹁締鏁癬鎸傝溅',
+    tons_trailer DOUBLE COMMENT '鏍囪鍚ㄤ綅鏁癬鎸傝溅',
+    vehicle_container INT COMMENT '杞﹁締鏁癬闆嗚绠辫溅',
+    tons_container DOUBLE COMMENT '鏍囪鍚ㄤ綅鏁癬闆嗚绠辫溅',
+    vehicle_whole INT COMMENT '杞﹁締鏁癬鏁磋溅',
+    tons_whole DOUBLE COMMENT '鏍囪鍚ㄤ綅鏁癬鏁磋溅',
+
+    -- 璐ц繍閲忎笌鍛ㄨ浆閲�
+    freight_total DOUBLE COMMENT '璐ц繍閲廮鎬昏锛堝惃锛�',
+    turnover_total DOUBLE COMMENT '璐х墿鍛ㄨ浆閲廮鎬昏锛堝惃鍏噷锛�',
+
+    -- 鍒嗚揣绫昏揣杩愰噺
+    freight_container DOUBLE COMMENT '璐ц繍閲廮闆嗚绠憋紙鍚級',
+    freight_coal DOUBLE COMMENT '璐ц繍閲廮鐓ょ偔鍙婂埗鍝侊紙鍚級',
+    freight_oil_gas DOUBLE COMMENT '璐ц繍閲廮鐭虫补澶╃劧姘斿強鍒跺搧锛堝惃锛�',
+    freight_crude_oil DOUBLE COMMENT '璐ц繍閲廮鍏朵腑鍘熸补锛堝惃锛�',
+    freight_metal_ore DOUBLE COMMENT '璐ц繍閲廮閲戝睘鐭跨煶锛堝惃锛�',
+    freight_iron_ore DOUBLE COMMENT '璐ц繍閲廮鍏朵腑閾佺熆鐭筹紙鍚級',
+    freight_building DOUBLE COMMENT '璐ц繍閲廮鐭跨墿鎬у缓绛戞潗鏂欙紙鍚級',
+    freight_grain DOUBLE COMMENT '璐ц繍閲廮绮锛堝惃锛�',
+
+    -- 杩愯惀鎸囨爣
+    avg_tonnage DOUBLE COMMENT '璐ц溅骞冲潎鍚ㄤ綅',
+    avg_tonnage_trailer DOUBLE COMMENT '骞冲潎鍚ㄤ綅_鎸傝溅',
+    avg_tonnage_whole DOUBLE COMMENT '骞冲潎鍚ㄤ綅_鏁磋溅',
+    avg_distance DOUBLE COMMENT '璐ц溅骞冲潎杩愯窛锛堝叕閲岋級',
+    daily_trips_per_ton DOUBLE COMMENT '鍗曞惃鏃ュ潎杞借繍娆℃暟',
+    daily_mileage_per_vehicle DOUBLE COMMENT '鍗曡溅鍗曞ぉ琛岄┒閲岀▼锛堝叕閲岋級',
+    daily_volume_per_vehicle DOUBLE COMMENT '鍗曡溅鏃ュ潎杩愰噺锛堝惃锛�',
+    daily_trips_with_tractor DOUBLE COMMENT '鍗曞惃鏃ュ潎杞借繍娆℃暟锛堢粨鍚堢壍寮曡溅锛�',
+
+    -- 鐜瘮澧為��
+    vehicle_mom_growth DOUBLE COMMENT '杞﹁締鏁�-鎬昏鐜瘮澧為��',
+    tons_mom_growth DOUBLE COMMENT '鏍囪鍚ㄤ綅-鎬昏鐜瘮澧為��',
+    freight_mom_growth DOUBLE COMMENT '璐ц繍閲�-鎬昏鐜瘮澧為��',
+    turnover_mom_growth DOUBLE COMMENT '璐х墿鍛ㄨ浆閲�-鎬昏鐜瘮澧為��',
+    avg_distance_mom_growth DOUBLE COMMENT '璐ц溅骞冲潎杩愯窛-鐜瘮澧為��',
+
+    -- 鍚屾瘮澧為��
+    vehicle_yoy_growth DOUBLE COMMENT '杞﹁締鏁�-鎬昏鍚屾瘮澧為��',
+    tons_yoy_growth DOUBLE COMMENT '鏍囪鍚ㄤ綅-鎬昏鍚屾瘮澧為��',
+    tractor_trailer_ratio DOUBLE COMMENT '鐗靛紩杞︽寕杞︽瘮',
+    freight_yoy_growth DOUBLE COMMENT '璐ц繍閲�-鎬昏鍚屾瘮澧為��',
+    turnover_yoy_growth DOUBLE COMMENT '璐х墿鍛ㄨ浆閲�-鎬昏鍚屾瘮澧為��',
+    avg_distance_yoy_growth DOUBLE COMMENT '璐ц溅骞冲潎杩愯窛-鍚屾瘮澧為��',
+
+    -- 濉姤淇℃伅
+    unit_leader VARCHAR(50) COMMENT '鍗曚綅璐熻矗浜�',
+    stats_leader VARCHAR(50) COMMENT '缁熻璐熻矗浜�',
+    contact_person VARCHAR(50) COMMENT '濉〃浜�',
+    contact_phone VARCHAR(20) COMMENT '鑱旂郴鐢佃瘽',
+    report_date DATE COMMENT '鎶ュ嚭鏃ユ湡',
+    verify_explanation TEXT COMMENT '鏍稿疄鎬у師鍥犺В閲�',
+    report_notes TEXT COMMENT '涓婃姤璇存槑',
+    modify_record TEXT COMMENT '淇敼璁板綍',
+
+    import_batch_id BIGINT COMMENT '瀵煎叆鎵规',
+    created_at DATETIME DEFAULT CURRENT_TIMESTAMP
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='浜や紒缁烪203-2琛╛閬撹矾璐х墿杩愯緭鏈堝害鐢熶骇鎯呭喌';
+
+-- 杩愭斂杞﹁締鏁版嵁
+DROP TABLE IF EXISTS transport_auth_vehicle;
+CREATE TABLE transport_auth_vehicle (
+    id BIGINT AUTO_INCREMENT PRIMARY KEY,
+    report_period VARCHAR(20) COMMENT '鎶ヨ〃鏈�',
+    enterprise_name VARCHAR(200) COMMENT '浼佷笟鍚嶇О',
+    tractor_count INT DEFAULT 0 COMMENT '鎬荤壍寮曡溅鏁�',
+    trailer_count INT DEFAULT 0 COMMENT '鎬绘寕杞︽暟',
+    other_count INT DEFAULT 0 COMMENT '鍏跺畠杞﹁締鏁�',
+    trailer_tons DOUBLE COMMENT '鎸傝溅鎬诲惃浣�(鍚�)',
+    other_tons DOUBLE COMMENT '鍏跺畠杞﹁締鎬诲惃浣�(鍚�)',
+    import_batch_id BIGINT COMMENT '瀵煎叆鎵规',
+    created_at DATETIME DEFAULT CURRENT_TIMESTAMP
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='杩愭斂杞﹁締鏁版嵁';
+
+-- 杞﹁締杞ㄨ抗閲岀▼鏁版嵁
+DROP TABLE IF EXISTS vehicle_track_mileage;
+CREATE TABLE vehicle_track_mileage (
+    id BIGINT AUTO_INCREMENT PRIMARY KEY,
+    enterprise_name VARCHAR(200) COMMENT '浼佷笟鍚嶇О',
+    monthly_mileage DOUBLE COMMENT '鏈堝害鎬婚噷绋�(鍏噷)',
+    tracked_vehicles INT DEFAULT 0 COMMENT '鏈夐噷绋嬬殑杞﹁締鏁�',
+    report_period VARCHAR(20) COMMENT '鎶ヨ〃鏈�',
+    import_batch_id BIGINT COMMENT '瀵煎叆鎵规',
+    created_at DATETIME DEFAULT CURRENT_TIMESTAMP
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='杞﹁締杞ㄨ抗閲岀▼鏁版嵁';
+
+-- 瑙勪笂瑙勪笅鎷嗗垎杩愯緭閲忥紙鐢ㄦ埛鎵嬪姩涓婁紶锛�
+DROP TABLE IF EXISTS scale_split_transport;
+CREATE TABLE scale_split_transport (
+    id BIGINT AUTO_INCREMENT PRIMARY KEY,
+    report_period VARCHAR(20) NOT NULL COMMENT '鎶ヨ〃鏈� 2026-06',
+    period_type VARCHAR(10) NOT NULL COMMENT 'MONTH褰撴湀/CUMULATIVE绱',
+    region_name VARCHAR(50) COMMENT '甯傚窞鍚嶇О',
+
+    -- 瑙勪笂
+    above_scale_freight DOUBLE COMMENT '瑙勪笂璐ц繍閲�',
+    above_scale_turnover DOUBLE COMMENT '瑙勪笂鍛ㄨ浆閲�',
+    above_scale_rank INT COMMENT '瑙勪笂鎺掑悕',
+    above_scale_yoy DOUBLE COMMENT '瑙勪笂鍚屾瘮',
+    above_scale_yoy_rank INT COMMENT '瑙勪笂澧為�熸帓鍚�',
+
+    -- 瑙勪笅
+    below_scale_freight DOUBLE COMMENT '瑙勪笅璐ц繍閲�',
+    below_scale_turnover DOUBLE COMMENT '瑙勪笅鍛ㄨ浆閲�',
+    below_scale_rank INT COMMENT '瑙勪笅鎺掑悕',
+    below_scale_yoy DOUBLE COMMENT '瑙勪笅鍚屾瘮',
+    below_scale_yoy_rank INT COMMENT '瑙勪笅澧為�熸帓鍚�',
+
+    -- 鍚堣
+    total_freight DOUBLE COMMENT '杩愯緭閲忓悎璁�-璐ц繍閲�',
+    total_turnover DOUBLE COMMENT '杩愯緭閲忓悎璁�-鍛ㄨ浆閲�',
+    total_rank INT COMMENT '鍚堣鎺掑悕',
+    total_yoy DOUBLE COMMENT '鍚堣鍚屾瘮',
+    total_yoy_rank INT COMMENT '鍚堣澧為�熸帓鍚�',
+
+    import_batch_id BIGINT COMMENT '瀵煎叆鎵规',
+    created_at DATETIME DEFAULT CURRENT_TIMESTAMP
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='瑙勪笂瑙勪笅鎷嗗垎杩愯緭閲�';
+
+-- 妯℃澘_璐ц繍閲忓懆杞噺锛堟瘡鏈堝鍏ワ細宸﹀崐浠婂勾1-N鏈堬紝鍙冲崐鍘诲勾1-12鏈堬紝N=鎶ヨ〃鏈熸湀浠斤級
+DROP TABLE IF EXISTS freight_turnover_import;
+CREATE TABLE freight_turnover_import (
+    id BIGINT AUTO_INCREMENT PRIMARY KEY,
+    report_period VARCHAR(20) NOT NULL COMMENT '鎶ヨ〃鏈� 2026-06',
+    region_name VARCHAR(50) NOT NULL COMMENT '甯傚窞鎴栨箹鍖楃渷',
+
+    -- 浠婂勾1-12鏈堣揣杩愰噺锛堝乏鍗婏紝浠�1-N鏈堟湁鍊硷級
+    freight_m01 DOUBLE COMMENT '1鏈堣揣杩愰噺(涓囧惃)',
+    freight_m02 DOUBLE COMMENT '2鏈堣揣杩愰噺(涓囧惃)',
+    freight_m03 DOUBLE COMMENT '3鏈堣揣杩愰噺(涓囧惃)',
+    freight_m04 DOUBLE COMMENT '4鏈堣揣杩愰噺(涓囧惃)',
+    freight_m05 DOUBLE COMMENT '5鏈堣揣杩愰噺(涓囧惃)',
+    freight_m06 DOUBLE COMMENT '6鏈堣揣杩愰噺(涓囧惃)',
+    freight_m07 DOUBLE COMMENT '7鏈堣揣杩愰噺(涓囧惃)',
+    freight_m08 DOUBLE COMMENT '8鏈堣揣杩愰噺(涓囧惃)',
+    freight_m09 DOUBLE COMMENT '9鏈堣揣杩愰噺(涓囧惃)',
+    freight_m10 DOUBLE COMMENT '10鏈堣揣杩愰噺(涓囧惃)',
+    freight_m11 DOUBLE COMMENT '11鏈堣揣杩愰噺(涓囧惃)',
+    freight_m12 DOUBLE COMMENT '12鏈堣揣杩愰噺(涓囧惃)',
+
+    -- 鍘诲勾1-12鏈堣揣杩愰噺锛堝彸鍗婏紝鍥哄畾12涓湀锛岀畻鍚屾瘮鐢級
+    last_freight_m01 DOUBLE COMMENT '鍘诲勾1鏈堣揣杩愰噺(涓囧惃)',
+    last_freight_m02 DOUBLE COMMENT '鍘诲勾2鏈堣揣杩愰噺(涓囧惃)',
+    last_freight_m03 DOUBLE COMMENT '鍘诲勾3鏈堣揣杩愰噺(涓囧惃)',
+    last_freight_m04 DOUBLE COMMENT '鍘诲勾4鏈堣揣杩愰噺(涓囧惃)',
+    last_freight_m05 DOUBLE COMMENT '鍘诲勾5鏈堣揣杩愰噺(涓囧惃)',
+    last_freight_m06 DOUBLE COMMENT '鍘诲勾6鏈堣揣杩愰噺(涓囧惃)',
+    last_freight_m07 DOUBLE COMMENT '鍘诲勾7鏈堣揣杩愰噺(涓囧惃)',
+    last_freight_m08 DOUBLE COMMENT '鍘诲勾8鏈堣揣杩愰噺(涓囧惃)',
+    last_freight_m09 DOUBLE COMMENT '鍘诲勾9鏈堣揣杩愰噺(涓囧惃)',
+    last_freight_m10 DOUBLE COMMENT '鍘诲勾10鏈堣揣杩愰噺(涓囧惃)',
+    last_freight_m11 DOUBLE COMMENT '鍘诲勾11鏈堣揣杩愰噺(涓囧惃)',
+    last_freight_m12 DOUBLE COMMENT '鍘诲勾12鏈堣揣杩愰噺(涓囧惃)',
+
+    -- 浠婂勾1-12鏈堝懆杞噺锛堝乏鍗婏紝浠�1-N鏈堟湁鍊硷紝瀵煎叆瀛樻。锛屾姤琛ㄧ敤鎷嗗垎琛級
+    turnover_m01 DOUBLE COMMENT '1鏈堝懆杞噺(涓囧惃鍏噷)',
+    turnover_m02 DOUBLE COMMENT '2鏈堝懆杞噺(涓囧惃鍏噷)',
+    turnover_m03 DOUBLE COMMENT '3鏈堝懆杞噺(涓囧惃鍏噷)',
+    turnover_m04 DOUBLE COMMENT '4鏈堝懆杞噺(涓囧惃鍏噷)',
+    turnover_m05 DOUBLE COMMENT '5鏈堝懆杞噺(涓囧惃鍏噷)',
+    turnover_m06 DOUBLE COMMENT '6鏈堝懆杞噺(涓囧惃鍏噷)',
+    turnover_m07 DOUBLE COMMENT '7鏈堝懆杞噺(涓囧惃鍏噷)',
+    turnover_m08 DOUBLE COMMENT '8鏈堝懆杞噺(涓囧惃鍏噷)',
+    turnover_m09 DOUBLE COMMENT '9鏈堝懆杞噺(涓囧惃鍏噷)',
+    turnover_m10 DOUBLE COMMENT '10鏈堝懆杞噺(涓囧惃鍏噷)',
+    turnover_m11 DOUBLE COMMENT '11鏈堝懆杞噺(涓囧惃鍏噷)',
+    turnover_m12 DOUBLE COMMENT '12鏈堝懆杞噺(涓囧惃鍏噷)',
+
+    -- 鍘诲勾1-12鏈堝懆杞噺锛堝彸鍗婏紝鍥哄畾12涓湀锛�
+    last_turnover_m01 DOUBLE COMMENT '鍘诲勾1鏈堝懆杞噺(涓囧惃鍏噷)',
+    last_turnover_m02 DOUBLE COMMENT '鍘诲勾2鏈堝懆杞噺(涓囧惃鍏噷)',
+    last_turnover_m03 DOUBLE COMMENT '鍘诲勾3鏈堝懆杞噺(涓囧惃鍏噷)',
+    last_turnover_m04 DOUBLE COMMENT '鍘诲勾4鏈堝懆杞噺(涓囧惃鍏噷)',
+    last_turnover_m05 DOUBLE COMMENT '鍘诲勾5鏈堝懆杞噺(涓囧惃鍏噷)',
+    last_turnover_m06 DOUBLE COMMENT '鍘诲勾6鏈堝懆杞噺(涓囧惃鍏噷)',
+    last_turnover_m07 DOUBLE COMMENT '鍘诲勾7鏈堝懆杞噺(涓囧惃鍏噷)',
+    last_turnover_m08 DOUBLE COMMENT '鍘诲勾8鏈堝懆杞噺(涓囧惃鍏噷)',
+    last_turnover_m09 DOUBLE COMMENT '鍘诲勾9鏈堝懆杞噺(涓囧惃鍏噷)',
+    last_turnover_m10 DOUBLE COMMENT '鍘诲勾10鏈堝懆杞噺(涓囧惃鍏噷)',
+    last_turnover_m11 DOUBLE COMMENT '鍘诲勾11鏈堝懆杞噺(涓囧惃鍏噷)',
+    last_turnover_m12 DOUBLE COMMENT '鍘诲勾12鏈堝懆杞噺(涓囧惃鍏噷)',
+
+    import_batch_id BIGINT COMMENT '瀵煎叆鎵规',
+    created_at DATETIME DEFAULT CURRENT_TIMESTAMP
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='妯℃澘_璐ц繍閲忓懆杞噺瀵煎叆';
+
+-- ============================================
+-- 涓夈�佸鏍歌鍒欐ā鍧�
+-- ============================================
+
+DROP TABLE IF EXISTS audit_rule;
+CREATE TABLE audit_rule (
+    id BIGINT AUTO_INCREMENT PRIMARY KEY,
+    rule_name VARCHAR(100) NOT NULL COMMENT '瑙勫垯鍚嶇О',
+    rule_code VARCHAR(50) NOT NULL COMMENT '瑙勫垯缂栫爜',
+    description TEXT COMMENT '瑙勫垯鎻忚堪',
+    check_field VARCHAR(200) COMMENT '妫�鏌ュ瓧娈�',
+    compare_type VARCHAR(20) COMMENT 'DIFF/RATIO/MOM/YOY/NULL_CHECK/RANGE',
+    threshold VARCHAR(50) COMMENT '闃堝��',
+    alert_level VARCHAR(10) DEFAULT 'YELLOW' COMMENT 'RED/YELLOW',
+    report_type VARCHAR(50) DEFAULT 'H2032' COMMENT '閫傜敤鎶ヨ〃琛ㄥ彿',
+    is_enabled TINYINT DEFAULT 1,
+    llm_raw_input TEXT COMMENT 'LLM缈昏瘧鍘熷杈撳叆',
+    sort_order INT DEFAULT 0,
+    created_by BIGINT,
+    created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
+    updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
+
+-- 棰勭疆6鏉″鏍歌鍒欙紙Demo锛�
+INSERT INTO audit_rule (rule_name, rule_code, description, check_field, compare_type, threshold, alert_level, report_type, is_enabled, sort_order) VALUES
+('杞﹁締鏁拌繍鏀垮姣�', 'RULE_001', '浼佷笟涓婃姤杞﹁締鏁颁笌杩愭斂鏁版嵁瀵规瘮锛屽樊璺�>5鍙伴渶鏍稿疄', 'vehicleTotal', 'DIFF', '5', 'RED', 'H2032', 1, 1),
+('鍚ㄤ綅杩愭斂瀵规瘮', 'RULE_002', '浼佷笟涓婃姤鍚ㄤ綅涓庤繍鏀挎暟鎹姣旓紝宸窛>50闇�鏍稿疄', 'tonsTotal', 'DIFF', '50', 'RED', 'H2032', 1, 2),
+('鍛ㄨ浆閲忚建杩瑰姣�', 'RULE_003', '涓婃姤鍛ㄨ浆閲忎笌杞ㄨ抗娴嬬畻鍛ㄨ浆閲忓姣旓紝楂樺嚭30%闇�鏍稿疄', 'turnoverTotal,trackMileage', 'RATIO', '1.3', 'RED', 'H2032', 1, 3),
+('璐ц繍绫诲瀷鐜瘮', 'RULE_004', '涓婃湀鏃狅紝鏈湀鏂板锛屾彁閱掞紱涓婃湀鏈夛紝鏈湀鏃狅紝鎻愰啋锛堣揣杩愮被鍨嬬幆姣旓級', 'freightContainer,freightCoal,freightOilGas,freightCrudeOil,freightMetalOre,freightIronOre,freightBuilding,freightGrain', 'MOM', '0', 'YELLOW', 'H2032', 1, 4),
+('闆嗚绠卞紓甯�', 'RULE_005', '鏃犻泦瑁呯杞︿絾鏈夐泦瑁呯璐ц繍閲忛渶鏍稿疄', 'freightContainer,vehicleContainer', 'NULL_CHECK', '0', 'RED', 'H2032', 1, 5),
+('鏁磋溅鍚ㄤ綅鑼冨洿', 'RULE_006', '鏁磋溅鍚ㄤ綅涓嶅湪4-40鍚ㄤ箣闂�', 'tonsWhole', 'OUT_RANGE', '4,40', 'YELLOW', 'H2032', 1, 6);
+
+-- ============================================
+-- 鍥涖�佸鏍哥粨鏋滄ā鍧�
+-- ============================================
+
+DROP TABLE IF EXISTS audit_result;
+CREATE TABLE audit_result (
+    id BIGINT AUTO_INCREMENT PRIMARY KEY,
+    rule_id BIGINT NOT NULL COMMENT 'FK -> audit_rule',
+    report_id BIGINT NOT NULL COMMENT 'FK -> h2032_enterprise_monthly',
+    enterprise_code VARCHAR(50) COMMENT '浼佷笟浠ｇ爜',
+    report_period VARCHAR(20) COMMENT '鎶ヨ〃鏈�',
+    actual_value VARCHAR(200) COMMENT '瀹為檯鍊�',
+    threshold_value VARCHAR(200) COMMENT '闃堝��',
+    deviation VARCHAR(200) COMMENT '鍋忓樊',
+    status VARCHAR(20) DEFAULT 'PENDING' COMMENT 'PENDING/CONFIRMED/IGNORED',
+    reviewer_id BIGINT COMMENT '瀹℃牳浜�',
+    review_comment TEXT COMMENT '瀹℃牳鎰忚',
+    reviewed_at DATETIME,
+    created_at DATETIME DEFAULT CURRENT_TIMESTAMP
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
+
+DROP TABLE IF EXISTS audit_explanation;
+CREATE TABLE audit_explanation (
+    id BIGINT AUTO_INCREMENT PRIMARY KEY,
+    audit_result_id BIGINT NOT NULL COMMENT 'FK -> audit_result',
+    explanation_text TEXT COMMENT '涓婃姤浜鸿В閲�',
+    llm_suggestion TEXT COMMENT 'LLM寤鸿',
+    llm_confidence DECIMAL(5,2) COMMENT '缃俊搴�',
+    llm_status VARCHAR(20) DEFAULT 'PENDING' COMMENT 'PENDING/PROCESSED/FAILED'
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
+
+-- ============================================
+-- 浜斻�佺郴缁熸棩蹇椾笌瀵煎叆鎵规
+-- ============================================
+
+DROP TABLE IF EXISTS sys_operation_log;
+CREATE TABLE sys_operation_log (
+    id BIGINT AUTO_INCREMENT PRIMARY KEY,
+    user_id BIGINT COMMENT '鎿嶄綔浜�',
+    module VARCHAR(50) COMMENT '妯″潡',
+    action VARCHAR(50) COMMENT '鎿嶄綔',
+    detail TEXT COMMENT '璇︽儏JSON',
+    ip_address VARCHAR(50) COMMENT 'IP鍦板潃',
+    created_at DATETIME DEFAULT CURRENT_TIMESTAMP
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
+
+DROP TABLE IF EXISTS import_batch;
+CREATE TABLE import_batch (
+    id BIGINT AUTO_INCREMENT PRIMARY KEY,
+    file_name VARCHAR(200) COMMENT '鏂囦欢鍚�',
+    import_type VARCHAR(50) COMMENT 'H2032/TRANSPORT_AUTH/TRACK_MILEAGE/SCALE_SPLIT',
+    report_period VARCHAR(20) COMMENT '鎶ヨ〃鏈�',
+    total_rows INT DEFAULT 0,
+    success_rows INT DEFAULT 0,
+    fail_rows INT DEFAULT 0,
+    error_detail TEXT COMMENT '閿欒璇︽儏',
+    created_by BIGINT COMMENT '瀵煎叆浜�',
+    created_at DATETIME DEFAULT CURRENT_TIMESTAMP
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
+
+-- ============================================
+-- 鍏�丩LM鑴辨晱鏄犲皠
+-- ============================================
+
+DROP TABLE IF EXISTS llm_desensitize_map;
+CREATE TABLE llm_desensitize_map (
+    id BIGINT AUTO_INCREMENT PRIMARY KEY,
+    original_value VARCHAR(200) COMMENT '鍘熷鍊�',
+    masked_value VARCHAR(200) COMMENT '鑴辨晱鍊�',
+    mask_type VARCHAR(20) COMMENT 'ENTERPRISE/REGION',
+    call_id VARCHAR(50) COMMENT '璋冪敤ID'
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
+
+-- ============================================
+-- 涓冦�侀缃暟鎹�
+-- ============================================
+
+-- 棰勭疆閮ㄩ棬锛堟箹鍖楃渷锛�
+INSERT INTO sys_dept (dept_name, dept_code, dept_level) VALUES ('婀栧寳鐪佷氦閫氳繍杈撳巺', '420000', 1);
+
+-- 棰勭疆瑙掕壊
+INSERT INTO sys_role (role_name, role_code, role_type, role_level, is_mutex) VALUES
+('绯荤粺绠＄悊鍛�', 'SYS_ADMIN', 'SYSTEM', 0, 1),
+('瀹夊叏淇濆瘑鍛�', 'SEC_OFFICER', 'SYSTEM', 0, 1),
+('瀹夊叏瀹¤鍛�', 'AUDITOR', 'SYSTEM', 0, 1),
+('鐪佸巺涓氬姟鍛�', 'PROVINCE', 'BUSINESS', 1, 0);
+
+-- 棰勭疆绠＄悊鍛樿处鍙� admin / admin123
+INSERT INTO sys_user (username, password, real_name, dept_id) VALUES
+('admin', '$2b$10$aqN02Pwvzzuta/66V9MpGerfUH6favtq8av3cc/gueg6lQ9E4CH8u', '绯荤粺绠＄悊鍛�', 1);
+
+INSERT INTO sys_user_role (user_id, role_id) VALUES (1, 1);
+
+
+-- ============================================
+-- 鍏�佸叕璺梾瀹㈣繍杈擄紙浜や紒缁烪203-1锛夋墿灞曟ā鍧�
+-- ============================================
+
+DROP TABLE IF EXISTS h2031_enterprise_monthly;
+CREATE TABLE h2031_enterprise_monthly (
+    id BIGINT AUTO_INCREMENT PRIMARY KEY,
+    report_period VARCHAR(20) NOT NULL COMMENT '鎶ヨ〃鏈� 2026-06',
+    region_code VARCHAR(20) COMMENT '鎵�灞炲湴鍖�',
+    enterprise_code VARCHAR(50) COMMENT '浼佷笟浠ｇ爜',
+    enterprise_name VARCHAR(200) COMMENT '浼佷笟鍚嶇О',
+    vehicle_total INT COMMENT '瀹㈣繍杞﹁締_鎬昏',
+    seat_total INT COMMENT '鏍稿畾杞藉浣峗鎬昏',
+    vehicle_schedule INT COMMENT '杞﹁締鏁癬瀹㈣繍鐝溅锛堝惈瀹氱嚎鏃呮父瀹㈣繍瀹㈣溅锛�',
+    seat_schedule INT COMMENT '鏍稿畾杞藉浣峗瀹㈣繍鐝溅锛堝惈瀹氱嚎鏃呮父瀹㈣繍瀹㈣溅锛�',
+    vehicle_charter INT COMMENT '杞﹁締鏁癬瀹㈣繍鍖呰溅锛堝惈闈炲畾绾挎梾娓稿杩愬杞︼級',
+    seat_charter INT COMMENT '鏍稿畾杞藉浣峗瀹㈣繍鍖呰溅锛堝惈闈炲畾绾挎梾娓稿杩愬杞︼級',
+    passenger_total DOUBLE COMMENT '瀹㈣繍閲廮鎬昏锛堜汉锛�',
+    turnover_total DOUBLE COMMENT '鏃呭鍛ㄨ浆閲廮鎬昏锛堜汉鍏噷锛�',
+    passenger_class1 DOUBLE COMMENT '瀹㈣繍閲廮涓�绫诲杩愮彮绾匡紙鍚畾绾挎梾娓革級',
+    turnover_class1 DOUBLE COMMENT '鏃呭鍛ㄨ浆閲廮涓�绫诲杩愮彮绾匡紙鍚畾绾挎梾娓革級',
+    passenger_class2 DOUBLE COMMENT '瀹㈣繍閲廮浜岀被瀹㈣繍鐝嚎锛堝惈瀹氱嚎鏃呮父锛�',
+    turnover_class2 DOUBLE COMMENT '鏃呭鍛ㄨ浆閲廮浜岀被瀹㈣繍鐝嚎锛堝惈瀹氱嚎鏃呮父锛�',
+    passenger_class3 DOUBLE COMMENT '瀹㈣繍閲廮涓夌被瀹㈣繍鐝嚎锛堝惈瀹氱嚎鏃呮父锛�',
+    turnover_class3 DOUBLE COMMENT '鏃呭鍛ㄨ浆閲廮涓夌被瀹㈣繍鐝嚎锛堝惈瀹氱嚎鏃呮父锛�',
+    passenger_class4 DOUBLE COMMENT '瀹㈣繍閲廮鍥涚被瀹㈣繍鐝嚎锛堝惈瀹氱嚎鏃呮父锛�',
+    turnover_class4 DOUBLE COMMENT '鏃呭鍛ㄨ浆閲廮鍥涚被瀹㈣繍鐝嚎锛堝惈瀹氱嚎鏃呮父锛�',
+    passenger_charter DOUBLE COMMENT '瀹㈣繍閲廮瀹㈣繍鍖呰溅锛堝惈闈炲畾绾挎梾娓革級',
+    turnover_charter DOUBLE COMMENT '鏃呭鍛ㄨ浆閲廮瀹㈣繍鍖呰溅锛堝惈闈炲畾绾挎梾娓革級',
+    avg_distance_total DOUBLE COMMENT '瀹㈣繍骞冲潎杩愯窛锛堝叕閲岋級',
+    avg_distance_class1 DOUBLE COMMENT '涓�绫诲杩愮彮绾垮钩鍧囪繍璺濓紙鍏噷锛�',
+    avg_distance_class2 DOUBLE COMMENT '浜岀被瀹㈣繍鐝嚎骞冲潎杩愯窛锛堝叕閲岋級',
+    avg_distance_class3 DOUBLE COMMENT '涓夌被瀹㈣繍鐝嚎骞冲潎杩愯窛锛堝叕閲岋級',
+    avg_distance_class4 DOUBLE COMMENT '鍥涚被瀹㈣繍鐝嚎骞冲潎杩愯窛锛堝叕閲岋級',
+    avg_distance_charter DOUBLE COMMENT '鏃呮父銆佸寘杞﹀钩鍧囪繍璺濓紙鍏噷锛�',
+    verify_explanation TEXT COMMENT '鏍稿疄鎬у師鍥犺В閲�',
+    import_batch_id BIGINT COMMENT '瀵煎叆鎵规',
+    created_at DATETIME DEFAULT CURRENT_TIMESTAMP
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='浜や紒缁烪203-1琛╛鍏矾鏃呭杩愯緭鏈堝害鐢熶骇鎯呭喌';
+
+DROP TABLE IF EXISTS passenger_auth_vehicle;
+CREATE TABLE passenger_auth_vehicle (
+    id BIGINT AUTO_INCREMENT PRIMARY KEY,
+    report_period VARCHAR(20) COMMENT '鎶ヨ〃鏈�',
+    enterprise_code VARCHAR(50) COMMENT '浼佷笟浠ｇ爜',
+    enterprise_name VARCHAR(200) COMMENT '浼佷笟鍚嶇О',
+    vehicle_count INT DEFAULT 0 COMMENT '杞﹁締鏁�',
+    seat_count INT DEFAULT 0 COMMENT '杞藉浣嶆暟',
+    import_batch_id BIGINT COMMENT '瀵煎叆鎵规',
+    created_at DATETIME DEFAULT CURRENT_TIMESTAMP
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='鍏矾鏃呭杩愭斂杞﹁締鏁版嵁';
+
+-- H203-1 棰勭疆瀹℃牳瑙勫垯锛�4缁�8鏉★紝report_type=H2031锛�
+INSERT INTO audit_rule (rule_name, rule_code, description, check_field, compare_type, threshold, alert_level, report_type, is_enabled, sort_order) VALUES
+('杞﹁締鏁拌繍鏀垮姣�(鏃呭)', 'RULE_P001', '瀹㈣繍杞﹁締鏁颁笌杩愭斂杞﹁締鏁板姣旓紝宸窛>3鍙伴渶鏍稿疄', 'vehicleTotal', 'DIFF', '3', 'RED', 'H2031', 1, 21),
+('杞藉浣嶆暟杩愭斂瀵规瘮(鏃呭)', 'RULE_P002', '鏍稿畾杞藉浣嶆暟涓庤繍鏀胯浇瀹綅鏁板姣旓紝宸窛>50闇�鏍稿疄', 'seatTotal', 'DIFF', '50', 'RED', 'H2031', 1, 22),
+('瀹㈣繍閲忕幆姣�=0鏍稿疄', 'RULE_P003', '涓�绫�/浜岀被/涓夌被/鍥涚被/鍖呰溅瀹㈣繍閲忕幆姣斾笂涓湀绛変簬0闇�鏍稿疄', 'passengerClass1,passengerClass2,passengerClass3,passengerClass4,passengerCharter', 'MOM_EQ_ZERO', '0', 'YELLOW', 'H2031', 1, 23),
+('鏃呭鍛ㄨ浆閲忕幆姣�=0鏍稿疄', 'RULE_P004', '涓�绫�/浜岀被/涓夌被/鍥涚被/鍖呰溅鏃呭鍛ㄨ浆閲忕幆姣斾笂涓湀绛変簬0闇�鏍稿疄', 'turnoverClass1,turnoverClass2,turnoverClass3,turnoverClass4,turnoverCharter', 'MOM_EQ_ZERO', '0', 'YELLOW', 'H2031', 1, 24),
+('骞冲潎杩愯窛鐜瘮瓒吢�20%鏍稿疄', 'RULE_P005', '涓�绫�/浜岀被/涓夌被/鍥涚被骞冲潎杩愯窛鐜瘮涓婁釜鏈堣秴杩嚶�20%闇�鏍稿疄', 'avgDistanceClass1,avgDistanceClass2,avgDistanceClass3,avgDistanceClass4', 'MOM_PCT', '20', 'YELLOW', 'H2031', 1, 25),
+('鍖呰溅骞冲潎杩愯窛绛変簬涓婃湀鏍稿疄', 'RULE_P006', '鏃呮父鍖呰溅骞冲潎杩愯窛绛変簬涓婁釜鏈堥渶鏍稿疄', 'avgDistanceCharter', 'MOM_EQ', '0', 'YELLOW', 'H2031', 1, 26),
+('鏃犵彮绾挎湁鐝嚎瀹㈣繍閲忔牳瀹�', 'RULE_P007', '鏃犲杩愮彮杞︼紙鐝嚎杞﹁締鏁颁负0锛変絾鏈夌彮绾垮杩愰噺闇�鏍稿疄', 'vehicleSchedule,passengerClass1,passengerClass2,passengerClass3,passengerClass4', 'EXISTENCE', '0', 'RED', 'H2031', 1, 27),
+('鏃犲寘杞︽湁鍖呰溅瀹㈣繍閲忔牳瀹�', 'RULE_P008', '鏃犲杩愬寘杞︼紙鍖呰溅杞﹁締鏁颁负0锛変絾鏈夊寘杞﹀杩愰噺闇�鏍稿疄', 'vehicleCharter,passengerCharter', 'EXISTENCE', '0', 'RED', 'H2031', 1, 28);
+
+
+-- ============================================
+-- 涔濄�侀亾璺揣杩愯兘婧愭秷鑰楋紙浜や紒缁烪204锛夋墿灞曟ā鍧�
+-- ============================================
+
+-- 閬撹矾璐ц繍杞﹁締鑳芥簮娑堣�楁儏鍐碉紙杞﹁締绮掑害瀛ｆ姤锛�
+DROP TABLE IF EXISTS h204_vehicle_quarterly;
+CREATE TABLE h204_vehicle_quarterly (
+    id BIGINT AUTO_INCREMENT PRIMARY KEY,
+    report_period VARCHAR(20) NOT NULL COMMENT '鎶ヨ〃鏈� 2026-06锛堝搴︽湯鏈堬級',
+    region_code VARCHAR(20) COMMENT '鎵�灞炲湴鍖�',
+    enterprise_code VARCHAR(50) COMMENT '浼佷笟浠ｇ爜',
+    enterprise_name VARCHAR(200) COMMENT '浼佷笟鍚嶇О',
+    plate_no VARCHAR(30) COMMENT '杞︾墝鍙�',
+    vehicle_type_code VARCHAR(10) COMMENT '杞﹁締绫诲瀷浠ｇ爜',
+    vehicle_type VARCHAR(50) COMMENT '杞﹁締绫诲瀷锛堜腑鏂囷級',
+    fuel_type_code VARCHAR(10) COMMENT '鐕冩枡绫诲瀷浠ｇ爜',
+    fuel_type VARCHAR(50) COMMENT '鐕冩枡绫诲瀷锛堜腑鏂囷級',
+    manufacture_year INT COMMENT '鍑哄巶骞翠唤',
+    marked_tonnage DOUBLE COMMENT '鏍囪鍚ㄤ綅锛堝惃锛�',
+    total_mileage DOUBLE COMMENT '鎬昏绋嬶紙鍏噷锛�',
+    loaded_mileage DOUBLE COMMENT '杞借揣閲岀▼锛堝叕閲岋級',
+    empty_mileage DOUBLE COMMENT '绌洪┒閲岀▼锛堝叕閲岋級',
+    freight DOUBLE COMMENT '璐ц繍閲忥紙鍚級',
+    turnover DOUBLE COMMENT '璐х墿鍛ㄨ浆閲忥紙鍚ㄥ叕閲岋級',
+    trip_count INT COMMENT '瓒熸鏁帮紙涓級',
+    fuel_unit VARCHAR(20) COMMENT '鐕冩枡1璁￠噺鍗曚綅',
+    fuel_consumption DOUBLE COMMENT '鐕冩枡1娑堣�楅噺',
+    avg_distance DOUBLE COMMENT '骞冲潎杩愯窛锛堝叕閲岋級',
+    avg_loaded_tonnage DOUBLE COMMENT '骞冲潎杞借揣鍚ㄤ綅锛堝惃锛�',
+    avg_trip_mileage DOUBLE COMMENT '鍗曡稛骞冲潎閲岀▼锛堝叕閲岋級',
+    fuel_per_100km DOUBLE COMMENT '鐧惧叕閲屽崟鑰�',
+    turnover_fuel DOUBLE COMMENT '鍛ㄨ浆閲忓崟鑰�',
+    import_batch_id BIGINT COMMENT '瀵煎叆鎵规',
+    created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
+    KEY idx_period_plate (report_period, plate_no),
+    KEY idx_period_ent (report_period, enterprise_code)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='浜や紒缁烪204琛╛閬撹矾璐ц繍杞﹁締鑳芥簮娑堣�楁儏鍐碉紙杞﹁締绮掑害锛�';
+
+-- 閬撹矾璐ц繍鑳借�梍杩愭斂杞﹁締淇℃伅锛堣溅鐗岀矑搴︼級
+DROP TABLE IF EXISTS h204_auth_vehicle;
+CREATE TABLE h204_auth_vehicle (
+    id BIGINT AUTO_INCREMENT PRIMARY KEY,
+    report_period VARCHAR(20) NOT NULL COMMENT '鎶ヨ〃鏈�',
+    plate_no VARCHAR(30) NOT NULL COMMENT '杞︾墝鍙�',
+    vehicle_type VARCHAR(50) COMMENT '杞﹁締绫诲瀷',
+    fuel_type VARCHAR(50) COMMENT '鐕冩枡绫诲瀷',
+    marked_tonnage DOUBLE COMMENT '鏍囪鍚ㄤ綅锛堝惃锛�',
+    traction_quality DOUBLE COMMENT '鍑嗙壍寮曡川閲忥紙鐗靛紩杞︽爣璁板惃浣嶏級',
+    import_batch_id BIGINT COMMENT '瀵煎叆鎵规',
+    created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
+    KEY idx_period_plate (report_period, plate_no)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='閬撹矾璐ц繍鑳借�梍杩愭斂杞﹁締淇℃伅锛堣溅鐗岀矑搴︼級';
+
+-- H204 棰勭疆瀹℃牳瑙勫垯锛�4鏉★紝report_type=H204锛�
+INSERT INTO audit_rule (rule_name, rule_code, description, check_field, compare_type, threshold, alert_level, report_type, is_enabled, sort_order) VALUES
+('杞﹁締绫诲瀷涓庤繍鏀垮姣�', 'RULE_E001', '鑳借�楁槑缁嗚溅杈嗙被鍨嬩笌杩愭斂杞﹁締淇℃伅涓嶄竴鑷撮渶鏍稿疄', 'vehicleType', 'CROSS_DIFF', '0', 'RED', 'H204', 1, 31),
+('鐕冩枡绫诲瀷涓庤繍鏀垮姣�', 'RULE_E002', '鑳借�楁槑缁嗙噧鏂欑被鍨嬩笌杩愭斂杞﹁締淇℃伅涓嶄竴鑷撮渶鏍稿疄', 'fuelType', 'CROSS_DIFF', '0', 'RED', 'H204', 1, 32),
+('鏍囪鍚ㄤ綅涓庤繍鏀垮姣�', 'RULE_E003', '鑳借�楁槑缁嗘爣璁板惃浣嶄笌杩愭斂瀵规瘮锛屽樊璺�>0.05鍚ㄩ渶鏍稿疄锛堢壍寮曡溅瀵规瘮鍑嗙壍寮曡川閲忥級', 'markedTonnage', 'CROSS_DIFF', '0.05', 'YELLOW', 'H204', 1, 33),
+('杩愭斂杞﹁締淇℃伅缂哄け', 'RULE_E004', '鑳借�楁槑缁嗚溅鐗屽彿鍦ㄨ繍鏀胯溅杈嗕俊鎭腑涓嶅瓨鍦ㄩ渶鏍稿疄', 'plateNo', 'EXISTENCE_AUTH', '0', 'RED', 'H204', 1, 34),
+('杞借揣閲岀▼鍗犳瘮涓庡崟瓒熼噷绋嬫瘮鏍稿疄', 'RULE_E005', '杞借揣閲岀▼/鎬昏绋� 涓� 骞冲潎杩愯窛/鍗曡稛骞冲潎閲岀▼ 鐩稿樊卤10%闇�鏍稿疄', 'loadedMileage,totalMileage,avgDistance,avgTripMileage', 'LOADED_RATIO_DIFF', '0.1', 'YELLOW', 'H204', 1, 35),
+('鐧惧叕閲屽崟鑰楄秴鑼冨洿鏍稿疄', 'RULE_E006', '鐧惧叕閲屽崟鑰楀亸绂诲悓鐕冩枡绫诲瀷涓綅鏁拌秴杩�50%闇�鏍稿疄', 'fuelPer100km,fuelTypeCode', 'FUEL_RANGE', '0.5', 'YELLOW', 'H204', 1, 36),
+('鐧惧叕閲屽崟鑰楃幆姣斿彉鍖栨牳瀹�', 'RULE_E007', '鍚屼竴杈嗚溅鐧惧叕閲屽崟鑰楃幆姣斿彉鍖栬秴杩嚶�50%闇�鏍稿疄', 'fuelPer100km,plateNo', 'FUEL_MOM', '0.5', 'YELLOW', 'H204', 1, 37),
+('鑳借�楅噺涓庤揣杩愭湀鎶ュ姣旀牳瀹�', 'RULE_E008', '浼佷笟鑳借�楄揣杩愰噺/鍛ㄨ浆閲忎箣鍜屽ぇ浜庤揣杩愭湀鎶�50%闇�鏍稿疄', 'freight,turnover,enterpriseName', 'FREIGHT_VS_H2032', '0.5', 'RED', 'H204', 1, 38),
+('骞冲潎杩愯窛涓庤揣杩愭湀鎶ュ姣旀牳瀹�', 'RULE_E009', '杞﹁締骞冲潎杩愯窛涓庤揣杩愭湀鎶ュ钩鍧囪繍璺濈浉宸�60%闇�鏍稿疄', 'avgDistance,enterpriseName', 'AVG_DIST_VS_H2032', '0.6', 'YELLOW', 'H204', 1, 39),
+('骞冲潎杞借揣鍚ㄤ綅涓庢爣璁板惃浣嶆瘮鍊兼牳瀹�', 'RULE_E010', '骞冲潎杞借揣鍚ㄤ綅/鏍囪鍚ㄤ綅 灏忎簬0.5鎴栧ぇ浜�1闇�鏍稿疄', 'avgLoadedTonnage,markedTonnage', 'LOADED_TON_RATIO', '0.5,1', 'YELLOW', 'H204', 1, 40);
+
+-- ============================================
+-- 鍗併�佹姇璧勬ā鍧楋紙瀹㈣繍绔欏満/鐗╂祦鍥尯锛夋墿灞�
+-- ============================================
+
+-- 鎶曡祫椤圭洰涓绘。锛堟寜 椤圭洰鍚�+绫诲埆 鍞竴锛�
+DROP TABLE IF EXISTS investment_project;
+CREATE TABLE investment_project (
+    id BIGINT AUTO_INCREMENT PRIMARY KEY,
+    project_name VARCHAR(200) NOT NULL COMMENT '椤圭洰鍚嶇О',
+    category VARCHAR(20) NOT NULL COMMENT '绫诲埆锛氬杩愮珯鍦�/鐗╂祦鍥尯',
+    city VARCHAR(50) COMMENT '甯傚窞',
+    county VARCHAR(100) COMMENT '鍘匡紙甯傘�佸尯锛�',
+    builder_name VARCHAR(200) COMMENT '鎶曡祫寤鸿鍗曚綅',
+    construct_nature VARCHAR(50) COMMENT '寤鸿鎬ц川',
+    start_time VARCHAR(20) COMMENT '寮�宸ユ椂闂�',
+    end_time VARCHAR(20) COMMENT '寤烘垚/绔ｅ伐鏃堕棿',
+    total_investment DOUBLE COMMENT '璁″垝鎬绘姇璧勶紙涓囧厓锛�',
+    approval_gk VARCHAR(500) COMMENT '宸ュ彲鎵瑰',
+    approval_cs VARCHAR(500) COMMENT '鍒濊鎵瑰',
+    building_area DOUBLE COMMENT '寤虹瓚闈㈢Н锛堝钩鏂圭背锛�',
+    is_billion TINYINT DEFAULT 0 COMMENT '浜垮厓鎶曡祫椤圭洰鏍囪',
+    is_county TINYINT DEFAULT 0 COMMENT '缁忔祹寮哄幙椤圭洰鏍囪',
+    is_five_year TINYINT DEFAULT 0 COMMENT '鍗佷簲浜旈噸鐐圭墿娴侀」鐩爣璁�',
+    source VARCHAR(50) COMMENT '鏁版嵁鏉ユ簮',
+    import_batch_id BIGINT COMMENT '瀵煎叆鎵规',
+    created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
+    updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
+    UNIQUE KEY uk_name_category (project_name, category)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='鎶曡祫椤圭洰涓绘。';
+
+-- 鎶曡祫椤圭洰鏈堝害瀹屾垚鎯呭喌
+DROP TABLE IF EXISTS investment_monthly;
+CREATE TABLE investment_monthly (
+    id BIGINT AUTO_INCREMENT PRIMARY KEY,
+    report_period VARCHAR(20) NOT NULL COMMENT '鎶ヨ〃鏈� 2026-07',
+    project_id BIGINT NOT NULL COMMENT '椤圭洰涓绘。ID',
+    year_plan DOUBLE COMMENT '鏈勾璁″垝鎶曡祫锛堜竾鍏冿級',
+    year_cum DOUBLE COMMENT '鑷勾鍒濈疮璁″畬鎴愭姇璧勶紙涓囧厓锛�',
+    month_done DOUBLE COMMENT '鍏朵腑锛氭湰鏈堝畬鎴愭姇璧勶紙涓囧厓锛�',
+    start_cum DOUBLE COMMENT '鑷紑濮嬪缓璁剧疮璁″畬鎴愭姇璧勶紙涓囧厓锛�',
+    progress_stage VARCHAR(100) COMMENT '寤鸿闃舵',
+    progress_desc VARCHAR(2000) COMMENT '褰㈣薄杩涘害',
+    building_area DOUBLE COMMENT '寤虹瓚闈㈢Н锛堝钩鏂圭背锛�',
+    created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
+    KEY idx_period (report_period),
+    KEY idx_project (project_id)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='鎶曡祫椤圭洰鏈堝害瀹屾垚鎯呭喌';
+
+-- 鎶曡祫绯荤粺鏌ヨ瀵煎嚭锛堝鏍告瘮瀵瑰熀鍑嗭級
+DROP TABLE IF EXISTS investment_system;
+CREATE TABLE investment_system (
+    id BIGINT AUTO_INCREMENT PRIMARY KEY,
+    report_period VARCHAR(20) NOT NULL COMMENT '鎶ヨ〃鏈� 2026-07',
+    project_name VARCHAR(200) NOT NULL COMMENT '椤圭洰鍚嶇О锛堝崟浣嶏級',
+    total_investment DOUBLE COMMENT '璁″垝鎬绘姇璧勶紙涓囧厓锛�',
+    start_cum DOUBLE COMMENT '鑷紑濮嬪缓璁捐嚦鏈湀绱瀹屾垚鎶曡祫锛堜竾鍏冿級',
+    year_plan DOUBLE COMMENT '鏈勾璁″垝鎶曡祫锛堜竾鍏冿級',
+    year_cum DOUBLE COMMENT '鑷勾鍒濈疮璁″畬鎴愭姇璧勶紙涓囧厓锛�',
+    month_done DOUBLE COMMENT '褰撴湀瀹屾垚鎶曡祫锛堜竾鍏冿級',
+    import_batch_id BIGINT COMMENT '瀵煎叆鎵规',
+    created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
+    KEY idx_period (report_period)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='鎶曡祫绯荤粺鏌ヨ瀵煎嚭锛堝鏍告瘮瀵瑰熀鍑嗭級';
+
+-- INVEST 棰勭疆瀹℃牳瑙勫垯锛�4鏉★紝report_type=INVEST锛�
+INSERT INTO audit_rule (rule_name, rule_code, description, check_field, compare_type, threshold, alert_level, report_type, is_enabled, sort_order) VALUES
+('鑷紑濮嬬疮璁′笌鎶曡祫绯荤粺瀵规瘮', 'RULE_I001', '鑷紑濮嬪缓璁剧疮璁″畬鎴愭姇璧勪笌鎶曡祫绯荤粺瀵煎嚭宸紓瓒呴槇鍊奸渶鏍稿疄', 'startCum', 'CROSS_DIFF', '100|5', 'YELLOW', 'INVEST', 1, 41),
+('鑷勾鍒濈疮璁′笌鎶曡祫绯荤粺瀵规瘮', 'RULE_I002', '鑷勾鍒濈疮璁″畬鎴愭姇璧勪笌鎶曡祫绯荤粺瀵煎嚭宸紓瓒呴槇鍊奸渶鏍稿疄', 'yearCum', 'CROSS_DIFF', '50|5', 'YELLOW', 'INVEST', 1, 42),
+('鏈湀瀹屾垚涓庢姇璧勭郴缁熷姣�', 'RULE_I003', '鏈湀瀹屾垚鎶曡祫涓庢姇璧勭郴缁熷鍑哄樊寮傝秴闃堝�奸渶鏍稿疄', 'monthDone', 'CROSS_DIFF', '30|30', 'YELLOW', 'INVEST', 1, 43),
+('鎶曡祫绯荤粺椤圭洰缂哄け鏍稿疄', 'RULE_I004', '姹囨�诲ぇ琛ㄩ」鐩湪鎶曡祫绯荤粺瀵煎嚭涓笉瀛樺湪闇�鏍稿疄', 'projectName', 'EXISTENCE_SYS', '0', 'YELLOW', 'INVEST', 1, 44);
+
+
+-- ============================================
+-- 涔濄�佸叕璺梾瀹釜浣撳杩愰噺/鍛ㄨ浆閲忥紙浼佷笟绾夸笅姹囨姤锛�
+-- ============================================
+DROP TABLE IF EXISTS passenger_individual_monthly;
+CREATE TABLE passenger_individual_monthly (
+  id BIGINT AUTO_INCREMENT PRIMARY KEY,
+  report_period VARCHAR(20) COMMENT '鎶ヨ〃鏈� 2026-07',
+  region_code VARCHAR(20) COMMENT '鎵�灞炲湴鍖猴紙琛屾斂鍖哄垝浠ｇ爜锛�',
+  enterprise_code VARCHAR(50) COMMENT '浼佷笟浠ｇ爜',
+  enterprise_name VARCHAR(200) COMMENT '浼佷笟鍚嶇О',
+  passenger_count DOUBLE COMMENT '鍏朵腑涓綋瀹㈣繍閲忥紙浜猴級',
+  turnover DOUBLE COMMENT '鍏朵腑涓綋鏃呭鍛ㄨ浆閲忥紙浜哄叕閲岋級',
+  created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
+  KEY idx_period (report_period)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='鍏矾鏃呭涓綋瀹㈣繍閲�/鍛ㄨ浆閲�';
+
+-- ============================================
+-- 鍗併�佹姤琛ㄦ湡瀹℃牳閫氳繃鏍囪锛坅udit_run锛�
+-- ============================================
+DROP TABLE IF EXISTS audit_run;
+CREATE TABLE audit_run (
+  id BIGINT AUTO_INCREMENT PRIMARY KEY,
+  report_type VARCHAR(50) COMMENT '鎶ヨ〃绫诲瀷',
+  report_period VARCHAR(20) COMMENT '鎶ヨ〃鏈�',
+  created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
+  KEY idx_type_period (report_type, report_period)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='鎶ヨ〃鏈熷鏍搁�氳繃鏍囪';

--
Gitblit v1.9.1