KDOT PMS Replacement Project

ERModel : Model . PMIS : Package

Entity - REMLIFEBKUP20211201 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
ID varchar2(13) Yes
LASTACT number(19) Yes
LASTDATE date Yes
SIM_RL number(19) Yes
RL number(19) Yes
RLDATE date Yes

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

Name Value
Name LASTACT
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 LASTDATE
Type date
Nullable true
Unique false
Primary Key false
Index false
Type Name DATE
Length 0
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name SIM_RL
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 RL
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 RLDATE
Type date
Nullable true
Unique false
Primary Key false
Index false
Type Name DATE
Length 0
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

KDOT PMS Replacement Project