SchemaSpy - Table slot9.WORLD.TSTA.ERROR_CODE_NOTIFICATIONS

Legacy table. 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

ERROR_ID

number

0

ERROR_CODES.ERROR_ID

ECN_EC_FK R

NOTIFY_TYPE_CD

number

8

NOTIFICATION_DEF_MASTERS.NOTIFY_TYPE_CD

ECN_NDM_FK R

REC_ID

number

0

√

null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):

Constraint	Constraint Name
"ERROR_ID" IS NOT NULL	ECN_ERROR_ID_NN
"NOTIFY_TYPE_CD" IS NOT NULL	ECN_NOTIFY_TYPE_CD_NN

Indexes:

Column(s)	Type	Sort	Constraint Name
NOTIFY_TYPE_CD + ERROR_ID	Primary key	Asc/Asc	ECN_PK
ERROR_ID	Performance	Asc	ECN_EC_FK_I
NOTIFY_TYPE_CD	Performance	Asc	ECN_NDM_FK_I