KDOT PMS Replacement Project

ERModel : Model . Modeling : Package

Entity - TAMP2022_TENTH25OLDCOND 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
LRS_TENTH_LANE varchar2(17) Yes
PMSID varchar2(13) Yes
PAVEMENTTYP varchar2(20) Yes
LW_DIST25 number(7, 3) Yes
IRI25 number(7, 1) Yes
CRK25 number(7, 1) Yes
RUT25 number(7, 3) Yes
FLT25 number(7, 3) Yes
IRI25GFP varchar2(1) Yes
CRK25GFP varchar2(1) Yes
RUT25GFP varchar2(1) Yes
FLT25GFP varchar2(1) Yes
DS25GFP varchar2(3) Yes
PL25GFP varchar2(1) Yes
BENEFIT25 number(8, 4) Yes
SCHACT24 number(0) Yes
SCNACTTYPE24 varchar2(3) Yes

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Name Value
Name SCHACT24
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

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

KDOT PMS Replacement Project