Table slot9.WORLD.TSTA.ITEM_INSTANCES
This table stores the individual inventory items added 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
INSTANCE_ID number 0
ITEM_CUST_HIST_VW.INSTANCE_ID Implied Constraint R
ITEM_CUSTODIES.INSTANCE_ID ITCU_ITII_FK R
ITEM_CUSTODIES.PARENT_INSTANCE_ID ITCU_ITII_PI_FK R
ITEM_ENTRY_INSTANCES.INSTANCE_ID ITENTIN_ITII_FK C
ITEM_INST_CUSTODY_DESC_VW.INSTANCE_ID Implied Constraint R
ITEM_INST_CUSTODY_VW.INSTANCE_ID Implied Constraint R
ITEM_INSTANCES.PARENT_INSTANCE_ID ITII_ITII_FK R
ITEM_LOG_ENTRIES.INSTANCE_ID ILE_ITII_FK R
ITEM_LOG_VW.INSTANCE_ID Implied Constraint R
REPORT_PARAMETER_INSTANCES.INSTANCE_ID Implied Constraint R
USER_SCREEN_INSTANCE_DELETE.INSTANCE_ID Implied Constraint R
DESCRIPTOR_ID number 0
ITEM_DESCRIPTORS.DESCRIPTOR_ID ITII_ITDS_FK R
ORDER_ID number 0  √  null
ITEM_ORDERS.ORDER_ID ITII_ITORD_FK R
STATUS_CODE varchar2 30
EJS_CODES.CODE ITII_EJSCD_STAT_CD_FK R
STATUS_CODE_TYPE varchar2 30
EJS_CODES.CODE_TYPE ITII_EJSCD_STAT_CD_FK R
USABILITY_CODE varchar2 30
EJS_CODES.CODE ITII_EJSCD_USAB_CD_FK R
USABILITY_CODE_TYPE varchar2 30
EJS_CODES.CODE_TYPE ITII_EJSCD_USAB_CD_FK R
INSTANCE_NUMBER varchar2 50  √  null
BARCODE varchar2 50  √  null
SERIAL_NUMBER varchar2 50  √  null
NEXT_MAINTENANCE_DATE date 7  √  null
EXPIRATION_DATE date 7  √  null
VIN varchar2 50  √  null
LIC_PLATE varchar2 30  √  null
LIC_MONTH number 0  √  null
LIC_YEAR number 0  √  null
STATE_TITLE varchar2 50  √  null
DISPOSITION_FLAG varchar2 1  √  'N'
DISPOSITION_DATE date 7  √  null
DISPOSITION_COMMENT varchar2 500  √  null
DISPOSITION_METHOD_CODE varchar2 30  √  null
EJS_CODES.CODE ITII_EJSCD_DISP_CD_FK R
DISPOSITION_METHOD_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE ITII_EJSCD_DISP_CD_FK R
CREATOR_ID varchar2 100  √  null
CREATOR_DATE date 7  √  null
UPDATOR_ID varchar2 100  √  null
UPDATOR_DATE date 7  √  null
AGENCY_CODE varchar2 30
AGENCY_CODES.AGENCY_CODE ITII_AGNCY_CD_FK R
CUSTODY_EVENT_ID number 0  √  null
ITEM_CUSTODY_EVENTS.CUSTODY_EVENT_ID ITII_ICE_FK R
CUSTODY_TYPE_CODE varchar2 30
EJS_CODES.CODE ITII_EJSCD_CUST_FK R
CUSTODY_TYPE_CODE_TYPE varchar2 30
EJS_CODES.CODE_TYPE ITII_EJSCD_CUST_FK R
CUSTODY_AGENCY_CODE varchar2 30
AGENCY_CODES.AGENCY_CODE ITII_AGNCY_CD_CUST_FK R
CUSTODY_START_DATE date 7  √  null
CUSTODY_END_DATE date 7  √  null
SELF_CHECKOUT_FLAG varchar2 1  √  'N'
LOCATION_ID number 0  √  null
ITEM_LOCATIONS.LOCATION_ID ITII_ITLC_FK R
LAST_WAREHOUSE_ID number 0  √  null
ITEM_LOCATIONS.LOCATION_ID ITII_ITLC_LW_FK R
SUB_LOCATION_ID number 0  √  null
ITEM_SUB_LOCATIONS.SUB_LOCATION_ID ITII_ITSLC_FK R
ORGANIZATION_ID number 0  √  null
ITEM_ORGANIZATIONS.ORGANIZATION_ID ITII_ITOR_FK R
EMPLOYEE_ID number 30  √  null
EMPLOYEES.EJS_EMP_ID ITII_EMP1_FK R
OFFICER_ID number 0  √  null
OFFICERS.OFFICER_ID ITII_OFF1_FK R
CUSTODY_ORDER_ID number 0  √  null
ITEM_ORDERS.ORDER_ID ITII_ITORD_CUST_FK R
PARENT_INSTANCE_ID number 0  √  null
ITEM_INSTANCES.INSTANCE_ID ITII_ITII_FK R
SERIALIZED_HINT_FLAG varchar2 1  √  'N'
DISPOSITION_USER varchar2 100  √  null
IJIS_USER_PROFILES.LOGIN_ID ITII_IUP_FK R
LAST_LOCATION_ID number 38  √  null
ITEM_LOCATIONS.LOCATION_ID ITII_ITLC_LLOC_FK R

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
DISPOSITION_FLAG IN ('Y', 'N') CK_ITII_DISP_FLAG
SERIALIZED_HINT_FLAG IN ('Y', 'N') CK_ITII_HINT_FLAG
SELF_CHECKOUT_FLAG IN ('Y', 'N') CK_ITII_SELF_CO_FLAG
"CUSTODY_AGENCY_CODE" IS NOT NULL ITII_AGENCY_CD_NN
"AGENCY_CODE" IS NOT NULL ITII_AGNCY_CD_NN
"CUSTODY_TYPE_CODE" IS NOT NULL ITII_CTC_NN
"CUSTODY_TYPE_CODE_TYPE" IS NOT NULL ITII_CTCT_NN
"DESCRIPTOR_ID" IS NOT NULL ITII_DESC_ID_NN
"INSTANCE_ID" IS NOT NULL ITII_INST_ID_NN
"STATUS_CODE" IS NOT NULL ITII_STAT_CD_NN
"STATUS_CODE_TYPE" IS NOT NULL ITII_STAT_CD_TP_NN
"USABILITY_CODE" IS NOT NULL ITII_USA_CD_NN
"USABILITY_CODE_TYPE" IS NOT NULL ITII_USA_CD_TP_NN

Indexes:
Column(s) Type Sort Constraint Name
INSTANCE_ID Primary key Asc ITII_PK
CUSTODY_AGENCY_CODE Performance Asc ITII_AGNCY_CD_CUST_FK_I
AGENCY_CODE Performance Asc ITII_AGNCY_CD_FK_I
DISPOSITION_FLAG Performance Asc ITII_DISP_FLAG_I
CUSTODY_TYPE_CODE_TYPE + CUSTODY_TYPE_CODE Performance Asc/Asc ITII_EJSCD_CUST_FK_I
DISPOSITION_METHOD_CODE_TYPE + DISPOSITION_METHOD_CODE Performance Asc/Asc ITII_EJSCD_DISP_CD_FK_I
STATUS_CODE_TYPE + STATUS_CODE Performance Asc/Asc ITII_EJSCD_STAT_CD_FK_I
USABILITY_CODE_TYPE + USABILITY_CODE Performance Asc/Asc ITII_EJSCD_USAB_CD_FK_I
EMPLOYEE_ID Performance Asc ITII_EMP1_FK_I
EXPIRATION_DATE Performance Asc ITII_EXPIRATION_DATE_I
SERIALIZED_HINT_FLAG Performance Asc ITII_HINT_FLAG_I
CUSTODY_EVENT_ID Performance Asc ITII_ICE_FK_I
INSTANCE_NUMBER Performance Asc ITII_INSTANCE_NUM_I
DESCRIPTOR_ID Performance Asc ITII_ITDS_FK_I
PARENT_INSTANCE_ID Performance Asc ITII_ITII_FK_I
LOCATION_ID Performance Asc ITII_ITLC_FK_I
LOCATION_ID + SUB_LOCATION_ID Performance Asc/Asc ITII_ITLC_ITSLC_I
LAST_LOCATION_ID Performance Asc ITII_ITLC_LLOC_FK_I
LAST_WAREHOUSE_ID Performance Asc ITII_ITLC_LW_FK_I
ORGANIZATION_ID Performance Asc ITII_ITOR_FK_I
CUSTODY_ORDER_ID Performance Asc ITII_ITORD_CUST_FK_I
SUB_LOCATION_ID Performance Asc ITII_ITSLC_FK_I
DISPOSITION_USER Performance Asc ITII_IUP_FK_I
OFFICER_ID Performance Asc ITII_OFF1_FK_I
ORDER_ID Performance Asc ITII_ORDER_ID_I

Close relationships  within of separation: