sp014_travel_overrides
- Jason Andrew
Owned by Jason Andrew
Oct 02, 2024
1 min read
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 sp057_regions (region_no)Â
foreign key (region_no2) references sp057_regions (region_no)Â
foreign key (travel-profile) references 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 |
Â
Â
Â