Table slot9.WORLD.TSTA.EMULATION_HISTORY
This table stores the history of the emulation users for the RMS
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
HISTORY_ID number 0 Unique Emulation History ID, Primary Key
EMULATING_LOGIN_ID varchar2 100 Emulating User Login ID
EMULATED_LOGIN_ID varchar2 100 Emulated User Login Id
START_DATE date 7 Start Date and Time of User Emulation
END_DATE date 7  √  null End Date and Time of User Emulation
CREATOR_DATE date 7  √  null Date and Time of record creation
CREATOR_ID varchar2 100  √  null Login Id of user creating the initial record
UPDATOR_DATE date 7  √  null Date and Time of last update of record
UPDATOR_ID varchar2 100  √  null Login ID of last update of record
REC_ID number 0  √  null Unique Record ID of RMS Record

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"EMULATED_LOGIN_ID" IS NOT NULL EMUH_EMULATED_USER_NN
"EMULATING_LOGIN_ID" IS NOT NULL EMUH_EMULATING_USER_NN
"HISTORY_ID" IS NOT NULL EMUH_HISTORY_ID_NN
"START_DATE" IS NOT NULL EMUH_START_DATE_NN

Indexes:
Column(s) Type Sort Constraint Name
HISTORY_ID Primary key Asc EMUH_PK