KDOT PMS Replacement Project

ERModel : Model . Modeling : Package

Entity - TAMP2022_TENTH28COND 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_DIST28 number(7, 3) Yes
IRI28 number(7, 1) Yes
CRK28 number(7, 1) Yes
RUT28 number(7, 3) Yes
FLT28 number(7, 3) Yes
IRI28GFP varchar2(1) Yes
CRK28GFP varchar2(1) Yes
RUT28GFP varchar2(1) Yes
FLT28GFP varchar2(1) Yes
DS28GFP varchar2(3) Yes
PL28GFP varchar2(1) Yes
BENEFIT28 number(8, 4) Yes
SCHACT27 number(0) Yes
SCNACTTYPE27 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_DIST28
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 IRI28
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 CRK28
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 RUT28
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 FLT28
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 IRI28GFP
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 CRK28GFP
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 RUT28GFP
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 FLT28GFP
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 DS28GFP
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 PL28GFP
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 BENEFIT28
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 SCHACT27
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 SCNACTTYPE27
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