sp099_sa_travel_modes
- Jason Andrew
Owned by Jason Andrew
Oct 02, 2024
Loading data...
This table defines the available travel modes for standard activities.
Â
Table Definition
Field | Type | Default | Nullable |
|---|---|---|---|
| mode_no | number | Â |  |
| short_name | varchar2(15) | Â | |
| description | varchar2(40) | Â | |
| field_id | varchar2(100) | Â | |
KeysÂ
primary key (mode_no)Â
foreign key (field_id) references sp900_language_translation (field_id)
Primary Key Referenced From
Â
Column Descriptions
| Field | Description |
|---|---|
| mode_no | Number that represents the mode of travel0 = no travel.1 = travel mode is ETS.2 = travel mode is ETA. |
| short_name | Short name for travel mode, 'NONE', 'ETS', 'ETA'. |
| description | Travel mode description. |
| field_id | key to language translations in sp900 for description |