link ERModel : Model . Modeling : Package
Entity - NUMLANES link
| Properties |
| Name | Value | ||
| Data Model | Physical | ||
| Schema | dbo | ||
| Primary Key Clustered | Unspecified | ||
| Unlogged | false | ||
| Temporal | false | ||
| Columns Summary |
| Column Name | Data Type | PK / FK | Nullable | Description | |||||
| MPBEG | number(9, 3) | Yes | |||||||
| MPEND | number(9, 3) | Yes | |||||||
| LRSKEY | varchar2(22) | Yes | |||||||
| DIV_DIR | varchar2(2) | Yes | |||||||
| MNTR | number(0) | Yes | |||||||
| ROUTE | varchar2(22) | Yes | |||||||
| LGTH | number(9, 3) | Yes | |||||||
| UN_DIV | varchar2(2) | Yes | |||||||
| PMID | varchar2(13) | Yes | |||||||
| NHS | number(0) | Yes | |||||||
| HPMS | varchar2(22) | Yes | |||||||
| CITY | number(0) | Yes | |||||||
| LNCL | number(0) | Yes | |||||||
| NUMLANES | number(0) | Yes | |||||||
| Columns Detail |
| Name | Value | ||
| Name | MPBEG | ||
| Type | number | ||
| Nullable | true | ||
| Unique | false | ||
| Primary Key | false | ||
| Index | false | ||
| Type Name | decimal | ||
| Length | 9 | ||
| Scale | 3 | ||
| Id Generator | native | ||
| Foreign Key | false | ||
| Generated | Unspecified | ||
| Sync To Attribute | Yes | ||
| Name | Value | ||
| Name | MPEND | ||
| Type | number | ||
| Nullable | true | ||
| Unique | false | ||
| Primary Key | false | ||
| Index | false | ||
| Type Name | decimal | ||
| Length | 9 | ||
| Scale | 3 | ||
| Id Generator | native | ||
| Foreign Key | false | ||
| Generated | Unspecified | ||
| Sync To Attribute | Yes | ||
| Name | Value | ||
| Name | LRSKEY | ||
| Type | varchar2 | ||
| Nullable | true | ||
| Unique | false | ||
| Primary Key | false | ||
| Index | false | ||
| Type Name | varchar | ||
| Length | 22 | ||
| Scale | 0 | ||
| Id Generator | native | ||
| Foreign Key | false | ||
| Generated | Unspecified | ||
| Sync To Attribute | Yes | ||
| Name | Value | ||
| Name | DIV_DIR | ||
| Type | varchar2 | ||
| Nullable | true | ||
| Unique | false | ||
| Primary Key | false | ||
| Index | false | ||
| Type Name | varchar | ||
| Length | 2 | ||
| Scale | 0 | ||
| Id Generator | native | ||
| Foreign Key | false | ||
| Generated | Unspecified | ||
| Sync To Attribute | Yes | ||
| Name | Value | ||
| Name | MNTR | ||
| Type | number | ||
| Nullable | true | ||
| Unique | false | ||
| Primary Key | false | ||
| Index | false | ||
| Type Name | smallint | ||
| Length | 0 | ||
| Scale | 0 | ||
| Id Generator | native | ||
| Foreign Key | false | ||
| Generated | Unspecified | ||
| Sync To Attribute | Yes | ||
| Name | Value | ||
| Name | ROUTE | ||
| Type | varchar2 | ||
| Nullable | true | ||
| Unique | false | ||
| Primary Key | false | ||
| Index | false | ||
| Type Name | varchar | ||
| Length | 22 | ||
| Scale | 0 | ||
| Id Generator | native | ||
| Foreign Key | false | ||
| Generated | Unspecified | ||
| Sync To Attribute | Yes | ||
| Name | Value | ||
| Name | LGTH | ||
| Type | number | ||
| Nullable | true | ||
| Unique | false | ||
| Primary Key | false | ||
| Index | false | ||
| Type Name | decimal | ||
| Length | 9 | ||
| Scale | 3 | ||
| Id Generator | native | ||
| Foreign Key | false | ||
| Generated | Unspecified | ||
| Sync To Attribute | Yes | ||
| Name | Value | ||
| Name | UN_DIV | ||
| Type | varchar2 | ||
| Nullable | true | ||
| Unique | false | ||
| Primary Key | false | ||
| Index | false | ||
| Type Name | varchar | ||
| Length | 2 | ||
| Scale | 0 | ||
| Id Generator | native | ||
| Foreign Key | false | ||
| Generated | Unspecified | ||
| Sync To Attribute | Yes | ||
| Name | Value | ||
| Name | PMID | ||
| Type | varchar2 | ||
| Nullable | true | ||
| Unique | false | ||
| Primary Key | false | ||
| Index | false | ||
| Type Name | varchar | ||
| Length | 13 | ||
| Scale | 0 | ||
| Id Generator | native | ||
| Foreign Key | false | ||
| Generated | Unspecified | ||
| Sync To Attribute | Yes | ||
| Name | Value | ||
| Name | NHS | ||
| Type | number | ||
| Nullable | true | ||
| Unique | false | ||
| Primary Key | false | ||
| Index | false | ||
| Type Name | smallint | ||
| Length | 0 | ||
| Scale | 0 | ||
| Id Generator | native | ||
| Foreign Key | false | ||
| Generated | Unspecified | ||
| Sync To Attribute | Yes | ||
| Name | Value | ||
| Name | HPMS | ||
| Type | varchar2 | ||
| Nullable | true | ||
| Unique | false | ||
| Primary Key | false | ||
| Index | false | ||
| Type Name | varchar | ||
| Length | 22 | ||
| Scale | 0 | ||
| Id Generator | native | ||
| Foreign Key | false | ||
| Generated | Unspecified | ||
| Sync To Attribute | Yes | ||
| Name | Value | ||
| Name | CITY | ||
| Type | number | ||
| Nullable | true | ||
| Unique | false | ||
| Primary Key | false | ||
| Index | false | ||
| Type Name | smallint | ||
| Length | 0 | ||
| Scale | 0 | ||
| Id Generator | native | ||
| Foreign Key | false | ||
| Generated | Unspecified | ||
| Sync To Attribute | Yes | ||
| Name | Value | ||
| Name | LNCL | ||
| Type | number | ||
| Nullable | true | ||
| Unique | false | ||
| Primary Key | false | ||
| Index | false | ||
| Type Name | smallint | ||
| Length | 0 | ||
| Scale | 0 | ||
| Id Generator | native | ||
| Foreign Key | false | ||
| Generated | Unspecified | ||
| Sync To Attribute | Yes | ||
| Name | Value | ||
| Name | NUMLANES | ||
| Type | number | ||
| Nullable | true | ||
| Unique | false | ||
| Primary Key | false | ||
| Index | false | ||
| Type Name | smallint | ||
| Length | 0 | ||
| Scale | 0 | ||
| Id Generator | native | ||
| Foreign Key | false | ||
| Generated | Unspecified | ||
| Sync To Attribute | Yes | ||
| Appears In |
| Diagram | |||
|
|
|||