Table slot9.WORLD.TSTA.DISPATCH_EVENT_TYPES
This table defines the valid dispatch event types (e.g. POLICE, FIRE, EMS)
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
EVENT_TYPE_CODE varchar2 30
BI_CALLS_FOR_SERVICE_VW.EVENT_TYPE_CODE Implied Constraint R
CALL_DISPOSITION_CODES.EVENT_TYPE_CODE Implied Constraint R
CALL_TYPE_CODES.EVENT_TYPE_CODE CALLTYPECD_DISET_FK R
DEL_DISPATCH_EVENTS.EVENT_TYPE_CODE Implied Constraint R
DISPATCH_SEARCH_VW.EVENT_TYPE_CODE Implied Constraint R
JS_CALLS_FOR_SERVICE_VW.EVENT_TYPE_CODE Implied Constraint R
JS_CIVIL_PROCESS_LOG_VW.EVENT_TYPE_CODE Implied Constraint R
JS_CIVIL_PROCESS_PARTY_VW.EVENT_TYPE_CODE Implied Constraint R
JS_CIVIL_PROCESS_VW.EVENT_TYPE_CODE Implied Constraint R
MAP_EVENT_TYPES_TEMP.EVENT_TYPE_CODE Implied Constraint R
DESCRIPTION varchar2 255  √  null
ACTIVE_FLAG varchar2 1  √  null
CREATOR_ID varchar2 100  √  null
CREATOR_DATE date 7  √  null
UPDATOR_ID varchar2 100  √  null
UPDATOR_DATE date 7  √  null
REC_ID number 0  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"EVENT_TYPE_CODE" IS NOT NULL DISET_EVENT_TYPE_CODE_NN

Indexes:
Column(s) Type Sort Constraint Name
EVENT_TYPE_CODE Primary key Asc DISET_PK

Close relationships  within of separation: