KDOT PMS Replacement Project

ERModel : Model . PMIS : Package

Entity - LRS_RT_0202 link

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

Columns Summary
Column Name Data Type PK / FK Nullable Description
MSLINK number(10) Yes
MAPID number(10) Yes
LRS_KEY varchar2(19) Yes
DIRECTION varchar2(1) Yes
LANE_ID varchar2(2) Yes
COUNTY_NO number(5) Yes
CITY_NO number(5) Yes
LRS_PREFIX varchar2(1) Yes
ROUTE_ID varchar2(10) Yes
SEGMENT_ID varchar2(16) Yes
LRS_SUFFIX varchar2(1) Yes
UNIQUE_ID varchar2(1) Yes
ADMIN_OWNER varchar2(1) Yes
LRS_SUBCLASS varchar2(1) Yes
BEG_CNTY_LOGMILE number(19) Yes
END_CNTY_LOGMILE number(19) Yes
BEG_STATE_LOGMILE number(19) Yes
END_STATE_LOGMILE number(19) Yes
BEG_CNTY_LOGKILO number(19) Yes
END_CNTY_LOGKILO number(19) Yes
BEG_STATE_LOGKILO number(19) Yes
END_STATE_LOGKILO number(19) Yes
BEG_REFPOST varchar2(3) Yes
BEG_REFPOST_OFFSET number(5) Yes
END_REFPOST varchar2(3) Yes
END_REFPOST_OFFSET number(5) Yes
BEG_LONGITUDE varchar2(11) Yes
BEG_LATITUDE varchar2(10) Yes
END_LONGITUDE varchar2(11) Yes
END_LATITUDE varchar2(10) Yes
COUNTY_CODE varchar2(3) Yes
CNTY_ABBREVIATION varchar2(2) Yes
DISTRICT_NO number(5) Yes
INTCHG_CODE varchar2(1) Yes
INTCHG_NO varchar2(3) Yes
INTCHG_ONOFF varchar2(1) Yes
STATUS_1 number(10) Yes
STATUS_2 number(10) Yes
STATUS_3 number(10) Yes

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

KDOT PMS Replacement Project