link ERModel : Model . RVEXPLORE : Package
Entity - IDSNPCVE link
| Properties |
| Name | Value | ||
| Data Model | Physical | ||
| Schema | RVEXPLORE | ||
| Primary Key Clustered | Unspecified | ||
| Unlogged | false | ||
| Temporal | false | ||
| Columns Summary |
| Column Name | Data Type | PK / FK | Nullable | Description | |||||
| ID | char(13) | Yes |
PMS ID. |
||||||
| MPBEG | number(6, 3) | Yes |
Beginning MILEpost. |
||||||
| LGT | number(5, 3) | Yes |
The length with roughness data in the section. |
||||||
| MPEND | number(6, 3) | Yes |
Ending MILEpost. |
||||||
| SESSION_NAME | char(20) | Yes |
The name used for data collection on the route. |
||||||
| SURVDATE | date | Yes |
The date that the data was collected on the route. |
||||||
| PAVEMENTTYPE | char(20) | Yes |
Some form of Asp or Conc that indicates how the frame was processed. |
||||||
| IRILW | number(5, 1) | Yes |
Length Weighted International Roughness Index in in/mile for the section. |
||||||
| RUTLW | number(5, 3) | Yes |
Length Weighted Rutting in Inches for the section for the pavement type. |
||||||
| FLTLW | number(5, 3) | Yes |
Length Weighted Avg Fault Height in Inches for the section for the pavement type. |
||||||
| CRKLW | number(5, 1) | Yes |
Length Weighted Percent Cracking for the section for the pavement type. |
||||||
| Columns Detail |
| Name | Value | ||
| Name | ID | ||
| Description |
PMS ID. |
||
| Type | char | ||
| Nullable | true | ||
| Unique | false | ||
| Primary Key | false | ||
| Index | false | ||
| Type Name | CHAR | ||
| Length | 13 | ||
| Scale | 0 | ||
| Id Generator | native | ||
| Foreign Key | false | ||
| Generated | Unspecified | ||
| Sync To Attribute | Yes | ||
| Name | Value | ||
| Name | MPBEG | ||
| Description |
Beginning MILEpost. |
||
| Type | number | ||
| Nullable | true | ||
| Unique | false | ||
| Primary Key | false | ||
| Index | false | ||
| Type Name | NUMBER | ||
| Length | 6 | ||
| Scale | 3 | ||
| Id Generator | native | ||
| Foreign Key | false | ||
| Generated | Unspecified | ||
| Sync To Attribute | Yes | ||
| Name | Value | ||
| Name | LGT | ||
| Description |
The length with roughness data in the section. |
||
| Type | number | ||
| Nullable | true | ||
| Unique | false | ||
| Primary Key | false | ||
| Index | false | ||
| Type Name | NUMBER | ||
| Length | 5 | ||
| Scale | 3 | ||
| Id Generator | native | ||
| Foreign Key | false | ||
| Generated | Unspecified | ||
| Sync To Attribute | Yes | ||
| Name | Value | ||
| Name | MPEND | ||
| Description |
Ending MILEpost. |
||
| Type | number | ||
| Nullable | true | ||
| Unique | false | ||
| Primary Key | false | ||
| Index | false | ||
| Type Name | NUMBER | ||
| Length | 6 | ||
| Scale | 3 | ||
| Id Generator | native | ||
| Foreign Key | false | ||
| Generated | Unspecified | ||
| Sync To Attribute | Yes | ||
| Name | Value | ||
| Name | SESSION_NAME | ||
| Description |
The name used for data collection on the route. |
||
| Type | char | ||
| Nullable | true | ||
| Unique | false | ||
| Primary Key | false | ||
| Index | false | ||
| Type Name | CHAR | ||
| Length | 20 | ||
| Scale | 0 | ||
| Id Generator | native | ||
| Foreign Key | false | ||
| Generated | Unspecified | ||
| Sync To Attribute | Yes | ||
| Name | Value | ||
| Name | SURVDATE | ||
| Description |
The date that the data was collected on the route. |
||
| 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 | PAVEMENTTYPE | ||
| Description |
Some form of Asp or Conc that indicates how the frame was processed. |
||
| Type | char | ||
| Nullable | true | ||
| Unique | false | ||
| Primary Key | false | ||
| Index | false | ||
| Type Name | CHAR | ||
| Length | 20 | ||
| Scale | 0 | ||
| Id Generator | native | ||
| Foreign Key | false | ||
| Generated | Unspecified | ||
| Sync To Attribute | Yes | ||
| Name | Value | ||
| Name | IRILW | ||
| Description |
Length Weighted International Roughness Index in in/mile for the section. |
||
| 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 | RUTLW | ||
| Description |
Length Weighted Rutting in Inches for the section for the pavement type. |
||
| Type | number | ||
| Nullable | true | ||
| Unique | false | ||
| Primary Key | false | ||
| Index | false | ||
| Type Name | NUMBER | ||
| Length | 5 | ||
| Scale | 3 | ||
| Id Generator | native | ||
| Foreign Key | false | ||
| Generated | Unspecified | ||
| Sync To Attribute | Yes | ||
| Name | Value | ||
| Name | FLTLW | ||
| Description |
Length Weighted Avg Fault Height in Inches for the section for the pavement type. |
||
| Type | number | ||
| Nullable | true | ||
| Unique | false | ||
| Primary Key | false | ||
| Index | false | ||
| Type Name | NUMBER | ||
| Length | 5 | ||
| Scale | 3 | ||
| Id Generator | native | ||
| Foreign Key | false | ||
| Generated | Unspecified | ||
| Sync To Attribute | Yes | ||
| Name | Value | ||
| Name | CRKLW | ||
| Description |
Length Weighted Percent Cracking for the section for the pavement type. |
||
| 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 | ||
| Appears In |
| Diagram | |||
|
|
|||