| | |
|---|
| | | KEY idx_holiday_vehicle_date (flow_date) |
|---|
| | | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='节假日综合运输非营业性车流情况'; |
|---|
| | | |
|---|
| | | -- 往年国省道车流量调整 |
|---|
| | | DROP TABLE IF EXISTS holiday_vehicle_adjustment; |
|---|
| | | CREATE TABLE holiday_vehicle_adjustment ( |
|---|
| | | id BIGINT NOT NULL AUTO_INCREMENT, |
|---|
| | | year INT NOT NULL COMMENT '年份', |
|---|
| | | flow_date DATE NOT NULL COMMENT '日期', |
|---|
| | | adjusted_value DECIMAL(30,15) NOT NULL COMMENT '调整后普通国省道车流量（万辆次）', |
|---|
| | | reason VARCHAR(500) NOT 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_adjustment (year, flow_date), |
|---|
| | | KEY idx_holiday_vehicle_adjustment_date (flow_date) |
|---|
| | | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='往年国省道车流量调整'; |
|---|
| | | |
|---|
| | | -- 客运系数配置 |
|---|
| | | DROP TABLE IF EXISTS holiday_passenger_coefficient; |
|---|
| | | CREATE TABLE holiday_passenger_coefficient ( |
|---|
