From 664cae654867b528ea339f187ebe290cb04d6fcf Mon Sep 17 00:00:00 2001
From: xyc <jc_xiong@hotmail.com>
Date: 星期四, 27 八月 2026 18:41:21 +0800
Subject: [PATCH] docs: 关机前交接——运行状态、待验证项、外置配置要点
---
docs/sql_city_bus.sql | 59 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 59 insertions(+), 0 deletions(-)
diff --git a/docs/sql_city_bus.sql b/docs/sql_city_bus.sql
new file mode 100644
index 0000000..97ba0c8
--- /dev/null
+++ b/docs/sql_city_bus.sql
@@ -0,0 +1,59 @@
+-- 鍩庡競瀹㈣繍绗�1姝ワ紙鍏氦锛夊缓琛� + 瀹℃牳瑙勫垯
+-- 鏁版嵁婧愶細瀵煎叆_鍩庡競鍏叡浜ら�氭湀搴﹁繍钀ユ儏鍐碉紙2026骞�7鏈堬級.xls锛堜紒涓氱骇鏄庣粏锛屽惈鍏叡姹界數杞�/杞ㄩ亾/杞浮涓夌被锛屾湰琛ㄥ彧鍙栧叕鍏辨苯鐢佃溅瀛楁锛�
+
+CREATE TABLE IF NOT EXISTS city_bus_monthly (
+ id BIGINT NOT NULL AUTO_INCREMENT,
+ report_period VARCHAR(20) NOT NULL COMMENT '鎶ヨ〃鏈� 2026-07',
+ region_code VARCHAR(20) DEFAULT NULL COMMENT '鎵�灞炲湴鍖轰唬鐮�',
+ city VARCHAR(50) DEFAULT NULL COMMENT '甯傚窞锛堢敱鍦板尯浠ｇ爜鏄犲皠锛�',
+ enterprise_code VARCHAR(50) DEFAULT NULL COMMENT '浼佷笟浠ｇ爜',
+ enterprise_name VARCHAR(200) DEFAULT NULL COMMENT '浼佷笟鍚嶇О',
+ op_vehicles DOUBLE DEFAULT NULL COMMENT '鍏叡姹界數杞﹁繍钀ヨ溅鏁�',
+ stop_total DOUBLE DEFAULT NULL COMMENT '杩愯惀绔欑偣鎬讳釜鏁�',
+ stop_city DOUBLE DEFAULT NULL COMMENT '鍏朵腑锛氬煄甯傚唴杩愯惀绔欑偣',
+ passenger_volume DOUBLE DEFAULT NULL COMMENT '鍏叡姹界數杞﹀杩愰噺锛堜竾浜烘锛�',
+ passenger_city DOUBLE DEFAULT NULL COMMENT '鍏朵腑锛氬煄甯傚唴瀹㈣繍閲忥紙涓囦汉娆★級',
+ turnover DOUBLE DEFAULT NULL COMMENT '鍏叡姹界數杞︽梾瀹㈠懆杞噺锛堜竾浜哄叕閲岋級',
+ turnover_city DOUBLE DEFAULT NULL COMMENT '鍏朵腑锛氬煄甯傚唴鏃呭鍛ㄨ浆閲忥紙涓囦汉鍏噷锛�',
+ avg_distance DOUBLE DEFAULT NULL COMMENT '鍏叡姹界數杞﹀钩鍧囪繍璺濓紙鍏噷锛�',
+ avg_distance_city DOUBLE DEFAULT NULL COMMENT '鍩庡競鍐呭钩鍧囪繍璺濓紙鍏噷锛�',
+ passenger_chengxiang DOUBLE DEFAULT NULL COMMENT '鍩庨檯鍩庝埂瀹㈣繍閲忥紙涓囦汉娆★級',
+ turnover_chengxiang DOUBLE DEFAULT NULL COMMENT '鍩庨檯鍩庝埂鏃呭鍛ㄨ浆閲忥紙涓囦汉鍏噷锛�',
+ avg_distance_chengxiang DOUBLE DEFAULT NULL COMMENT '鍩庨檯鍩庝埂骞冲潎杩愯窛锛堝叕閲岋級',
+ rate_op_vehicles_mom DOUBLE DEFAULT NULL COMMENT '杩愯惀杞︽暟鐜瘮澧為��',
+ rate_passenger_mom DOUBLE DEFAULT NULL COMMENT '瀹㈣繍閲忕幆姣斿閫�',
+ rate_passenger_city_mom DOUBLE DEFAULT NULL COMMENT '鍩庡競鍐呭杩愰噺鐜瘮',
+ rate_chengxiang_mom DOUBLE DEFAULT NULL COMMENT '鍩庨檯鍩庝埂瀹㈣繍閲忕幆姣斿閫�',
+ rate_chengxiang_turnover_mom DOUBLE DEFAULT NULL COMMENT '鍩庨檯鍩庝埂鏃呭鍛ㄨ浆閲忕幆姣斿閫�',
+ rate_turnover_mom DOUBLE DEFAULT NULL COMMENT '鏃呭鍛ㄨ浆閲忕幆姣斿閫�',
+ avg_distance_mom_change DOUBLE DEFAULT NULL COMMENT '骞冲潎杩愯窛鐜瘮澧炲噺锛堝叕閲岋級',
+ avg_distance_city_mom_change DOUBLE DEFAULT NULL COMMENT '鍩庡競鍐呭钩鍧囪繍璺濈幆姣斿鍑忥紙鍏噷锛�',
+ daily_passenger_per_vehicle DOUBLE DEFAULT NULL COMMENT '鍗曡溅鏃ュ潎瀹㈣繍閲�',
+ rate_op_vehicles_yoy DOUBLE DEFAULT NULL COMMENT '杩愯惀杞︽暟鍚屾瘮澧為��',
+ rate_passenger_yoy DOUBLE DEFAULT NULL COMMENT '瀹㈣繍閲忓悓姣斿閫�',
+ rate_passenger_city_yoy DOUBLE DEFAULT NULL COMMENT '鍩庡競鍐呭杩愰噺鍚屾瘮澧為��',
+ rate_chengxiang_yoy DOUBLE DEFAULT NULL COMMENT '鍩庨檯鍩庝埂瀹㈣繍閲忓悓姣斿閫�',
+ rate_chengxiang_turnover_yoy DOUBLE DEFAULT NULL COMMENT '鍩庨檯鍩庝埂鏃呭鍛ㄨ浆閲忓悓姣斿閫�',
+ rate_turnover_yoy DOUBLE DEFAULT NULL COMMENT '鏃呭鍛ㄨ浆閲忓悓姣斿閫�',
+ stop_city_ratio DOUBLE DEFAULT NULL COMMENT '鍩庡競鍐呰繍钀ョ珯鐐瑰崰姣�',
+ passenger_city_ratio DOUBLE DEFAULT NULL COMMENT '鍩庡競鍐呭杩愰噺鍗犳瘮',
+ chengxiang_ratio DOUBLE DEFAULT NULL COMMENT '鍩庨檯鍩庝埂瀹㈣繍閲忓崰姣�',
+ contact_person VARCHAR(100) DEFAULT NULL COMMENT '濉〃浜�',
+ contact_phone VARCHAR(50) DEFAULT NULL COMMENT '鑱旂郴鐢佃瘽',
+ report_date VARCHAR(20) DEFAULT NULL COMMENT '鎶ュ嚭鏃ユ湡',
+ verify_explanation TEXT COMMENT '鏍稿疄鎬у師鍥犺В閲�',
+ report_note TEXT COMMENT '涓婃姤璇存槑',
+ modify_record TEXT COMMENT '淇敼璁板綍',
+ created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
+ PRIMARY KEY (id),
+ KEY idx_period (report_period),
+ KEY idx_city (city),
+ KEY idx_enterprise (enterprise_name)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='鍩庡競鍏氦浼佷笟鏈堝害鏁版嵁锛堝煄甯傚叕鍏变氦閫氭湀搴﹁繍钀ユ儏鍐碉級';
+
+-- 鍩庡競鍏氦 4 缁勫鏍歌鍒欙紙report_type=CITY_BUS锛�
+INSERT IGNORE INTO audit_rule (rule_name, rule_code, description, check_field, compare_type, threshold, alert_level, report_type, is_enabled, sort_order) VALUES
+ ('鍩庡競鍐呬笌鍩庨檯鍩庝埂瀹㈣繍閲忚秼鍔夸竴鑷存牳瀹�', 'RULE_B001', '鍩庡競鍐呭杩愰噺鐜瘮/鍚屾瘮涓庡煄闄呭煄涔″杩愰噺鐜瘮/鍚屾瘮瓒嬪娍涓嶄竴鑷翠笖澧為��>2%闇�鏍稿疄', 'passengerCityMom,passengerChengxiangMom,passengerCityYoy,passengerChengxiangYoy', 'TREND_CONSISTENCY', '0.02', 'YELLOW', 'CITY_BUS', 1, 51),
+ ('瀹㈣繍閲忎笌鏃呭鍛ㄨ浆閲忚秼鍔夸竴鑷存牳瀹�', 'RULE_B002', '瀹㈣繍閲忓悓姣�/鐜瘮涓庢梾瀹㈠懆杞噺鍚屾瘮/鐜瘮瓒嬪娍涓嶄竴鑷撮渶鏍稿疄', 'passengerMom,turnoverMom,passengerYoy,turnoverYoy', 'TREND_CONSISTENCY', '0.02', 'YELLOW', 'CITY_BUS', 1, 52),
+ ('鍩庡競鍐�/鍩庨檯鍩庝埂瀹㈣繍閲忓崰姣斿彉鍖栨牳瀹�', 'RULE_B003', '鍩庡競鍐呭杩愰噺鍗犳瘮鍜屽煄闄呭煄涔″杩愰噺鍗犳瘮涓庝笂鏈堢浉姣斿彉鍖�>1%闇�鏍稿疄', 'passengerCityRatio,chengxiangRatio', 'RATIO_CHANGE', '0.01', 'YELLOW', 'CITY_BUS', 1, 53),
+ ('骞冲潎杩愯窛鍙樺寲骞呭害鏍稿疄', 'RULE_B004', '骞冲潎杩愯窛涓庝笂鏈堢浉姣斿彉鍖栧箙搴﹁秴杩�3鍏噷闇�鏍稿疄锛堢壒鍒槸鍩庨檯鍩庝埂锛�', 'avgDistanceMomChange,avgDistanceCityMomChange,avgDistanceChengxiang', 'AVG_DIST_CHANGE', '3', 'YELLOW', 'CITY_BUS', 1, 54);
--
Gitblit v1.9.1