KDOT PMS Replacement Project

ERModel : Model . Modeling : Package

Entity - MAINTRESP link

Properties
Name Value
Data Model Physical
Schema dbo
Primary Key Clustered Unspecified
Unlogged false
Temporal false

Columns Summary
Column Name Data Type PK / FK Nullable Description
MPBEG number(9, 3) Yes
MPEND number(9, 3) Yes
LRSKEY varchar2(22) Yes
DIV_DIR varchar2(2) Yes
MNTR number(0) Yes

Columns Detail
Name Value
Name MPBEG
Type number
Nullable true
Unique false
Primary Key false
Index false
Type Name decimal
Length 9
Scale 3
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name MPEND
Type number
Nullable true
Unique false
Primary Key false
Index false
Type Name decimal
Length 9
Scale 3
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name LRSKEY
Type varchar2
Nullable true
Unique false
Primary Key false
Index false
Type Name varchar
Length 22
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name DIV_DIR
Type varchar2
Nullable true
Unique false
Primary Key false
Index false
Type Name varchar
Length 2
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

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

Appears In
Diagram
 KDOT_RPMS_Modeling(Reduced) : Entity Relationship Diagram
KDOT PMS Replacement Project