sp209_peak_travel_times
- Jason Andrew
Owned by Jason Andrew
Oct 02, 2024
1 min read
Loading data...
This table specifies the peak travel factor for various times of the day for each journey type.
Â
Table Definition
Field | Type | Default | Nullable |
|---|---|---|---|
| journey_type | number(3)Â | Â |  |
| start_time | date |  | |
| end_time | date | Â |  |
| travel_factor | number(2,1) | Â | |
KeysÂ
primary key (journey_type, start_time)Â
foreign key (journey_type) references sp263_journey_types (journey_type)
Column Descriptions
| Field | Description |
|---|---|
| journey_type | Journey type identifier. |
| start_time | Start time – only time of day is used. Uses Region Time Zone. |
| end_time | End time – only time of day is used. Uses Region Time Zone. |
| travel_factor | Peak travel factor to be applied for journeys commencing between start_time and end_time. |