link R-PMS Subsystem - AECOM : Package . AECOM-EPMS System : Package
Entity - FDIST link
| Properties |
| Name | Value | ||
| Data Model | Physical | ||
| Stereotypes | AECOMSystem | ||
| Schema | AECOMSchema | ||
| Primary Key Clustered | Unspecified | ||
| Unlogged | false | ||
| Temporal | false | ||
| Columns Summary |
| Column Name | Data Type | PK / FK | Nullable | Description | |||||
| EQFCR | float(0) | Yes |
Extent of equivalent-to-Code 4 fatigue cracking |
||||||
| EQTCR | float(0) | Yes |
Equivalent transverse cracking value in the same units as those defined in EPMS for the distress variable levels of the first non-roughness distress variable for asphalt pavement types. |
||||||
| FDATE | timestamp(0) | Yes |
Date of survey on which distress values are based. |
||||||
| ID | varchar2(255) | FK | No |
Foreign Key to GEOM:ID: ID=Character string that identifies the road segment. |
|||||
| RUTVAL | float(0) | Yes |
Rutting value in the same units as those defined in EPMS for the distress variable levels of the second non-roughness distress variable for asphalt pavement types. |
||||||
| Relationships Summary |
| Name | Begin | End | |||
|
|
|
|
|||
| Columns Detail |
| Name | Value | ||
| Name | EQFCR | ||
| Description |
Extent of equivalent-to-Code 4 fatigue cracking |
||
| Type | float | ||
| Nullable | true | ||
| Unique | false | ||
| Primary Key | false | ||
| Index | false | ||
| Length | 0 | ||
| Scale | 0 | ||
| Foreign Key | false | ||
| Generated | Unspecified | ||
| Sync To Attribute | Yes | ||
| Name | Value | ||
| Name | EQTCR | ||
| Description |
Equivalent transverse cracking value in the same units as those defined in EPMS for the distress variable levels of the first non-roughness distress variable for asphalt pavement types. |
||
| Type | float | ||
| Nullable | true | ||
| Unique | false | ||
| Primary Key | false | ||
| Index | false | ||
| Length | 0 | ||
| Scale | 0 | ||
| Foreign Key | false | ||
| Generated | Unspecified | ||
| Sync To Attribute | Yes | ||
| Name | Value | ||
| Name | FDATE | ||
| Description |
Date of survey on which distress values are based. |
||
| Type | timestamp | ||
| Nullable | true | ||
| Unique | false | ||
| Primary Key | false | ||
| Index | false | ||
| Length | 0 | ||
| Scale | 0 | ||
| Foreign Key | false | ||
| Generated | Unspecified | ||
| Sync To Attribute | Yes | ||
| Name | Value | ||
| Name | ID | ||
| Description |
Foreign Key to GEOM:ID: ID=Character string that identifies the road segment. |
||
| Type | varchar2 | ||
| Nullable | false | ||
| Unique | false | ||
| Primary Key | false | ||
| Index | true | ||
| Length | 255 | ||
| Scale | 0 | ||
| Foreign Key | true | ||
| Generated | Unspecified | ||
| Sync To Attribute | Yes | ||
| Name | Value | ||
| Name | RUTVAL | ||
| Description |
Rutting value in the same units as those defined in EPMS for the distress variable levels of the second non-roughness distress variable for asphalt pavement types. |
||
| Type | float | ||
| Nullable | true | ||
| Unique | false | ||
| Primary Key | false | ||
| Index | false | ||
| Length | 0 | ||
| Scale | 0 | ||
| Foreign Key | false | ||
| Generated | Unspecified | ||
| Sync To Attribute | Yes | ||
| Relationships Detail |
| Name | Value | ||||||||
| Name | |||||||||
| Foreign Key |
|
||||||||
| Primary Key |
|
||||||||
| To Multiplicity | 1 | ||||||||
| From Multiplicity | 1 | ||||||||
| Sync To Association | Yes | ||||||||
| Data Model | Physical | ||||||||
| Appears In |
| Diagram | |||
|
|
|||