Table slot9.WORLD.TSTA.INCIDENT_SUPPLEMENT_PRECHEMS
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_PRECHEM_QTY_ID number 38 Sequence for primary key.
INCIDENT_ID number 38
INCIDENT_SUPPLEMENTS.INC_INCIDENT_ID INCSUPPC_INCSUP_FK R
Incident ID number assigned
SUPP_SEQ number 38
INCIDENT_SUPPLEMENTS.SUPP_SEQ INCSUPPC_INCSUP_FK R
Supplement Sequence Number 0 = Original Report
QUANTITY_PRE_CHEM_SEIZED number 20,3  √  null Quantity of Precursor Chemical Seized
TYPE_MEASURE_PRE_CHEM_CODE varchar2 30  √  null
EJS_CODES.CODE INCSUPPC_TYPMEASPC_EJS_CD_FK R
Type Measurement for Precursor Chemical
TYPE_MEASURE_PRE_CHEM_CD_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE INCSUPPC_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
"INCIDENT_ID" IS NOT NULL INCSUPPC_INCIDENT_ID_NN
"INCSUP_PRECHEM_QTY_ID" IS NOT NULL INCSUPPC_INCSUP_CHEM_ID_NN
"SUPP_SEQ" IS NOT NULL INCSUPPC_SUPP_SEQ_NN

Indexes:
Column(s) Type Sort Constraint Name
INCSUP_PRECHEM_QTY_ID Primary key Asc INCSUPPC_PK
INCIDENT_ID + SUPP_SEQ Performance Asc/Asc INCSUPPC_INCSUP_FK_I
TYPE_MEASURE_PRE_CHEM_CD_TYPE + TYPE_MEASURE_PRE_CHEM_CODE Performance Asc/Asc INCSUPPC_TYPMEASPC_EJS_CD_FK_I

Close relationships  within of separation: