link ERModel : Model . PMIS : Package
Entity - LAZRUT 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 | |||||
| ID | char(13) | Yes |
PMS ID (based on first seven fields). |
||||||
| FDIR | varchar2(6) | Yes |
Direction of travel. |
||||||
| FDATE | date | Yes |
Profile Survey DATE. |
||||||
| FTIME | number(4) | Yes |
Profile Survey TIME. |
||||||
| RUT | number(2) | Yes |
Two digit rut code. (avg:max). |
||||||
| RUTVAL | number(4, 2) | Yes |
Actual average rutting value. |
||||||
| FNOTE | varchar2(8) | Yes |
Denotes profiler used e.g. laser. |
||||||
| Columns Detail |
| 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 | FDIR | ||
| Description |
Direction of travel. |
||
| Type | varchar2 | ||
| Nullable | true | ||
| Unique | false | ||
| Primary Key | false | ||
| Index | false | ||
| Type Name | VARCHAR2 | ||
| Length | 6 | ||
| Scale | 0 | ||
| Id Generator | native | ||
| Foreign Key | false | ||
| Generated | Unspecified | ||
| Sync To Attribute | Yes | ||
| Name | Value | ||
| Name | FDATE | ||
| Description |
Profile 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 | FTIME | ||
| Description |
Profile Survey TIME. |
||
| Type | number | ||
| Nullable | true | ||
| Unique | false | ||
| Primary Key | false | ||
| Index | false | ||
| Type Name | NUMBER | ||
| Length | 4 | ||
| Scale | 0 | ||
| Id Generator | native | ||
| Foreign Key | false | ||
| Generated | Unspecified | ||
| Sync To Attribute | Yes | ||
| Name | Value | ||
| Name | RUT | ||
| Description |
Two digit rut code. (avg:max). |
||
| 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 | RUTVAL | ||
| Description |
Actual average rutting value. |
||
| 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 | FNOTE | ||
| Description |
Denotes profiler used e.g. laser. |
||
| Type | varchar2 | ||
| Nullable | true | ||
| Unique | false | ||
| Primary Key | false | ||
| Index | false | ||
| Type Name | VARCHAR2 | ||
| Length | 8 | ||
| Scale | 0 | ||
| Id Generator | native | ||
| Foreign Key | false | ||
| Generated | Unspecified | ||
| Sync To Attribute | Yes | ||
| Appears In |
| Diagram | |||
|
|
|||