link ERModel : Model . PMIS : Package
Entity - HFDIST_20191024 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 | number(1) | Yes |
Route Class 1-3 (1=I,2=U,3=K). |
||||||
| RTNO | number(3) | Yes |
Route Number. |
||||||
| CODE | number(1) | Yes |
Route Suffix 0-8. |
||||||
| IMPBEG | number(2) | Yes |
Integer Beginning MILEpost. |
||||||
| IMPEND | number(2) | Yes |
Integer Ending MILEpost. |
||||||
| LANE | number(1) | Yes |
Lane Designation 0-4. |
||||||
| ID | char(13) | Yes |
PMS ID (based on first seven fields). |
||||||
| HFDATE | date | Yes |
Flexible Pavement Condition Survey DATE. |
||||||
| HRUTVAL | number(5, 3) | Yes |
Rutting Depth. |
||||||
| HRUT | number(2) | Yes |
Average and Maximum Rutting Severity. |
||||||
| HFCR1 | number(3) | Yes |
Extent of Code1 Fatigue Cracking. |
||||||
| HFCR2 | number(3) | Yes |
Extent of Code2 Fatigue Cracking. |
||||||
| HFCR3 | number(3) | Yes |
Extent of Code3 Fatigue Cracking. |
||||||
| HFCR4 | number(3) | Yes |
Extent of Code4 Fatigue Cracking. |
||||||
| HTCR1 | number(2) | Yes |
Extent of Code1 Transverse Cracking. |
||||||
| HTCR2 | number(2) | Yes |
Extent of Code2 Transverse Cracking. |
||||||
| HTCR3 | number(2) | Yes |
Extent of Code3 Transverse Cracking. |
||||||
| HBCR | number(2) | Yes |
Block Cracking Severity. |
||||||
| HTCR0 | number(2) | Yes |
Extent of Code0 Transverse Cracking. |
||||||
| HTCI | number(3) | Yes |
Transverse Cracking Index. |
||||||
| HEQTCR | number(4, 2) | Yes |
Equivalent Transverse Cracking |
||||||
| HEQFCR | number(7, 3) | Yes |
Equivalent fatigue cracking. |
||||||
| 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 1-3 (1=I,2=U,3=K). |
||
| 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 | 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 | IMPBEG | ||
| Description |
Integer Beginning MILEpost. |
||
| Type | number | ||
| Nullable | true | ||
| Unique | false | ||
| Primary Key | false | ||
| Index | false | ||
| Type Name | NUMBER | ||
| Length | 2 | ||
| Scale | 0 | ||
| Id Generator | native | ||
| Foreign Key | false | ||
| Generated | Unspecified | ||
| Sync To Attribute | Yes | ||
| Name | Value | ||
| Name | IMPEND | ||
| Description |
Integer Ending MILEpost. |
||
| Type | number | ||
| Nullable | true | ||
| Unique | false | ||
| Primary Key | false | ||
| Index | false | ||
| Type Name | NUMBER | ||
| Length | 2 | ||
| Scale | 0 | ||
| Id Generator | native | ||
| Foreign Key | false | ||
| Generated | Unspecified | ||
| Sync To Attribute | Yes | ||
| Name | Value | ||
| Name | LANE | ||
| Description |
Lane Designation 0-4. |
||
| 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 | ID | ||
| Description |
PMS ID (based on first seven fields). |
||
| 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 | HFDATE | ||
| Description |
Flexible Pavement Condition Survey DATE. |
||
| 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 | HRUTVAL | ||
| Description |
Rutting Depth. |
||
| 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 | HRUT | ||
| Description |
Average and Maximum Rutting Severity. |
||
| Type | number | ||
| Nullable | true | ||
| Unique | false | ||
| Primary Key | false | ||
| Index | false | ||
| Type Name | NUMBER | ||
| Length | 2 | ||
| Scale | 0 | ||
| Id Generator | native | ||
| Foreign Key | false | ||
| Generated | Unspecified | ||
| Sync To Attribute | Yes | ||
| Name | Value | ||
| Name | HFCR1 | ||
| Description |
Extent of Code1 Fatigue Cracking. |
||
| 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 | HFCR2 | ||
| Description |
Extent of Code2 Fatigue Cracking. |
||
| 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 | HFCR3 | ||
| Description |
Extent of Code3 Fatigue Cracking. |
||
| 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 | HFCR4 | ||
| Description |
Extent of Code4 Fatigue Cracking. |
||
| 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 | HTCR1 | ||
| Description |
Extent of Code1 Transverse Cracking. |
||
| Type | number | ||
| Nullable | true | ||
| Unique | false | ||
| Primary Key | false | ||
| Index | false | ||
| Type Name | NUMBER | ||
| Length | 2 | ||
| Scale | 0 | ||
| Id Generator | native | ||
| Foreign Key | false | ||
| Generated | Unspecified | ||
| Sync To Attribute | Yes | ||
| Name | Value | ||
| Name | HTCR2 | ||
| Description |
Extent of Code2 Transverse Cracking. |
||
| Type | number | ||
| Nullable | true | ||
| Unique | false | ||
| Primary Key | false | ||
| Index | false | ||
| Type Name | NUMBER | ||
| Length | 2 | ||
| Scale | 0 | ||
| Id Generator | native | ||
| Foreign Key | false | ||
| Generated | Unspecified | ||
| Sync To Attribute | Yes | ||
| Name | Value | ||
| Name | HTCR3 | ||
| Description |
Extent of Code3 Transverse Cracking. |
||
| Type | number | ||
| Nullable | true | ||
| Unique | false | ||
| Primary Key | false | ||
| Index | false | ||
| Type Name | NUMBER | ||
| Length | 2 | ||
| Scale | 0 | ||
| Id Generator | native | ||
| Foreign Key | false | ||
| Generated | Unspecified | ||
| Sync To Attribute | Yes | ||
| Name | Value | ||
| Name | HBCR | ||
| Description |
Block Cracking Severity. |
||
| Type | number | ||
| Nullable | true | ||
| Unique | false | ||
| Primary Key | false | ||
| Index | false | ||
| Type Name | NUMBER | ||
| Length | 2 | ||
| Scale | 0 | ||
| Id Generator | native | ||
| Foreign Key | false | ||
| Generated | Unspecified | ||
| Sync To Attribute | Yes | ||
| Name | Value | ||
| Name | HTCR0 | ||
| Description |
Extent of Code0 Transverse Cracking. |
||
| Type | number | ||
| Nullable | true | ||
| Unique | false | ||
| Primary Key | false | ||
| Index | false | ||
| Type Name | NUMBER | ||
| Length | 2 | ||
| Scale | 0 | ||
| Id Generator | native | ||
| Foreign Key | false | ||
| Generated | Unspecified | ||
| Sync To Attribute | Yes | ||
| Name | Value | ||
| Name | HTCI | ||
| Description |
Transverse Cracking Index. |
||
| 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 | HEQTCR | ||
| Description |
Equivalent Transverse Cracking |
||
| Type | number | ||
| Nullable | true | ||
| Unique | false | ||
| Primary Key | false | ||
| Index | false | ||
| Type Name | NUMBER | ||
| Length | 4 | ||
| Scale | 2 | ||
| Id Generator | native | ||
| Foreign Key | false | ||
| Generated | Unspecified | ||
| Sync To Attribute | Yes | ||
| Name | Value | ||
| Name | HEQFCR | ||
| Description |
Equivalent fatigue cracking. |
||
| 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 | ||