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_taxi.sql | 82 +++++++++++++++++++++++++++++++++++++++++
1 files changed, 82 insertions(+), 0 deletions(-)
diff --git a/docs/sql_city_taxi.sql b/docs/sql_city_taxi.sql
new file mode 100644
index 0000000..824bf62
--- /dev/null
+++ b/docs/sql_city_taxi.sql
@@ -0,0 +1,82 @@
+-- 鍩庡競瀹㈣繍绗�2姝ワ紙宸℃父鍑虹锛夊缓琛� + 瀹℃牳瑙勫垯
+-- 鏁版嵁婧�1锛氬鍏宸℃父鍑虹姹借溅杩愯惀鏈嶅姟鎯呭喌鏈堟姤锛�2026骞�7鏈堬級.xls锛堝競宸炵骇锛�17琛岋級
+-- 鏁版嵁婧�2锛氳緭鍏鍑虹杞︿俊鎭�(杩愭斂杞﹁締淇℃伅).xls锛堣溅杈嗙骇鏄庣粏 42636 琛岋級
+
+CREATE TABLE IF NOT EXISTS city_taxi_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 '甯傚窞',
+ trip_total DOUBLE DEFAULT NULL COMMENT '杞藉杞︽鎬绘暟',
+ trip_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 '鏃呭鍛ㄨ浆閲廮鍩庡競鍐�',
+ op_vehicles DOUBLE DEFAULT NULL COMMENT '杩愯惀杞﹁締鏁�',
+ avg_distance DOUBLE DEFAULT NULL COMMENT '宸℃父鍑虹姹借溅骞冲潎杩愯窛锛堝叕閲岋級',
+ avg_distance_city DOUBLE DEFAULT NULL COMMENT '鍩庡競鍐呭钩鍧囪繍璺濓紙鍏噷锛�',
+ daily_trips_per_vehicle DOUBLE DEFAULT NULL COMMENT '鍗曡溅鏃ュ潎杞藉杞︽',
+ daily_passenger_per_vehicle DOUBLE DEFAULT NULL COMMENT '鍗曡溅鏃ュ潎瀹㈣繍閲�',
+ passengers_per_trip DOUBLE DEFAULT NULL COMMENT '鍗曡溅娆¤浇瀹汉鏁�',
+ passengers_per_trip_city DOUBLE DEFAULT NULL COMMENT '鍗曡溅娆¤浇瀹汉鏁癬鍩庡競鍐�',
+ passengers_per_trip_chengxiang DOUBLE DEFAULT NULL COMMENT '鍗曡溅娆¤浇瀹汉鏁癬鍩庨檯鍩庝埂',
+ rate_op_vehicles_mom DOUBLE DEFAULT NULL COMMENT '杩愯惀杞︽暟鐜瘮澧為��',
+ rate_op_vehicles_yoy DOUBLE DEFAULT NULL COMMENT '杩愯惀杞︽暟鍚屾瘮澧為��',
+ rate_trip_mom DOUBLE DEFAULT NULL COMMENT '杞藉杞︽鎬绘暟鐜瘮澧為��',
+ rate_trip_yoy DOUBLE DEFAULT NULL COMMENT '杞藉杞︽鍚屾瘮澧為��',
+ rate_passenger_mom DOUBLE DEFAULT NULL COMMENT '瀹㈣繍閲忕幆姣斿閫�',
+ rate_passenger_yoy DOUBLE DEFAULT NULL COMMENT '瀹㈣繍閲忓悓姣斿閫�',
+ avg_distance_mom_change DOUBLE DEFAULT NULL COMMENT '骞冲潎杩愯窛鐜瘮澧炲噺锛堝叕閲岋級',
+ avg_distance_city_mom_change DOUBLE DEFAULT NULL COMMENT '骞冲潎杩愯窛_鍩庡競鍐呯幆姣斿鍑忥紙鍏噷锛�',
+ rate_trip_city_mom DOUBLE DEFAULT NULL COMMENT '杞藉杞︽鎬绘暟鐜瘮澧為�焈鍩庡競鍐�',
+ rate_passenger_city_mom DOUBLE DEFAULT NULL COMMENT '瀹㈣繍閲忕幆姣斿閫焈鍩庡競鍐�',
+ rate_trip_chengxiang_mom DOUBLE DEFAULT NULL COMMENT '杞藉杞︽鎬绘暟_鍩庨檯鍩庝埂鐜瘮澧為��',
+ rate_passenger_chengxiang_mom DOUBLE DEFAULT NULL COMMENT '瀹㈣繍閲廮鍩庨檯鍩庝埂鐜瘮澧為��',
+ avg_distance_chengxiang DOUBLE DEFAULT NULL COMMENT '骞冲潎杩愯窛_鍩庨檯鍩庝埂锛堝叕閲岋級',
+ trip_city_ratio DOUBLE DEFAULT NULL COMMENT '杞藉杞︽鎬绘暟_鍩庡競鍐呭崰姣�',
+ passenger_city_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)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='宸℃父鍑虹姹借溅杩愯惀鏈嶅姟鎯呭喌鏈堟姤锛堝競宸炵骇锛�';
+
+CREATE TABLE IF NOT EXISTS city_taxi_auth (
+ id BIGINT NOT NULL AUTO_INCREMENT,
+ report_period VARCHAR(20) NOT NULL COMMENT '鎶ヨ〃鏈� 2026-07',
+ city VARCHAR(50) DEFAULT NULL COMMENT '甯傚窞锛堢敱璇佸彿/妗ｆ鍙�/鍦板潃鎻愬彇锛�',
+ plate_no VARCHAR(30) DEFAULT NULL COMMENT '杞︾墝鍙风爜',
+ vehicle_type VARCHAR(50) DEFAULT NULL COMMENT '杞﹁締绫诲瀷',
+ biz_type VARCHAR(50) DEFAULT NULL COMMENT '缁忚惀绫诲瀷',
+ owner_name VARCHAR(100) DEFAULT NULL COMMENT '杞︿富鍚嶇О',
+ license_no VARCHAR(100) DEFAULT NULL COMMENT '缁忚惀鏉冨彿',
+ archive_no VARCHAR(100) DEFAULT NULL COMMENT '妗ｆ鍙�',
+ road_cert_no VARCHAR(100) DEFAULT NULL COMMENT '閬撹矾杩愯緭璇佸瓧鍙�',
+ fuel_type VARCHAR(50) DEFAULT NULL COMMENT '鐕冩枡绫诲瀷',
+ operator_name VARCHAR(200) DEFAULT NULL COMMENT '涓氭埛鍚嶇О',
+ operator_addr VARCHAR(300) DEFAULT NULL COMMENT '涓氭埛鍦板潃',
+ op_status VARCHAR(20) DEFAULT NULL COMMENT '钀ヨ繍鐘舵��',
+ cert_status VARCHAR(20) DEFAULT NULL COMMENT '璇佷欢鐘舵��',
+ created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
+ PRIMARY KEY (id),
+ KEY idx_period (report_period),
+ KEY idx_city (city),
+ KEY idx_period_city (report_period, city)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='鍑虹杞﹁繍鏀胯溅杈嗕俊鎭紙杞﹁締绾ф槑缁嗭級';
+
+-- 鍩庡競瀹㈣繍绗�2姝ワ細宸℃父鍑虹 7 缁勫鏍歌鍒欙紙report_type=CITY_TAXI锛�
+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_T001', '鏈堟姤杩愯惀杞﹁締鏁颁笌杩愭斂绯荤粺杞﹁締鏁板樊璺�>3%闇�鏍稿疄', 'opVehicles', 'CROSS_DIFF_PCT', '3', 'RED', 'CITY_TAXI', 1, 61),
+ ('鍩庡競鍐呬笌鍩庨檯鍩庝埂瀹㈣繍閲忚秼鍔夸竴鑷存牳瀹�', 'RULE_T002', '鍩庡競鍐呭杩愰噺鐜瘮涓庡煄闄呭煄涔″杩愰噺鐜瘮瓒嬪娍涓嶄竴鑷翠笖澧為��>2%闇�鏍稿疄', 'passengerCityMom,passengerChengxiangMom', 'TREND_CONSISTENCY', '0.02', 'YELLOW', 'CITY_TAXI', 1, 62),
+ ('瀹㈣繍閲忎笌鏃呭鍛ㄨ浆閲忚秼鍔夸竴鑷存牳瀹�', 'RULE_T003', '瀹㈣繍閲忕幆姣斾笌鏃呭鍛ㄨ浆閲忕幆姣旓紙鐢卞钩鍧囪繍璺濇帹瀵硷級瓒嬪娍涓嶄竴鑷撮渶鏍稿疄', 'passengerMom,turnoverMomDerived', 'TREND_CONSISTENCY', '0.02', 'YELLOW', 'CITY_TAXI', 1, 63),
+ ('鍩庡競鍐呭杩愰噺鍗犳瘮鍙樺寲鏍稿疄', 'RULE_T004', '鍩庡競鍐呭杩愰噺鍗犳瘮涓庝笂鏈堢浉姣斿彉鍖�>1%闇�鏍稿疄', 'passengerCityRatio', 'RATIO_CHANGE', '0.01', 'YELLOW', 'CITY_TAXI', 1, 64),
+ ('骞冲潎杩愯窛鍙樺寲骞呭害鏍稿疄', 'RULE_T005', '骞冲潎杩愯窛涓庝笂鏈堢浉姣斿彉鍖栬秴杩�3鍏噷闇�鏍稿疄锛堢壒鍒槸鍩庨檯鍩庝埂锛�', 'avgDistanceMomChange,avgDistanceCityMomChange,avgDistanceChengxiang', 'AVG_DIST_CHANGE', '3', 'YELLOW', 'CITY_TAXI', 1, 65),
+ ('鍗曡溅娆¤浇瀹汉鏁扮郴鏁板彉鍖栨牳瀹�', 'RULE_T006', '鍗曡溅娆¤浇瀹汉鏁�=瀹㈣繍閲�/杞藉杞︽鎬绘暟锛屼笌涓婃湀鐩告瘮鍙樺寲>0.2闇�鏍稿疄', 'passengersPerTrip', 'PAX_PER_TRIP_CHANGE', '0.2', 'YELLOW', 'CITY_TAXI', 1, 66),
+ ('杞藉杞︽鎬绘暟涓庡杩愰噺瓒嬪娍涓�鑷存牳瀹�', 'RULE_T007', '杞藉杞︽鎬绘暟鐜瘮/鍚屾瘮涓庡杩愰噺鐜瘮/鍚屾瘮瓒嬪娍涓嶄竴鑷撮渶鏍稿疄', 'tripMom,passengerMom,tripYoy,passengerYoy', 'TREND_CONSISTENCY', '0.01', 'YELLOW', 'CITY_TAXI', 1, 67);
--
Gitblit v1.9.1