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