Table slot9.WORLD.TSTA.ITEM_LOG_ENTRIES
This table stores log entries for out of service and self checkout entries for inventory items in the application or manually entered log entries
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
INSTANCE_ID number 0
ITEM_INSTANCES.INSTANCE_ID ILE_ITII_FK R
LOGIN_ID varchar2 100
IJIS_USER_PROFILES.LOGIN_ID ILE_IUP_FK R
AGENCY_CODE varchar2 30
AGENCY_CODES.AGENCY_CODE ILE_AGNCY_CD_FK R
LOG varchar2 4000  √  null
LOG_TYPE_CODE varchar2 30
EJS_CODES.CODE ILE_EJSCD_LOGTYP_FK R
LOG_TYPE_CODE_TYPE varchar2 30
EJS_CODES.CODE_TYPE ILE_EJSCD_LOGTYP_FK R
CUSTODY_EVENT_ID number 38  √  null
ITEM_CUSTODY_EVENTS.CUSTODY_EVENT_ID ILE_ICE_FK R
CREATOR_ID varchar2 100  √  null
CREATOR_DATE date 7  √  null
UPDATOR_ID varchar2 100  √  null
UPDATOR_DATE date 7  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"AGENCY_CODE" IS NOT NULL ILE_AGNCY_CD_NN
"INSTANCE_ID" IS NOT NULL ILE_INST_ID_NN
"LOG_TYPE_CODE" IS NOT NULL ILE_LOG_CD_NN
"LOG_ID" IS NOT NULL ILE_LOG_ID_NN
"LOG_TYPE_CODE_TYPE" IS NOT NULL ILE_LOG_TYP_NN
"LOGIN_ID" IS NOT NULL ILE_LOGIN_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
LOG_ID Primary key Asc ILE_PK
AGENCY_CODE Performance Asc ILE_AGNCY_CD_FK_I
LOG_TYPE_CODE_TYPE + LOG_TYPE_CODE Performance Asc/Asc ILE_EJSCD_LOGTYP_FK_I
CUSTODY_EVENT_ID Performance Asc ILE_ICE_FK_I
INSTANCE_ID Performance Asc ILE_ITII_FK_I
LOGIN_ID Performance Asc ILE_IUP_FK_I

Close relationships  within of separation: