Table slot9.WORLD.TSTA.ITEM_LOCATIONS
This table defines the valid locations that can be assigned to an inventory item 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
LOCATION_ID number 0
ITEM_CUST_HIST_VW.LOCATION_ID Implied Constraint R
ITEM_CUSTODIES.LOCATION_ID ITCU_ITLC_FK R
ITEM_DESCRIPTOR_LOCATIONS.LOCATION_ID IDL_ITLC_FK R
ITEM_INSPECTION_ITEMS.LOCATION_ID ITINSPI_ITLC_FK R
ITEM_INST_CUSTODY_DESC_VW.LOCATION_ID Implied Constraint R
ITEM_INST_CUSTODY_VW.LOCATION_ID Implied Constraint R
ITEM_INST_ENT_ROLLUP_VW.LOCATION_ID Implied Constraint R
ITEM_INST_ROLLUP_VW.LOCATION_ID Implied Constraint R
ITEM_INSTANCES.LAST_LOCATION_ID ITII_ITLC_LLOC_FK R
ITEM_INSTANCES.LAST_WAREHOUSE_ID ITII_ITLC_LW_FK R
ITEM_INSTANCES.LOCATION_ID ITII_ITLC_FK R
ITEM_LOCATION_MANAGERS.LOCATION_ID ITLCM_ITLC_FK R
ITEM_SUB_LOCATIONS.LOCATION_ID ITSLC_ITLC_FK R
PROPERTY_HOLD_SEARCH_VW.LOCATION_ID Implied Constraint R
DESCRIPTION varchar2 255
AGENCY_CODE varchar2 30
AGENCY_CODES.AGENCY_CODE ITLC_AGNCY_CD_FK R
SELF_CHECKOUT_FLAG varchar2 1  √  'N'
CREATOR_ID varchar2 100  √  null
CREATOR_DATE date 7  √  null
UPDATOR_ID varchar2 100  √  null
UPDATOR_DATE date 7  √  null
LOC_TYPE_CODE varchar2 30
EJS_CODES.CODE ITLC_EJSCD_LOC_FK R
LOC_TYPE_CODE_TYPE varchar2 30
EJS_CODES.CODE_TYPE ITLC_EJSCD_LOC_FK R

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
SELF_CHECKOUT_FLAG IN ('Y', 'N') CK_ITLC_SELF_CO_FLAG
"AGENCY_CODE" IS NOT NULL ITLC_AGNCY_CD_NN
"DESCRIPTION" IS NOT NULL ITLC_DESCRIPTION_NN
"LOC_TYPE_CODE" IS NOT NULL ITLC_LOC_TYPE_CD_NN
"LOC_TYPE_CODE_TYPE" IS NOT NULL ITLC_LOC_TYPE_CD_TP_NN
"LOCATION_ID" IS NOT NULL ITLC_LOCATION_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
LOCATION_ID Primary key Asc ITLC_PK
AGENCY_CODE Performance Asc ITLC_AGNCY_CD_FK_I
LOC_TYPE_CODE_TYPE + LOC_TYPE_CODE Performance Asc/Asc ITLC_EJSCD_LOC_FK_I

Close relationships  within of separation: