Table slot9.WORLD.TSTA.INCIDENT_SUPPLEMENT_DRUGS
This table is not currently used
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
INCSUP_DRUG_ID number 38 Sequence for primary key.
INCIDENT_ID number 38
INCIDENT_SUPPLEMENTS.INC_INCIDENT_ID INCSUPDG_INCSUP_FK R
Incident ID number assigned
SUPP_SEQ number 38
INCIDENT_SUPPLEMENTS.SUPP_SEQ INCSUPDG_INCSUP_FK R
Supplement Sequence Number 1 = Original Report
DRUG_LAB_SEIZED_CODE varchar2 30
EJS_CODES.CODE INCSUPDG_DRUGSZ_EJS_CODE_FK R
Type of Drug Manufactured
DRUG_LAB_SEIZED_CD_TYPE varchar2 30 'DRUG_LAB_SEIZED_CODES'
EJS_CODES.CODE_TYPE INCSUPDG_DRUGSZ_EJS_CODE_FK R
Type of Drug Manufactured
NUM_DRUG_LAB_SEIZED_CODE varchar2 30  √  null
EJS_CODES.CODE INCSUPDG_NDRUGSZ_EJS_CODE_FK R
Number of Clandestine Labs Seized
NUM_DRUG_LAB_SEIZED_CD_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE INCSUPDG_NDRUGSZ_EJS_CODE_FK R
Number of Clandestine Labs Seized
QUANTITY_PRE_CHEM_SEIZED number 20,3  √  null Quantity of Precursor Chemical Seized
TYPE_MEASURE_PRE_CHEM_CODE varchar2 30  √  null
EJS_CODES.CODE INCSUPDG_TYPMEASPC_EJS_CD_FK R
Type Measurement for Precursor Chemical
TYPE_MEASURE_PRE_CHEM_CD_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE INCSUPDG_TYPMEASPC_EJS_CD_FK R
Type Measurement for Precursor Chemical
CREATOR_ID varchar2 100  √  null Domain to store an Oracle USER ID
CREATOR_DATE date 7  √  null Date Record was created
UPDATOR_ID varchar2 100  √  null Domain to store an Oracle USER ID
UPDATOR_DATE date 7  √  null Date Record was last updated
REC_ID number 0  √  null Sequence used to uniquely identify this record.

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"DRUG_LAB_SEIZED_CODE" IS NOT NULL INCSUPDG_DRUG_SEIZED_CD_NN
"DRUG_LAB_SEIZED_CD_TYPE" IS NOT NULL INCSUPDG_DRUG_SEIZED_TYPE_NN
"INCIDENT_ID" IS NOT NULL INCSUPDG_INCIDENT_ID_NN
"INCSUP_DRUG_ID" IS NOT NULL INCSUPDG_INCSUP_DRUG_ID_NN
"SUPP_SEQ" IS NOT NULL INCSUPDG_SUPP_SEQ_NN

Indexes:
Column(s) Type Sort Constraint Name
INCSUP_DRUG_ID Primary key Asc INCSUPDG_PK
DRUG_LAB_SEIZED_CD_TYPE + DRUG_LAB_SEIZED_CODE Performance Asc/Asc INCSUPDG_DRUGSZ_EJS_CODE_FK_I
INCIDENT_ID + SUPP_SEQ Performance Asc/Asc INCSUPDG_INCSUP_FK_I
NUM_DRUG_LAB_SEIZED_CD_TYPE + NUM_DRUG_LAB_SEIZED_CODE Performance Asc/Asc INCSUPDG_NDRUGSZ_EJS_CODE_FK_I
TYPE_MEASURE_PRE_CHEM_CD_TYPE + TYPE_MEASURE_PRE_CHEM_CODE Performance Asc/Asc INCSUPDG_TYPMEASPC_EJS_CD_FK_I

Close relationships  within of separation: