Table slot9.WORLD.TSTA.WEAPONS
This table stores weapons associated with an INCIDENT created 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
WEAPON_ID number 9
WC_WEAPON_CODE varchar2 30
EJS_CODES.CODE WEA_WEAPON_EJS_CODES_FK R
code is UCR code
OFFNSE_INC_INCIDENT_ID number 0  √  null
OFFENSES.INC_INCIDENT_ID WEA_OFFNSE_FK C
Incident ID number assigned
OFFNSE_OFFENSE_NUMBER number 0  √  null
OFFENSES.OFFENSE_NUMBER WEA_OFFNSE_FK C
Number assigned to track the offense
CREATOR_ID varchar2 100  √  null Person creating the record
CREATOR_DATE date 7  √  null Date record created
UPDATOR_ID varchar2 100  √  null Person who last updated the record
UPDATOR_DATE date 7  √  null Date of last update
OFFNSE_SUPP_SEQ number 5  √  null
OFFENSES.SUPP_SEQ WEA_OFFNSE_FK C
WC_WEAPON_CODE_TYPE varchar2 30 'WEAPON_CODES'
EJS_CODES.CODE_TYPE WEA_WEAPON_EJS_CODES_FK R
REC_ID number 0  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"WC_WEAPON_CODE" IS NOT NULL WEA_WC_WEAPON_CODE_NN
"WC_WEAPON_CODE_TYPE" IS NOT NULL WEA_WEAPON_CODE_TYPE_NN
"WEAPON_ID" IS NOT NULL WEA_WEAPON_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
WEAPON_ID Primary key Asc WEA_PK
OFFNSE_INC_INCIDENT_ID + OFFNSE_OFFENSE_NUMBER + OFFNSE_SUPP_SEQ Performance Asc/Asc/Asc WEA_OFFNSE_FK_I
WC_WEAPON_CODE Performance Asc WEA_WC_FK_I
WC_WEAPON_CODE_TYPE + WC_WEAPON_CODE Performance Asc/Asc WEA_WEAPON_EJS_CODES_FK_I

Close relationships  within of separation: