KDOT PMS Replacement Project

ERModel : Model . PMIS : Package

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

------------------------

DOMAINVALUE varchar2(8) Yes

MGE-Data Type of Domain.

DOMAINDESC varchar2(32) Yes

MGE-Description of the Domain.

Columns Detail
Name Value
Name LDOMAIN
Description

------------------------

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

MGE-Data Type of Domain.

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

Name Value
Name DOMAINDESC
Description

MGE-Description of the Domain.

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

KDOT PMS Replacement Project