link ERModel : Model . PMIS : Package
Entity - VIDLOGGPS link
| Properties |
| Name | Value | ||
| Data Model | Physical | ||
| Schema | PMIS | ||
| Primary Key Clustered | Unspecified | ||
| Unlogged | false | ||
| Temporal | false | ||
| Columns Summary |
| Column Name | Data Type | PK / FK | Nullable | Description | |||||
| COUNTY | number(3) | Yes |
County Number 1-105. |
||||||
| RTTY | varchar2(1) | Yes |
Route Class (I,U,K). |
||||||
| RTNO | number(3) | Yes |
Route Number. |
||||||
| CODE | number(1) | Yes |
Route Suffix 0-8. |
||||||
| UNIQ_ID | number(1) | Yes |
Unique identifier. |
||||||
| REFPOST | number(7, 3) | Yes |
County refpost in miles. |
||||||
| DRCTN | number(1) | Yes |
Direction: 1 - n, 2 - ne 3 - e, 4 - se 5 - s, 6 - sw 7 - w, 8 - nw |
||||||
| GDATE | date | Yes |
Date gps collected. |
||||||
| TIME | number(6) | Yes |
Time gps collected. |
||||||
| LATITUDE | number(10, 7) | Yes |
Latitude. |
||||||
| LONGITUDE | number(12, 7) | Yes |
Longitude. |
||||||
| ELEV_M | number(5, 1) | Yes |
Elevation in meters. |
||||||
| EXCLUDE | number(1) | Yes |
0=valid data, 1=suspect data-exclude. |
||||||
| DATETIME | number(13, 7) | Yes | |||||||
| RUNGROUP | number(7) | Yes | |||||||
| Columns Detail |
| Name | Value | ||
| Name | COUNTY | ||
| Description |
County Number 1-105. |
||
| Type | number | ||
| Nullable | true | ||
| Unique | false | ||
| Primary Key | false | ||
| Index | false | ||
| Type Name | NUMBER | ||
| Length | 3 | ||
| Scale | 0 | ||
| Id Generator | native | ||
| Foreign Key | false | ||
| Generated | Unspecified | ||
| Sync To Attribute | Yes | ||
| Name | Value | ||
| Name | RTTY | ||
| Description |
Route Class (I,U,K). |
||
| Type | varchar2 | ||
| Nullable | true | ||
| Unique | false | ||
| Primary Key | false | ||
| Index | false | ||
| Type Name | VARCHAR2 | ||
| Length | 1 | ||
| Scale | 0 | ||
| Id Generator | native | ||
| Foreign Key | false | ||
| Generated | Unspecified | ||
| Sync To Attribute | Yes | ||
| Name | Value | ||
| Name | RTNO | ||
| Description |
Route Number. |
||
| Type | number | ||
| Nullable | true | ||
| Unique | false | ||
| Primary Key | false | ||
| Index | false | ||
| Type Name | NUMBER | ||
| Length | 3 | ||
| Scale | 0 | ||
| Id Generator | native | ||
| Foreign Key | false | ||
| Generated | Unspecified | ||
| Sync To Attribute | Yes | ||
| Name | Value | ||
| Name | CODE | ||
| Description |
Route Suffix 0-8. |
||
| Type | number | ||
| Nullable | true | ||
| Unique | false | ||
| Primary Key | false | ||
| Index | false | ||
| Type Name | NUMBER | ||
| Length | 1 | ||
| Scale | 0 | ||
| Id Generator | native | ||
| Foreign Key | false | ||
| Generated | Unspecified | ||
| Sync To Attribute | Yes | ||
| Name | Value | ||
| Name | UNIQ_ID | ||
| Description |
Unique identifier. |
||
| Type | number | ||
| Nullable | true | ||
| Unique | false | ||
| Primary Key | false | ||
| Index | false | ||
| Type Name | NUMBER | ||
| Length | 1 | ||
| Scale | 0 | ||
| Id Generator | native | ||
| Foreign Key | false | ||
| Generated | Unspecified | ||
| Sync To Attribute | Yes | ||
| Name | Value | ||
| Name | REFPOST | ||
| Description |
County refpost in miles. |
||
| Type | number | ||
| Nullable | true | ||
| Unique | false | ||
| Primary Key | false | ||
| Index | false | ||
| Type Name | NUMBER | ||
| Length | 7 | ||
| Scale | 3 | ||
| Id Generator | native | ||
| Foreign Key | false | ||
| Generated | Unspecified | ||
| Sync To Attribute | Yes | ||
| Name | Value | ||
| Name | DRCTN | ||
| Description |
Direction: 1 - n, 2 - ne 3 - e, 4 - se 5 - s, 6 - sw 7 - w, 8 - nw |
||
| Type | number | ||
| Nullable | true | ||
| Unique | false | ||
| Primary Key | false | ||
| Index | false | ||
| Type Name | NUMBER | ||
| Length | 1 | ||
| Scale | 0 | ||
| Id Generator | native | ||
| Foreign Key | false | ||
| Generated | Unspecified | ||
| Sync To Attribute | Yes | ||
| Name | Value | ||
| Name | GDATE | ||
| Description |
Date gps collected. |
||
| Type | date | ||
| Nullable | true | ||
| Unique | false | ||
| Primary Key | false | ||
| Index | false | ||
| Type Name | DATE | ||
| Length | 0 | ||
| Scale | 0 | ||
| Id Generator | native | ||
| Foreign Key | false | ||
| Generated | Unspecified | ||
| Sync To Attribute | Yes | ||
| Name | Value | ||
| Name | TIME | ||
| Description |
Time gps collected. |
||
| Type | number | ||
| Nullable | true | ||
| Unique | false | ||
| Primary Key | false | ||
| Index | false | ||
| Length | 6 | ||
| Scale | 0 | ||
| Id Generator | native | ||
| Foreign Key | false | ||
| Generated | Unspecified | ||
| Sync To Attribute | Yes | ||
| Name | Value | ||
| Name | LATITUDE | ||
| Description |
Latitude. |
||
| Type | number | ||
| Nullable | true | ||
| Unique | false | ||
| Primary Key | false | ||
| Index | false | ||
| Type Name | NUMBER | ||
| Length | 10 | ||
| Scale | 7 | ||
| Id Generator | native | ||
| Foreign Key | false | ||
| Generated | Unspecified | ||
| Sync To Attribute | Yes | ||
| Name | Value | ||
| Name | LONGITUDE | ||
| Description |
Longitude. |
||
| Type | number | ||
| Nullable | true | ||
| Unique | false | ||
| Primary Key | false | ||
| Index | false | ||
| Type Name | NUMBER | ||
| Length | 12 | ||
| Scale | 7 | ||
| Id Generator | native | ||
| Foreign Key | false | ||
| Generated | Unspecified | ||
| Sync To Attribute | Yes | ||
| Name | Value | ||
| Name | ELEV_M | ||
| Description |
Elevation in meters. |
||
| Type | number | ||
| Nullable | true | ||
| Unique | false | ||
| Primary Key | false | ||
| Index | false | ||
| Type Name | NUMBER | ||
| Length | 5 | ||
| Scale | 1 | ||
| Id Generator | native | ||
| Foreign Key | false | ||
| Generated | Unspecified | ||
| Sync To Attribute | Yes | ||
| Name | Value | ||
| Name | EXCLUDE | ||
| Description |
0=valid data, 1=suspect data-exclude. |
||
| Default Value | 0 | ||
| Type | number | ||
| Nullable | true | ||
| Unique | false | ||
| Primary Key | false | ||
| Index | false | ||
| Type Name | NUMBER | ||
| Length | 1 | ||
| Scale | 0 | ||
| Id Generator | native | ||
| Foreign Key | false | ||
| Generated | Unspecified | ||
| Sync To Attribute | Yes | ||
| Name | Value | ||
| Name | DATETIME | ||
| Default Value | 0.0 | ||
| Type | number | ||
| Nullable | true | ||
| Unique | false | ||
| Primary Key | false | ||
| Index | false | ||
| Type Name | NUMBER | ||
| Length | 13 | ||
| Scale | 7 | ||
| Id Generator | native | ||
| Foreign Key | false | ||
| Generated | Unspecified | ||
| Sync To Attribute | Yes | ||
| Name | Value | ||
| Name | RUNGROUP | ||
| Default Value | 0 | ||
| Type | number | ||
| Nullable | true | ||
| Unique | false | ||
| Primary Key | false | ||
| Index | false | ||
| Length | 7 | ||
| Scale | 0 | ||
| Id Generator | native | ||
| Foreign Key | false | ||
| Generated | Unspecified | ||
| Sync To Attribute | Yes | ||