Table slot9.WORLD.TSTA.ITEM_CUSTODY_EVENTS
This table stores the event information for a selection of inventory items changing custody done in the application
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
CUSTODY_EVENT_ID number 0
ITEM_CUST_HIST_VW.CUSTODY_EVENT_ID Implied Constraint R
ITEM_CUSTODIES.CUSTODY_EVENT_ID ITCU_ICE_FK R
ITEM_INST_CUSTODY_DESC_VW.CUSTODY_EVENT_ID Implied Constraint R
ITEM_INST_CUSTODY_VW.CUSTODY_EVENT_ID Implied Constraint R
ITEM_INSTANCES.CUSTODY_EVENT_ID ITII_ICE_FK R
ITEM_LOG_ENTRIES.CUSTODY_EVENT_ID ILE_ICE_FK R
AGENCY_CODE varchar2 30
AGENCY_CODES.AGENCY_CODE ICE_AGNCY_CD_FK R
NOTES varchar2 200  √  null
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 ICE_AGNCY_CD_NN
"CUSTODY_EVENT_ID" IS NOT NULL ICE_EVENT_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
CUSTODY_EVENT_ID Primary key Asc ICE_PK
AGENCY_CODE Performance Asc ICE_AGNCY_CD_FK_I

Close relationships  within of separation: