Table slot9.WORLD.TSTA.ITEM_CUSTODIES
This table stores the new custody information for an individual inventory item that was part of a CUSTODY_EVENT change 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_ID number 0
CHAIN_OF_CUSTODIES.CUSTODY_ID Implied Constraint R
EVIDENCE_COC_MOST_RECENT_VW.CUSTODY_ID Implied Constraint R
EVIDENCE_CUSTODY_VW.CUSTODY_ID Implied Constraint R
EVIDENCE_STATUS_VW.CUSTODY_ID Implied Constraint R
ITEM_CUST_HIST_VW.CUSTODY_ID Implied Constraint R
JS_EVIDENCE_VW.CUSTODY_ID Implied Constraint R
INSTANCE_ID number 0
ITEM_INSTANCES.INSTANCE_ID ITCU_ITII_FK R
AGENCY_CODE varchar2 30
AGENCY_CODES.AGENCY_CODE ITCU_AGNCY_CD_FK R
CUSTODY_START_DATE date 7  √  null
CUSTODY_END_DATE date 7  √  null
SELF_CHECKOUT_FLAG varchar2 1  √  null
LOCATION_ID number 0  √  null
ITEM_LOCATIONS.LOCATION_ID ITCU_ITLC_FK R
SUB_LOCATION_ID number 0  √  null
ITEM_SUB_LOCATIONS.SUB_LOCATION_ID ITCU_ITSLC_FK R
ORGANIZATION_ID number 0  √  null
ITEM_ORGANIZATIONS.ORGANIZATION_ID ITCU_ITORG_FK R
EMPLOYEE_ID number 30  √  null
EMPLOYEES.EJS_EMP_ID ITCU_EMP1_FK R
OFFICER_ID number 0  √  null
OFFICERS.OFFICER_ID ITCU_OFF1_FK R
ORDER_ID number 0  √  null
ITEM_ORDERS.ORDER_ID ITCU_ITORD_FK R
CREATOR_ID varchar2 100  √  null
CREATOR_DATE date 7  √  null
UPDATOR_ID varchar2 100  √  null
UPDATOR_DATE date 7  √  null
CUSTODY_EVENT_ID number 0  √  null
ITEM_CUSTODY_EVENTS.CUSTODY_EVENT_ID ITCU_ICE_FK R
CUSTODY_TYPE_CODE varchar2 30
EJS_CODES.CODE ITCU_EJSCD_CUSTTYP_FK R
CUSTODY_TYPE_CODE_TYPE varchar2 30
EJS_CODES.CODE_TYPE ITCU_EJSCD_CUSTTYP_FK R
PARENT_INSTANCE_ID number 0  √  null
ITEM_INSTANCES.INSTANCE_ID ITCU_ITII_PI_FK R
ACTIVE_FLAG varchar2 1  √  'Y'

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
ACTIVE_FLAG IN ('Y', 'N') CK_ITCU_ACTIVE_FLAG
SELF_CHECKOUT_FLAG IN ('Y', 'N') CK_ITCU_SELF_CO_FLAG
"AGENCY_CODE" IS NOT NULL ITCU_AGENCY_CD_NN
"CUSTODY_TYPE_CODE" IS NOT NULL ITCU_CTC_NN
"CUSTODY_TYPE_CODE_TYPE" IS NOT NULL ITCU_CTCT_NN
"CUSTODY_ID" IS NOT NULL ITCU_CUST_ID_NN
"INSTANCE_ID" IS NOT NULL ITCU_INST_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
CUSTODY_ID Primary key Asc ITCU_PK
ACTIVE_FLAG Performance Asc ITCU_ACTIVE_FLAG_I
AGENCY_CODE Performance Asc ITCU_AGNCY_CD_FK_I
CUSTODY_TYPE_CODE_TYPE + CUSTODY_TYPE_CODE Performance Asc/Asc ITCU_EJSCD_CUSTTYP_FK_I
EMPLOYEE_ID Performance Asc ITCU_EMP1_FK_I
CUSTODY_EVENT_ID Performance Asc ITCU_ICE_FK_I
INSTANCE_ID Performance Asc ITCU_ITII_FK_I
PARENT_INSTANCE_ID Performance Asc ITCU_ITII_PI_FK_I
LOCATION_ID Performance Asc ITCU_ITLC_FK_I
LOCATION_ID + SUB_LOCATION_ID Performance Asc/Asc ITCU_ITLC_ITSLC_I
ORDER_ID Performance Asc ITCU_ITORD_FK_I
ORGANIZATION_ID Performance Asc ITCU_ITORG_FK_I
SUB_LOCATION_ID Performance Asc ITCU_ITSLC_FK_I
OFFICER_ID Performance Asc ITCU_OFF1_FK_I

Close relationships  within of separation: