KDOT PMS Replacement Project

ERModel : Model . PMIS : Package

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

MGE-Label (Text).

CONTENTSTMT varchar2(240) Yes

MGE-Description of Label.

X_OFFSET number(19) Yes

MGE- X-Offset to Display Label.

Y_OFFSET number(19) Yes

MGE- Y-Offset to Display Label.

Columns Detail
Name Value
Name LABEL
Description

MGE-Label (Text).

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 CONTENTSTMT
Description

MGE-Description of Label.

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

Name Value
Name X_OFFSET
Description

MGE- X-Offset to Display Label.

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

Name Value
Name Y_OFFSET
Description

MGE- Y-Offset to Display Label.

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

KDOT PMS Replacement Project