link ERModel : Model . PMIS : Package
Entity - FWDDEFLT 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 | |||||
| SUMLEV | number(1) | Yes |
Level of resolution at which stats calculated: 1 - have fwd on segment 2 - fwd in county on rdcat 3 - fwd in county on pavetype 4 - fwd on rdcat 5 - fwd on pavetype |
||||||
| ID | varchar2(13) | Yes |
PMS id |
||||||
| FWDDATE | varchar2(11) | Yes |
Date data collected |
||||||
| COUNTY | number(3) | Yes |
County number |
||||||
| RDCAT | number(2) | Yes |
Road category |
||||||
| PVMTGRP | number(1) | Yes |
1=PC 2=COMP 3=FD 4=PD |
||||||
| CALCDATE | date | Yes |
Date max,min and avgd6 calculated |
||||||
| AVED6 | number(7, 3) | Yes |
Avg. reading from last of 7 sensors |
||||||
| MIND6 | number(7, 3) | Yes |
Min reading from last of 7 sensors |
||||||
| MAXD6 | number(7, 3) | Yes |
Max reading from last of 7 sensors |
||||||
| ND6 | number(6) | Yes |
Number of d6 readings used to calc. stats |
||||||
| STDVD6 | number(7, 3) | Yes |
Std. Dev. of all d6 readings |
||||||
| Columns Detail |
| Name | Value | ||
| Name | SUMLEV | ||
| Description |
Level of resolution at which stats calculated: 1 - have fwd on segment 2 - fwd in county on rdcat 3 - fwd in county on pavetype 4 - fwd on rdcat 5 - fwd on pavetype |
||
| Default Value | 0 | ||
| 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 |
||
| Default Value | 0 | ||
| Type | varchar2 | ||
| Nullable | true | ||
| Unique | false | ||
| Primary Key | false | ||
| Index | false | ||
| Type Name | VARCHAR2 | ||
| Length | 13 | ||
| Scale | 0 | ||
| Id Generator | native | ||
| Foreign Key | false | ||
| Generated | Unspecified | ||
| Sync To Attribute | Yes | ||
| Name | Value | ||
| Name | FWDDATE | ||
| Description |
Date data collected |
||
| Default Value | 0 | ||
| Type | varchar2 | ||
| Nullable | true | ||
| Unique | false | ||
| Primary Key | false | ||
| Index | false | ||
| Type Name | VARCHAR2 | ||
| Length | 11 | ||
| Scale | 0 | ||
| Id Generator | native | ||
| Foreign Key | false | ||
| Generated | Unspecified | ||
| Sync To Attribute | Yes | ||
| Name | Value | ||
| Name | COUNTY | ||
| Description |
County number |
||
| Default Value | 0 | ||
| 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 | RDCAT | ||
| Description |
Road category |
||
| Default Value | 0 | ||
| 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 | PVMTGRP | ||
| Description |
1=PC 2=COMP 3=FD 4=PD |
||
| Default Value | 0 | ||
| 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 | CALCDATE | ||
| Description |
Date max,min and avgd6 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 | AVED6 | ||
| Description |
Avg. reading from last of 7 sensors |
||
| 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 | ||
| Name | Value | ||
| Name | MIND6 | ||
| Description |
Min reading from last of 7 sensors |
||
| 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 | ||
| Name | Value | ||
| Name | MAXD6 | ||
| Description |
Max reading from last of 7 sensors |
||
| 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 | ||
| Name | Value | ||
| Name | ND6 | ||
| Description |
Number of d6 readings used to calc. stats |
||
| Type | number | ||
| Nullable | true | ||
| Unique | false | ||
| Primary Key | false | ||
| Index | false | ||
| Length | 6 | ||
| Scale | 0 | ||
| Id Generator | native | ||
| Foreign Key | false | ||
| Generated | Unspecified | ||
| Sync To Attribute | Yes | ||
| Name | Value | ||
| Name | STDVD6 | ||
| Description |
Std. Dev. of all d6 readings |
||
| 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 | ||
| Appears In |
| Diagram | |||
|
|
|||