/
14.1 sp014_travel_overrides
14.1 sp014_travel_overrides
- Billy Sewell (Unlicensed)
Owned by Billy Sewell (Unlicensed)
Jan 26, 2024
Analytics
Loading data...
This table stores a set of travel times which have been changed by the user.
Only one way travel times will be used by the system. If (r1, r2) and (r2, r1) are both in the table then the system will choose only one of them on an arbitrary basis.
The table does not store intra-region times. If (r3,r3) is in the table then it is ignored. This data is obtained from sp057_regions.internal_travel_time.
Table Definition
Field | Type | Default | Nullable |
|---|---|---|---|
region_no1 | number(9) |  | |
region_no2 | number(9) | | |
travel_time | number(6) | | |
travel_profile | number(3) | |
Keys
primary key (region_no1, region_no2)
foreign key (region_no1) references /wiki/spaces/SCH141/pages/27068047 (region_no)
foreign key (region_no2) references /wiki/spaces/SCH141/pages/27068047 (region_no)
foreign key (travel-profile) references 14.1 sp263_journey_types (journey_type)
Column Descriptions
| Field | Description |
|---|---|
| region_no1 | region of one end of journey |
| region_no2 | region of other end of journey |
| travel_time | travel time in minutes |
| travel_profile | journey type |
, multiple selections available,
Related content
sp014_travel_overrides
sp014_travel_overrides
More like this
sp094_travel_times
sp094_travel_times
More like this