SchemaSpy - Table slot9.WORLD.TSTA.INCIDENT

This table stores the information for when a user indicates an INCIDENT was for assisting another agency 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

ASSIST_ID

number

ASSIST_CODE

varchar2

EJS_CODES.CODE

INCAST_EJS_CODE_ASTCD_FK R

ASSIST_CODE_TYPE

varchar2

'ASSISTING_AGENCY_TYPES'

EJS_CODES.CODE_TYPE

INCAST_EJS_CODE_ASTCD_FK R

OBJECT_CODE

varchar2

EJS_CODES.CODE

INCAST_EJS_CODE_OBJCD_FK R

OBJECT_CODE_TYPE

varchar2

'OBJECT_AGENCY_CODES'

EJS_CODES.CODE_TYPE

INCAST_EJS_CODE_OBJCD_FK R

INCIDENT_CLASS_ID

number

INCIDENT_CLASSIFICATION.INC_CLASS_ID

INCAST_INCCLS_FK R

ASSIST_DESC

varchar2

255

√

null

CREATOR_ID

varchar2

100

√

null

CREATOR_DATE

date

√

null

UPDATOR_ID

varchar2

100

√

null

UPDATOR_DATE

date

√

null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):

Constraint	Constraint Name
"ASSIST_CODE" IS NOT NULL	INCAST_ASSIST_CODE_NN
"ASSIST_CODE_TYPE" IS NOT NULL	INCAST_ASSIST_CODE_TYPE_NN
"ASSIST_ID" IS NOT NULL	INCAST_ASSIST_ID_NN
"INCIDENT_CLASS_ID" IS NOT NULL	INCAST_INC_CLASS_ID_NN
"OBJECT_CODE" IS NOT NULL	INCAST_OBJECT_CODE_NN
"OBJECT_CODE_TYPE" IS NOT NULL	INCAST_OBJECT_CODE_TYPE_NN

Indexes:

Column(s)	Type	Sort	Constraint Name
ASSIST_ID	Primary key	Asc	INCAST_PK
ASSIST_CODE_TYPE + ASSIST_CODE	Performance	Asc/Asc	INCAST_EJS_CODE_ASTCD_FK_I
OBJECT_CODE_TYPE + OBJECT_CODE	Performance	Asc/Asc	INCAST_EJS_CODE_OBJCD_FK_I
INCIDENT_CLASS_ID	Performance	Asc	INCAST_INCCLS_FK_I