sp263_journey_types
- Jason Andrew
Owned by Jason Andrew
Oct 02, 2024
Loading data...
This table provides a list of different journey types - e.g. urban, rural etc. Each journey time in the travel matrix (table sp094) has an associated journey type, for which a 'profile' may be defined in table sp209.
Â
Table Definition
Field | Type | Default | Nullable |
|---|---|---|---|
| journey_type | number(3)Â | Â | Â  |
| description | varchar2(10)Â | Â | Â |
| field_id | varchar2(100)Â | Â | Â Â |
Keys
primary key (journey_type)Â
unique (description)Â
foreign key (field_id) references sp900_language_translation (field_id)
Primary Key Referenced From
Â
Column Descriptions
| Field | Description |
|---|---|
| journey_type | Journey type identifier. |
| description | Deprecated - Description. |
| field_id | Key to language translations for description. |