KDOT PMS Replacement Project

ERModel : Model . PMIS : Package

Entity - LANES 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
LANE number(1) Yes

Lane Number 0-4.

LANEDESC char(3) Yes

Lane Description ie) NL|SL.

Columns Detail
Name Value
Name LANE
Description

Lane Number 0-4.

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 LANEDESC
Description

Lane Description ie) NL|SL.

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

Appears In
Diagram
 KDOT_RPMS_PMISschema : Entity Relationship Diagram
KDOT PMS Replacement Project