| Table slot9.WORLD.TSTA.INCIDENT_CLASSIFICATION This table stores the classification given to an INCIDENT in the application
|
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Analyzed at Mon Sep 20 21:05 MDT 2021 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Requirements (check constraints):
| Constraint | Constraint Name |
|---|---|
| "INC_CLASS_CODE_TYPE" IS NOT NULL | INCCLS_INC_CLASS_CD_TYP_NN |
| "INC_CLASS_CODE" IS NOT NULL | INCCLS_INC_CLASS_CODE_NN |
| "INC_CLASS_DESC" IS NOT NULL | INCCLS_INC_CLASS_DESC_NN |
| "INC_CLASS_ID" IS NOT NULL | INCCLS_INC_CLASS_ID_NN |
| "INCIDENT_ID" IS NOT NULL | INCCLS_INCIDENT_ID_NN |
Indexes:
| Column(s) | Type | Sort | Constraint Name |
|---|---|---|---|
| INC_CLASS_ID | Primary key | Asc | INCCLS_PK |
| INC_CLASS_CODE_TYPE + INC_CLASS_CODE | Performance | Asc/Asc | INCCLS_EJS_CODE_CLSCD_FK_I |
| INCIDENT_ID | Performance | Asc | INCCLS_INC_FK_I |
|