Table slot9.WORLD.TSTA.DS_ICR_INC_QRY_SEL_TEMP
This table is a Global Temporary Table used for Batching, Processing Incident(s) when Approved and and moving the Incident(s) into an Open Data Set
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
DSICR_TEMP_ID number 0
INCIDENT_ID number 0
INCIDENTS.INCIDENT_ID Implied Constraint R

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"DSICR_TEMP_ID" IS NOT NULL DSICRQRY_DSICR_TEMP_ID_NN
"INCIDENT_ID" IS NOT NULL DSICRQRY_INCIDENT_ID_NN


Close relationships: