KDOT PMS Replacement Project

ERModel : Model . RVEXPLORE : Package

Entity - GPS_TABLE2BKUP20211130 link

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

Columns Summary
Column Name Data Type PK / FK Nullable Description
LONGITUDE number(10, 7) Yes
LATITUDE number(9, 7) Yes
ALTITUDE number(9, 4) Yes
FRAME number(1) Yes
GPS_TIME char(30) Yes
SESSION_NAME char(20) Yes
CYCLE char(15) Yes

Columns Detail
Name Value
Name LONGITUDE
Type number
Nullable true
Unique false
Primary Key false
Index false
Type Name NUMBER
Length 10
Scale 7
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

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

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

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

Name Value
Name GPS_TIME
Type char
Nullable true
Unique false
Primary Key false
Index false
Type Name CHAR
Length 30
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

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

Name Value
Name CYCLE
Type char
Nullable true
Unique false
Primary Key false
Index false
Type Name CHAR
Length 15
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

KDOT PMS Replacement Project