Table slot9.WORLD.TSTA.ITEM_GUN_DESCRIPTORS
This table stores the gun specific attributes if the inventory item is a weapon 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
DESCRIPTOR_ID number 0
ITEM_DESCRIPTORS_VW.DESCRIPTOR_ID Implied Constraint R
ITEM_GUN_DESCRIPTORS_VW.DESCRIPTOR_ID Implied Constraint R
ITEM_INST_CUSTODY_DESC_VW.DESCRIPTOR_ID Implied Constraint R
ITEM_INST_CUSTODY_VW.DESCRIPTOR_ID Implied Constraint R
ITEM_INST_ENT_ROLLUP_VW.DESCRIPTOR_ID Implied Constraint R
ITEM_INST_ROLLUP_VW.DESCRIPTOR_ID Implied Constraint R
ITEM_VEHICLE_DESCRIPTORS.DESCRIPTOR_ID Implied Constraint R
ITEM_VEHICLE_DESCRIPTORS_VW.DESCRIPTOR_ID Implied Constraint R
ITEM_DESCRIPTORS.DESCRIPTOR_ID ITGS_ITDS_FK R
WEAPON_TYPE_CODE varchar2 30  √  null
EJS_CODES.CODE ITGS_EJSCD_WEAPONCD_FK R
WEAPON_TYPE_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE ITGS_EJSCD_WEAPONCD_FK R
CALIBER_CODE varchar2 30  √  null
EJS_CODES.CODE ITGS_EJSCD_CALIB_CD_FK R
CALIBER_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE ITGS_EJSCD_CALIB_CD_FK R
ACTION_CODE varchar2 30  √  null
EJS_CODES.CODE ITGS_EJSCD_ACT_CD_FK R
ACTION_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE ITGS_EJSCD_ACT_CD_FK R
BARREL_LENGTH varchar2 30  √  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
"DESCRIPTOR_ID" IS NOT NULL ITGS_DESC_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
DESCRIPTOR_ID Primary key Asc ITGS_PK
ACTION_CODE_TYPE + ACTION_CODE Performance Asc/Asc ITGS_EJSCD_ACT_CD_FK_I
CALIBER_CODE_TYPE + CALIBER_CODE Performance Asc/Asc ITGS_EJSCD_CALIB_CD_FK_I
WEAPON_TYPE_CODE_TYPE + WEAPON_TYPE_CODE Performance Asc/Asc ITGS_EJSCD_WEAPONCD_FK_I

Close relationships  within of separation: