KDOT PMS Replacement Project

ERModel : Model . Modeling : Package

Entity - GFPBYATR 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
ID number(0) Yes
ATR varchar2(5) Yes
BOW varchar2(3) Yes
RANGEFLOOR number(8, 4) Yes
GFP varchar2(2) Yes
RANGETOP number(8, 4) Yes

Columns Detail
Name Value
Name ID
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 ATR
Type varchar2
Nullable true
Unique false
Primary Key false
Index false
Type Name varchar
Length 5
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name BOW
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 RANGEFLOOR
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 GFP
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 RANGETOP
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

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