Table slot9.WORLD.TSTA.MASTER_INDEX_DELETE_LOG
This table logs master index records that have been deleted.
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
LOG_ID number 0
CP_PAYMENT_PARTIES_LOG.LOG_ID Implied Constraint R
PK - Unique identifier for each delete log record.
MASTER_INDEX_ID number 0 The original ID for the deleted master index.
INDEX_DETAILS varchar2 4000  √  null Main detais from the deleted master index record stored as a string.
DELETE_COMMENTS varchar2 4000  √  null Reason for the delete as entered by user.
RECORD_CREATOR_ID varchar2 100  √  null User ID for the creator of the original master index record.
RECORD_CREATOR_DATE date 7  √  null Date the original master index record was created.
RECORD_DELETOR_ID varchar2 100  √  null User ID for the person who deleted the master index record.
RECORD_DELETOR_DATE date 7  √  null Date the master index record was deleted.
REC_ID number 0  √  null
MI_TYPE varchar2 30  √  null Type of master index record deleted.

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"LOG_ID" IS NOT NULL MIDELLOG_LOGID_NN
"MASTER_INDEX_ID" IS NOT NULL MIDELLOG_MIID_NN

Indexes:
Column(s) Type Sort Constraint Name
LOG_ID Primary key Asc MIDELLOG_PK
INDEX_DETAILS Performance Asc MIDELLOG_INDEX_DETAILS_I
MASTER_INDEX_ID Performance Asc MIDELLOG_MASTER_INDEX_ID_I
RECORD_CREATOR_ID Performance Asc MIDELLOG_RECORD_CREATOR_ID_I
RECORD_DELETOR_ID Performance Asc MIDELLOG_RECORD_DELETOR_ID_I

Close relationships: