KDOT PMS Replacement Project

ERModel : Model . PMIS : Package

Entity - MAPS 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
MSLINK number(10) Yes

MGE-Mslink Value in <mscatalog>.

MAPNAME varchar2(64) Yes

MGE-Design File Name.

CATEGORY number(10) Yes

MGE-Category Name.

XHIGH number(10) Yes

MGE-Range of Elements on X-Axis.

YHIGH number(10) Yes

MGE-Range of Elements on Y-Axis.

XLOW number(10) Yes

MGE-Range of Elements on X-Axis.

YLOW number(10) Yes

MGE-Range of Elements on Y-Axis.

Columns Detail
Name Value
Name MSLINK
Description

MGE-Mslink Value in <mscatalog>.

Type number
Nullable true
Unique false
Primary Key false
Index false
Length 10
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name MAPNAME
Description

MGE-Design File Name.

Type varchar2
Nullable true
Unique false
Primary Key false
Index false
Type Name VARCHAR2
Length 64
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name CATEGORY
Description

MGE-Category Name.

Type number
Nullable true
Unique false
Primary Key false
Index false
Length 10
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name XHIGH
Description

MGE-Range of Elements on X-Axis.

Type number
Nullable true
Unique false
Primary Key false
Index false
Length 10
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name YHIGH
Description

MGE-Range of Elements on Y-Axis.

Type number
Nullable true
Unique false
Primary Key false
Index false
Length 10
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name XLOW
Description

MGE-Range of Elements on X-Axis.

Type number
Nullable true
Unique false
Primary Key false
Index false
Length 10
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name YLOW
Description

MGE-Range of Elements on Y-Axis.

Type number
Nullable true
Unique false
Primary Key false
Index false
Length 10
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

KDOT PMS Replacement Project