| | |
|---|
| | | 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, |
|---|
