link ERModel : Model . PMIS : Package
Entity - PMMAPPING 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 | |||||
| PMMINDEX | number(8) | Yes |
PMindex. |
||||||
| PMCOUNTY | number(3) | Yes |
County number. |
||||||
| PMRTNO | number(3) | Yes |
Route number. |
||||||
| PMCODE | number(1) | Yes | |||||||
| PMDRCTN | number(1) | Yes |
Direction: 1,2,3 or 4. |
||||||
| PMMILEAGE_BEGIN | number(8, 4) | Yes |
Beginning mileage. |
||||||
| PMMILEAGE_END | number(8, 4) | Yes |
Ending mileage. |
||||||
| PMDATE_BEGIN | number(13, 7) | Yes |
Beginning date. |
||||||
| PMDATE_END | number(13, 7) | Yes |
Ending date. |
||||||
| GMAINDEX | number(8) | Yes |
Aindex. |
||||||
| GMFRAGMENT | number(1) | Yes |
Fragment number. |
||||||
| GMDIRECTION | number(1) | Yes |
Logical direction. |
||||||
| SEQUENCE | number(1) | Yes |
Sequence number. |
||||||
| CODE_BEGIN | number(2) | Yes |
Initialization code (Beginning code). |
||||||
| CODE_END | number(2) | Yes |
Termination code (Ending code). |
||||||
| CODE_DRCTN | number(2) | Yes |
Directionality code. |
||||||
| INFO_BEGIN | number(14, 4) | Yes |
Beginning code data. |
||||||
| INFO_END | number(14, 4) | Yes |
Ending code data. |
||||||
| INFO_DRCTN | number(14, 4) | Yes |
Directionality info. |
||||||
| DATE_LOADED | number(13, 7) | Yes |
Last date loaded to the database. |
||||||
| Columns Detail |
| Name | Value | ||
| Name | PMMINDEX | ||
| Description |
PMindex. |
||
| Type | number | ||
| Nullable | true | ||
| Unique | false | ||
| Primary Key | false | ||
| Index | false | ||
| Length | 8 | ||
| Scale | 0 | ||
| Id Generator | native | ||
| Foreign Key | false | ||
| Generated | Unspecified | ||
| Sync To Attribute | Yes | ||
| Name | Value | ||
| Name | PMCOUNTY | ||
| Description |
County number. |
||
| 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 | PMRTNO | ||
| Description |
Route number. |
||
| 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 | PMCODE | ||
| 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 | PMDRCTN | ||
| Description |
Direction: 1,2,3 or 4. |
||
| 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 | PMMILEAGE_BEGIN | ||
| Description |
Beginning mileage. |
||
| Type | number | ||
| Nullable | true | ||
| Unique | false | ||
| Primary Key | false | ||
| Index | false | ||
| Type Name | NUMBER | ||
| Length | 8 | ||
| Scale | 4 | ||
| Id Generator | native | ||
| Foreign Key | false | ||
| Generated | Unspecified | ||
| Sync To Attribute | Yes | ||
| Name | Value | ||
| Name | PMMILEAGE_END | ||
| Description |
Ending mileage. |
||
| Type | number | ||
| Nullable | true | ||
| Unique | false | ||
| Primary Key | false | ||
| Index | false | ||
| Type Name | NUMBER | ||
| Length | 8 | ||
| Scale | 4 | ||
| Id Generator | native | ||
| Foreign Key | false | ||
| Generated | Unspecified | ||
| Sync To Attribute | Yes | ||
| Name | Value | ||
| Name | PMDATE_BEGIN | ||
| Description |
Beginning date. |
||
| Type | number | ||
| Nullable | true | ||
| Unique | false | ||
| Primary Key | false | ||
| Index | false | ||
| Type Name | NUMBER | ||
| Length | 13 | ||
| Scale | 7 | ||
| Id Generator | native | ||
| Foreign Key | false | ||
| Generated | Unspecified | ||
| Sync To Attribute | Yes | ||
| Name | Value | ||
| Name | PMDATE_END | ||
| Description |
Ending date. |
||
| Type | number | ||
| Nullable | true | ||
| Unique | false | ||
| Primary Key | false | ||
| Index | false | ||
| Type Name | NUMBER | ||
| Length | 13 | ||
| Scale | 7 | ||
| Id Generator | native | ||
| Foreign Key | false | ||
| Generated | Unspecified | ||
| Sync To Attribute | Yes | ||
| Name | Value | ||
| Name | GMAINDEX | ||
| Description |
Aindex. |
||
| Type | number | ||
| Nullable | true | ||
| Unique | false | ||
| Primary Key | false | ||
| Index | false | ||
| Length | 8 | ||
| Scale | 0 | ||
| Id Generator | native | ||
| Foreign Key | false | ||
| Generated | Unspecified | ||
| Sync To Attribute | Yes | ||
| Name | Value | ||
| Name | GMFRAGMENT | ||
| Description |
Fragment number. |
||
| 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 | GMDIRECTION | ||
| Description |
Logical direction. |
||
| 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 | SEQUENCE | ||
| Description |
Sequence number. |
||
| 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 | CODE_BEGIN | ||
| Description |
Initialization code (Beginning code). |
||
| 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 | CODE_END | ||
| Description |
Termination code (Ending code). |
||
| 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 | CODE_DRCTN | ||
| Description |
Directionality code. |
||
| 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 | INFO_BEGIN | ||
| Description |
Beginning code data. |
||
| Type | number | ||
| Nullable | true | ||
| Unique | false | ||
| Primary Key | false | ||
| Index | false | ||
| Type Name | NUMBER | ||
| Length | 14 | ||
| Scale | 4 | ||
| Id Generator | native | ||
| Foreign Key | false | ||
| Generated | Unspecified | ||
| Sync To Attribute | Yes | ||
| Name | Value | ||
| Name | INFO_END | ||
| Description |
Ending code data. |
||
| Type | number | ||
| Nullable | true | ||
| Unique | false | ||
| Primary Key | false | ||
| Index | false | ||
| Type Name | NUMBER | ||
| Length | 14 | ||
| Scale | 4 | ||
| Id Generator | native | ||
| Foreign Key | false | ||
| Generated | Unspecified | ||
| Sync To Attribute | Yes | ||
| Name | Value | ||
| Name | INFO_DRCTN | ||
| Description |
Directionality info. |
||
| Type | number | ||
| Nullable | true | ||
| Unique | false | ||
| Primary Key | false | ||
| Index | false | ||
| Type Name | NUMBER | ||
| Length | 14 | ||
| Scale | 4 | ||
| Id Generator | native | ||
| Foreign Key | false | ||
| Generated | Unspecified | ||
| Sync To Attribute | Yes | ||
| Name | Value | ||
| Name | DATE_LOADED | ||
| Description |
Last date loaded to the database. |
||
| Default Value | 0 | ||
| Type | number | ||
| Nullable | true | ||
| Unique | false | ||
| Primary Key | false | ||
| Index | false | ||
| Type Name | NUMBER | ||
| Length | 13 | ||
| Scale | 7 | ||
| Id Generator | native | ||
| Foreign Key | false | ||
| Generated | Unspecified | ||
| Sync To Attribute | Yes | ||