ERModel : Model . KSR : Package
Entity - LCMSFRAMEHPMSNON20211123 link
Properties |
Name | Value | ||
Data Model | Physical | ||
Schema | KSR | ||
Primary Key Clustered | Unspecified | ||
Unlogged | false | ||
Temporal | false |
Columns Summary |
Column Name | Data Type | PK / FK | Nullable | Description | |||||
COUNTING | varchar2(22) | Yes | |||||||
START_OD | number(9, 3) | Yes | |||||||
STOP_OD | number(9, 3) | Yes | |||||||
OD_DIST | number(9, 3) | Yes | |||||||
SESSIONFILE | varchar2(50) | Yes | |||||||
RUTAVGLNR | number(9, 3) | Yes | |||||||
LATSTART | number(12, 8) | Yes | |||||||
LONGSTART | number(12, 8) | Yes | |||||||
TIMESTART | varchar2(22) | Yes | |||||||
SURVDATE | date | Yes | |||||||
LATEND | number(12, 8) | Yes | |||||||
LONGEND | number(12, 8) | Yes | |||||||
PAVEMENTTYPE | varchar2(20) | Yes | |||||||
JTAVGFAULT | number(9, 3) | Yes | |||||||
AFFSLABCNT | number(3) | Yes | |||||||
TOTSLABCNT | number(3) | Yes | |||||||
AVGLNWIDTH | number(9, 3) | Yes | |||||||
CRKGPRCT | number(9, 3) | Yes | |||||||
PRCTVALID | number(9, 3) | Yes | |||||||
HPMSAVGIRI | number(9, 3) | Yes |
Columns Detail |
Name | Value | ||
Name | COUNTING | ||
Type | varchar2 | ||
Nullable | true | ||
Unique | false | ||
Primary Key | false | ||
Index | false | ||
Type Name | VARCHAR2 | ||
Length | 22 | ||
Scale | 0 | ||
Id Generator | native | ||
Foreign Key | false | ||
Generated | Unspecified | ||
Sync To Attribute | Yes |
Name | Value | ||
Name | START_OD | ||
Type | number | ||
Nullable | true | ||
Unique | false | ||
Primary Key | false | ||
Index | false | ||
Type Name | NUMBER | ||
Length | 9 | ||
Scale | 3 | ||
Id Generator | native | ||
Foreign Key | false | ||
Generated | Unspecified | ||
Sync To Attribute | Yes |
Name | Value | ||
Name | STOP_OD | ||
Type | number | ||
Nullable | true | ||
Unique | false | ||
Primary Key | false | ||
Index | false | ||
Type Name | NUMBER | ||
Length | 9 | ||
Scale | 3 | ||
Id Generator | native | ||
Foreign Key | false | ||
Generated | Unspecified | ||
Sync To Attribute | Yes |
Name | Value | ||
Name | OD_DIST | ||
Type | number | ||
Nullable | true | ||
Unique | false | ||
Primary Key | false | ||
Index | false | ||
Type Name | NUMBER | ||
Length | 9 | ||
Scale | 3 | ||
Id Generator | native | ||
Foreign Key | false | ||
Generated | Unspecified | ||
Sync To Attribute | Yes |
Name | Value | ||
Name | SESSIONFILE | ||
Type | varchar2 | ||
Nullable | true | ||
Unique | false | ||
Primary Key | false | ||
Index | false | ||
Type Name | VARCHAR2 | ||
Length | 50 | ||
Scale | 0 | ||
Id Generator | native | ||
Foreign Key | false | ||
Generated | Unspecified | ||
Sync To Attribute | Yes |
Name | Value | ||
Name | RUTAVGLNR | ||
Type | number | ||
Nullable | true | ||
Unique | false | ||
Primary Key | false | ||
Index | false | ||
Type Name | NUMBER | ||
Length | 9 | ||
Scale | 3 | ||
Id Generator | native | ||
Foreign Key | false | ||
Generated | Unspecified | ||
Sync To Attribute | Yes |
Name | Value | ||
Name | LATSTART | ||
Type | number | ||
Nullable | true | ||
Unique | false | ||
Primary Key | false | ||
Index | false | ||
Type Name | NUMBER | ||
Length | 12 | ||
Scale | 8 | ||
Id Generator | native | ||
Foreign Key | false | ||
Generated | Unspecified | ||
Sync To Attribute | Yes |
Name | Value | ||
Name | LONGSTART | ||
Type | number | ||
Nullable | true | ||
Unique | false | ||
Primary Key | false | ||
Index | false | ||
Type Name | NUMBER | ||
Length | 12 | ||
Scale | 8 | ||
Id Generator | native | ||
Foreign Key | false | ||
Generated | Unspecified | ||
Sync To Attribute | Yes |
Name | Value | ||
Name | TIMESTART | ||
Type | varchar2 | ||
Nullable | true | ||
Unique | false | ||
Primary Key | false | ||
Index | false | ||
Type Name | VARCHAR2 | ||
Length | 22 | ||
Scale | 0 | ||
Id Generator | native | ||
Foreign Key | false | ||
Generated | Unspecified | ||
Sync To Attribute | Yes |
Name | Value | ||
Name | SURVDATE | ||
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 | LATEND | ||
Type | number | ||
Nullable | true | ||
Unique | false | ||
Primary Key | false | ||
Index | false | ||
Type Name | NUMBER | ||
Length | 12 | ||
Scale | 8 | ||
Id Generator | native | ||
Foreign Key | false | ||
Generated | Unspecified | ||
Sync To Attribute | Yes |
Name | Value | ||
Name | LONGEND | ||
Type | number | ||
Nullable | true | ||
Unique | false | ||
Primary Key | false | ||
Index | false | ||
Type Name | NUMBER | ||
Length | 12 | ||
Scale | 8 | ||
Id Generator | native | ||
Foreign Key | false | ||
Generated | Unspecified | ||
Sync To Attribute | Yes |
Name | Value | ||
Name | PAVEMENTTYPE | ||
Type | varchar2 | ||
Nullable | true | ||
Unique | false | ||
Primary Key | false | ||
Index | false | ||
Type Name | VARCHAR2 | ||
Length | 20 | ||
Scale | 0 | ||
Id Generator | native | ||
Foreign Key | false | ||
Generated | Unspecified | ||
Sync To Attribute | Yes |
Name | Value | ||
Name | JTAVGFAULT | ||
Type | number | ||
Nullable | true | ||
Unique | false | ||
Primary Key | false | ||
Index | false | ||
Type Name | NUMBER | ||
Length | 9 | ||
Scale | 3 | ||
Id Generator | native | ||
Foreign Key | false | ||
Generated | Unspecified | ||
Sync To Attribute | Yes |
Name | Value | ||
Name | AFFSLABCNT | ||
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 | TOTSLABCNT | ||
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 | AVGLNWIDTH | ||
Type | number | ||
Nullable | true | ||
Unique | false | ||
Primary Key | false | ||
Index | false | ||
Type Name | NUMBER | ||
Length | 9 | ||
Scale | 3 | ||
Id Generator | native | ||
Foreign Key | false | ||
Generated | Unspecified | ||
Sync To Attribute | Yes |
Name | Value | ||
Name | CRKGPRCT | ||
Type | number | ||
Nullable | true | ||
Unique | false | ||
Primary Key | false | ||
Index | false | ||
Type Name | NUMBER | ||
Length | 9 | ||
Scale | 3 | ||
Id Generator | native | ||
Foreign Key | false | ||
Generated | Unspecified | ||
Sync To Attribute | Yes |
Name | Value | ||
Name | PRCTVALID | ||
Type | number | ||
Nullable | true | ||
Unique | false | ||
Primary Key | false | ||
Index | false | ||
Type Name | NUMBER | ||
Length | 9 | ||
Scale | 3 | ||
Id Generator | native | ||
Foreign Key | false | ||
Generated | Unspecified | ||
Sync To Attribute | Yes |
Name | Value | ||
Name | HPMSAVGIRI | ||
Type | number | ||
Nullable | true | ||
Unique | false | ||
Primary Key | false | ||
Index | false | ||
Type Name | NUMBER | ||
Length | 9 | ||
Scale | 3 | ||
Id Generator | native | ||
Foreign Key | false | ||
Generated | Unspecified | ||
Sync To Attribute | Yes |