KDOT PMS Replacement Project

ERModel : Model . PMIS : Package

Entity - FEATURE 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 Number in Design File.

FCODE varchar2(12) Yes

MGE-Line Code Associated with Feature.

FNAME varchar2(32) Yes

MGE-Feature Name.

CATEGORY number(10) Yes

MGE-Category Associated with Feature.

TABLENAME varchar2(18) Yes

MGE-Table Associated with Feature.

FTYPE number(5) Yes

MGE-Data Type Associated with Feature.

FLEVEL number(5) Yes

MGE-Display Level Associated with Feature.

FSTYLE number(5) Yes

MGE-Line Style Associated with Feature.

FWEIGHT number(5) Yes

MGE-Font Weight to Display Feature.

FCOLOR number(5) Yes

MGE-Color Associated with Feature.

DIGCMD varchar2(240) Yes

MGE-Command to Digitize Feature.

FELEMENT number(5) Yes

MGE-Display Element Associated with Feature.

FANGLE varchar2(16) Yes

MGE-Angle to Display Feature.

FHEIGHT number(19) Yes

MGE-Display Font Height Associated with Feature.

FWIDTH number(19) Yes

MGE-Font Width to Display Feature.

FLINESPACE number(19) Yes

MGE-Display Line Spacing Associated with Feature.

TEXTUNIT varchar2(15) Yes

MGE-Display Text Criteria.

LINELENGTH number(5) Yes

MGE-Factor to Display Feature.

FFONT number(5) Yes

MGE-Display Font Associated with Feature.

FSYMBOL varchar2(1) Yes

MGE-Symbol Associated with Feature.

FJUSTIFICATION varchar2(3) Yes

MGE-Display Justification Associated with Feature.

CELLLIBRARY varchar2(64) Yes

MGE-Cell Library Cell Found.

FCELLNAME varchar2(6) Yes

MGE-Cell Name Associated with Feature.

CELLSCALE number(19) Yes

MGE-Scale to Display Cell.

STREAMDELTA number(19) Yes

MGE-Digitizing Criteria for Feature.

STREAMTOLERANCE number(19) Yes

MGE-Digitizing Criteria for Feature.

STREAMUNIT varchar2(15) Yes

MGE-Digitizing Criteria for Feature.

SNAPTYPE number(5) Yes

MGE-Snap Criteria.

SNAPTOLERANCE number(5) Yes

MGE-Snap Criteria.

NEWDUP number(5) Yes

MGE-Duplicates Allowed?

FDASTYPE number(5) Yes

MGE-Data Type Associated with Feature.

COMP_FEATURE_ID number(10) Yes

MGE-Id Number of Feature.

USE_RANGE varchar2(1) Yes

MGE-Range Used?

IS_OPTIONAL varchar2(1) Yes

MGE-Flag.

IS_REPEATING varchar2(1) Yes

MGE-Flag.

MIN_DISPLAYSCALE number(10) Yes

MGE-Boundaries to Display Feature.

MAX_DISPLAYSCALE number(10) Yes

MGE-Boundaries to Display Feature.

DISPLAYPRIORITY number(5) Yes

MGE-Priority if Feature on Top.

Columns Detail
Name Value
Name MSLINK
Description

MGE-Mslink Number in Design File.

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

MGE-Line Code Associated with Feature.

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

Name Value
Name FNAME
Description

MGE-Feature Name.

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

Name Value
Name CATEGORY
Description

MGE-Category Associated with Feature.

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

MGE-Table Associated with Feature.

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

Name Value
Name FTYPE
Description

MGE-Data Type Associated with Feature.

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

Name Value
Name FLEVEL
Description

MGE-Display Level Associated with Feature.

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

Name Value
Name FSTYLE
Description

MGE-Line Style Associated with Feature.

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

Name Value
Name FWEIGHT
Description

MGE-Font Weight to Display Feature.

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

Name Value
Name FCOLOR
Description

MGE-Color Associated with Feature.

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

Name Value
Name DIGCMD
Description

MGE-Command to Digitize Feature.

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

MGE-Display Element Associated with Feature.

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

Name Value
Name FANGLE
Description

MGE-Angle to Display Feature.

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

Name Value
Name FHEIGHT
Description

MGE-Display Font Height Associated with Feature.

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

MGE-Font Width to Display Feature.

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

MGE-Display Line Spacing Associated with Feature.

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

MGE-Display Text Criteria.

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

Name Value
Name LINELENGTH
Description

MGE-Factor to Display Feature.

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

Name Value
Name FFONT
Description

MGE-Display Font Associated with Feature.

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

Name Value
Name FSYMBOL
Description

MGE-Symbol Associated with Feature.

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

Name Value
Name FJUSTIFICATION
Description

MGE-Display Justification Associated with Feature.

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

Name Value
Name CELLLIBRARY
Description

MGE-Cell Library Cell Found.

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

MGE-Cell Name Associated with Feature.

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

MGE-Scale to Display Cell.

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

MGE-Digitizing Criteria for Feature.

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

MGE-Digitizing Criteria for Feature.

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

MGE-Digitizing Criteria for Feature.

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

Name Value
Name SNAPTYPE
Description

MGE-Snap Criteria.

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

Name Value
Name SNAPTOLERANCE
Description

MGE-Snap Criteria.

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

Name Value
Name NEWDUP
Description

MGE-Duplicates Allowed?

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

Name Value
Name FDASTYPE
Description

MGE-Data Type Associated with Feature.

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

Name Value
Name COMP_FEATURE_ID
Description

MGE-Id Number of Feature.

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

MGE-Range Used?

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

Name Value
Name IS_OPTIONAL
Description

MGE-Flag.

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

Name Value
Name IS_REPEATING
Description

MGE-Flag.

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

Name Value
Name MIN_DISPLAYSCALE
Description

MGE-Boundaries to Display Feature.

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

MGE-Boundaries to Display Feature.

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

MGE-Priority if Feature on Top.

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

KDOT PMS Replacement Project