KDOT PMS Replacement Project

ERModel : Model . PMIS : Package

Entity - RI05_T07 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
SERVER_PID number(10) Yes

Process ID of RIS Schema in Use.

SCHEMA_NAME varchar2(31) Yes

RIS Schema Name.

SCHEMA_USER varchar2(31) Yes

RIS Schema User.

Columns Detail
Name Value
Name SERVER_PID
Description

Process ID of RIS Schema in Use.

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

RIS Schema User.

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

KDOT PMS Replacement Project