link ERModel : Model . PMIS : Package
Entity - EQDEFLTS 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 | |||||
| IRIR | float(126) | Yes |
Right Wheelpath IRI (inches/mile). |
||||||
| DLIFE | float(126) | Yes |
Calculated Design Life. |
||||||
| EQTCR | float(126) | Yes |
Equivalent Transverse Cracks. |
||||||
| RUTVAL | float(126) | Yes |
Rutting Value in inches. |
||||||
| EQFAULT | float(126) | Yes |
Equivalent Faulting Value. |
||||||
| EQJD | float(126) | Yes |
Equivalent Joint Distress Value. |
||||||
| I_OR_O | float(126) | Yes |
Interstate=0 or Other=1. |
||||||
| DFLTDATE | date | Yes |
Date Defaults Calculated. |
||||||
| MEANIRI | float(126) | Yes | |||||||
| Columns Detail |
| Name | Value | ||
| Name | IRIR | ||
| Description |
Right Wheelpath IRI (inches/mile). |
||
| Type | float | ||
| Nullable | true | ||
| Unique | false | ||
| Primary Key | false | ||
| Index | false | ||
| Type Name | FLOAT | ||
| Length | 126 | ||
| Scale | 0 | ||
| Id Generator | native | ||
| Foreign Key | false | ||
| Generated | Unspecified | ||
| Sync To Attribute | Yes | ||
| Name | Value | ||
| Name | DLIFE | ||
| Description |
Calculated Design Life. |
||
| Type | float | ||
| Nullable | true | ||
| Unique | false | ||
| Primary Key | false | ||
| Index | false | ||
| Type Name | FLOAT | ||
| Length | 126 | ||
| Scale | 0 | ||
| Id Generator | native | ||
| Foreign Key | false | ||
| Generated | Unspecified | ||
| Sync To Attribute | Yes | ||
| Name | Value | ||
| Name | EQTCR | ||
| Description |
Equivalent Transverse Cracks. |
||
| Type | float | ||
| Nullable | true | ||
| Unique | false | ||
| Primary Key | false | ||
| Index | false | ||
| Type Name | FLOAT | ||
| Length | 126 | ||
| Scale | 0 | ||
| Id Generator | native | ||
| Foreign Key | false | ||
| Generated | Unspecified | ||
| Sync To Attribute | Yes | ||
| Name | Value | ||
| Name | RUTVAL | ||
| Description |
Rutting Value in inches. |
||
| Type | float | ||
| Nullable | true | ||
| Unique | false | ||
| Primary Key | false | ||
| Index | false | ||
| Type Name | FLOAT | ||
| Length | 126 | ||
| Scale | 0 | ||
| Id Generator | native | ||
| Foreign Key | false | ||
| Generated | Unspecified | ||
| Sync To Attribute | Yes | ||
| Name | Value | ||
| Name | EQFAULT | ||
| Description |
Equivalent Faulting Value. |
||
| Type | float | ||
| Nullable | true | ||
| Unique | false | ||
| Primary Key | false | ||
| Index | false | ||
| Type Name | FLOAT | ||
| Length | 126 | ||
| Scale | 0 | ||
| Id Generator | native | ||
| Foreign Key | false | ||
| Generated | Unspecified | ||
| Sync To Attribute | Yes | ||
| Name | Value | ||
| Name | EQJD | ||
| Description |
Equivalent Joint Distress Value. |
||
| Type | float | ||
| Nullable | true | ||
| Unique | false | ||
| Primary Key | false | ||
| Index | false | ||
| Type Name | FLOAT | ||
| Length | 126 | ||
| Scale | 0 | ||
| Id Generator | native | ||
| Foreign Key | false | ||
| Generated | Unspecified | ||
| Sync To Attribute | Yes | ||
| Name | Value | ||
| Name | I_OR_O | ||
| Description |
Interstate=0 or Other=1. |
||
| Type | float | ||
| Nullable | true | ||
| Unique | false | ||
| Primary Key | false | ||
| Index | false | ||
| Type Name | FLOAT | ||
| Length | 126 | ||
| Scale | 0 | ||
| Id Generator | native | ||
| Foreign Key | false | ||
| Generated | Unspecified | ||
| Sync To Attribute | Yes | ||
| Name | Value | ||
| Name | DFLTDATE | ||
| Description |
Date Defaults Calculated. |
||
| 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 | MEANIRI | ||
| Type | float | ||
| Nullable | true | ||
| Unique | false | ||
| Primary Key | false | ||
| Index | false | ||
| Type Name | FLOAT | ||
| Length | 126 | ||
| Scale | 0 | ||
| Id Generator | native | ||
| Foreign Key | false | ||
| Generated | Unspecified | ||
| Sync To Attribute | Yes | ||
| Appears In |
| Diagram | |||
|
|
|||