KDOT PMS Replacement Project

ERModel : Model . PMIS : Package

Entity - MPSR 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
MPSACT number(3) Yes

MPS Action Index 1-28.

PCCP number(3) Yes

PCCP Action.

COMP number(3) Yes

COMP Action.

FDBIT number(3) Yes

FDBit Action.

PDBIT number(3) Yes

PDBit Action.

Columns Detail
Name Value
Name MPSACT
Description

MPS Action Index 1-28.

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

PCCP Action.

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

COMP Action.

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

FDBit Action.

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

PDBit Action.

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

Appears In
Diagram
 KDOT_RPMS_PMISschema : Entity Relationship Diagram
KDOT PMS Replacement Project