From bee9e18c3af284ff432a4472f1d409f5a6dc09a7 Mon Sep 17 00:00:00 2001
From: zhizhijie <zhizhijie@users.noreply.gitee.com>
Date: 星期二, 06 十月 2026 16:59:15 +0800
Subject: [PATCH] Merge remote-tracking branch 'origin/main'

---
 docs/sql_holiday.sql |   66 +++++++++++++++++++++++++++++++++
 1 files changed, 66 insertions(+), 0 deletions(-)

diff --git a/docs/sql_holiday.sql b/docs/sql_holiday.sql
new file mode 100644
index 0000000..da2ccc1
--- /dev/null
+++ b/docs/sql_holiday.sql
@@ -0,0 +1,66 @@
+-- Holiday statistics module. Run against the traffic_audit database.
+CREATE TABLE IF NOT EXISTS holiday_calendar (
+  id BIGINT NOT NULL AUTO_INCREMENT,
+  year INT NOT NULL,
+  holiday_type VARCHAR(32) NOT NULL,
+  holiday_date DATE NOT NULL,
+  day_index INT NOT NULL,
+  created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
+  updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
+  PRIMARY KEY (id),
+  UNIQUE KEY uk_holiday_calendar_seq (year, holiday_type, day_index),
+  UNIQUE KEY uk_holiday_calendar_date (year, holiday_type, holiday_date),
+  KEY idx_holiday_calendar_date (holiday_date)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
+
+CREATE TABLE IF NOT EXISTS holiday_passenger_flow (
+  id BIGINT NOT NULL AUTO_INCREMENT,
+  year INT NOT NULL,
+  flow_date DATE NOT NULL,
+  transport_mode VARCHAR(32) NOT NULL,
+  passenger_count DECIMAL(30,15) NOT NULL,
+  created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
+  updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
+  PRIMARY KEY (id),
+  UNIQUE KEY uk_holiday_passenger (year, flow_date, transport_mode),
+  KEY idx_holiday_passenger_date (flow_date)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
+
+CREATE TABLE IF NOT EXISTS holiday_vehicle_flow (
+  id BIGINT NOT NULL AUTO_INCREMENT,
+  year INT NOT NULL,
+  flow_date DATE NOT NULL,
+  road_category VARCHAR(32) NOT NULL,
+  vehicle_type VARCHAR(32) NOT NULL,
+  vehicle_count DECIMAL(30,15) NOT NULL,
+  comparison_base DECIMAL(30,15) NULL COMMENT '鏅�氬浗鐪侀亾鐜瘮鍩烘湡锛堜竾杈嗘锛屼粎褰撳勾浣跨敤锛�',
+  created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
+  updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
+  PRIMARY KEY (id),
+  UNIQUE KEY uk_holiday_vehicle (year, flow_date, road_category, vehicle_type),
+  KEY idx_holiday_vehicle_date (flow_date)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
+
+CREATE TABLE IF NOT EXISTS holiday_vehicle_adjustment (
+  id BIGINT NOT NULL AUTO_INCREMENT,
+  year INT NOT NULL,
+  flow_date DATE NOT NULL,
+  adjusted_value DECIMAL(30,15) NOT NULL,
+  reason VARCHAR(500) NOT NULL,
+  created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
+  updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
+  PRIMARY KEY (id),
+  UNIQUE KEY uk_holiday_vehicle_adjustment (year, flow_date),
+  KEY idx_holiday_vehicle_adjustment_date (flow_date)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
+
+CREATE TABLE IF NOT EXISTS holiday_passenger_coefficient (
+  id BIGINT NOT NULL AUTO_INCREMENT,
+  year INT NOT NULL,
+  date_category VARCHAR(32) NOT NULL,
+  coefficient DECIMAL(30,15) NOT NULL,
+  created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
+  updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
+  PRIMARY KEY (id),
+  UNIQUE KEY uk_holiday_coefficient (year, date_category)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
Gitblit v1.9.1