14.1 sp014_travel_overrides
- Billy Sewell (Unlicensed)
Owned by Billy Sewell (Unlicensed)
Jan 26, 2024
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 |