sp094_travel_times
- Jason Andrew
Owned by Jason Andrew
Oct 02, 2024
1 min read
Loading data...
The travel matrix defines the region to region travel times for use in offering and scheduling appointments.Â
Not all combinations of regions will be held here, only the sensible region to region trips. If the value for a particular trip is not present then the travel time for the journey between the higher level regions in the region hierarchy will be used.
Â
Table Definition
Field | Type | Default | Nullable |
|---|---|---|---|
| region_no1 | number(9) | Â |  |
| region_ref1 | varchar2(26) | Â | |
| region_no2 | number(9) | Â | |
| region_ref2 | varchar2(26) | Â | |
| start_date | date | Â |  |
| end_date | date | Â | |
| journey_type | number(3) | Â | |
| travel_time | number(11) | Â | |
| adjacent | number(1) | Â | |
KeysÂ
primary key (region_no1, region_no2)Â
unique (region_ref1, region_ref2)Â
foreign key (region_no1, region_ref1) references sp057_regions (region_no, region_ref)Â
foreign key (region_no2, region_ref2) references sp057_regions (region_no, region_ref)Â
foreign key (journey_type) references sp263_journey_types (journey_type)
Column Descriptions
| Field | Description |
|---|---|
| region_no1 Â | ServiceOptimizer identifier of region 1. |
| region_ref1 | User identifier of region 1. |
| region_no2 | ServiceOptimizer identifier of region 2. |
| region_ref2 | User identifier of region 2. |
| start_date | Not used. |
| end_date | Not used. |
| journey_type | Journey type - urban, rural etc. |
| travel_time | Travel time in minutes between region 1 and region 2. |
| adjacent | Flag indicating whether or not regions 1 and 2 are adjacent - 0 - not adjacent 1 - adjacent |