KDOT PMS Replacement Project

ERModel : Model . PMIS : Package

Entity - RI05_T01 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
SCHEMA_NAME varchar2(31) Yes

RIS Schema Name.

SCHEMA_PASSWORD varchar2(37) Yes

RIS Schema Password.

SCHEMA_OWNER varchar2(31) Yes

Owner of RIS Schema.

SCHEMA_TYPE number(10) Yes

RIS Schema Type Code.

Columns Detail
Name Value
Name SCHEMA_NAME
Description

RIS Schema Name.

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

Name Value
Name SCHEMA_PASSWORD
Description

RIS Schema Password.

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

Name Value
Name SCHEMA_OWNER
Description

Owner of RIS Schema.

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

Name Value
Name SCHEMA_TYPE
Description

RIS Schema Type Code.

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