| Table slot9.WORLD.TSTA.INCIDENT_NOTIFY_HISTORY This tables stores a history of people notified of an INCIDENT in the application
|
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Analyzed at Mon Sep 20 21:05 MDT 2021 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Requirements (check constraints):
| Constraint | Constraint Name |
|---|---|
| "DEST_AGENCY_CODE" IS NOT NULL | INH_DEST_AGENCY_CODE_NN |
| "HISTORY_ID" IS NOT NULL | INH_HISTORY_ID_NN |
| "INCIDENT_ID" IS NOT NULL | INH_INCIDENT_ID_NN |
| "NOTIFY_TYPE_CD" IS NOT NULL | INH_NOTIFY_TYPE_CD_NN |
| "SEND_DATE" IS NOT NULL | INH_SEND_DATE_NN |
| "SRC_AGENCY_CODE" IS NOT NULL | INH_SRC_AGENCY_CODE_NN |
| "SUPP_SEQ" IS NOT NULL | INH_SUPP_SEQ_NN |
Indexes:
| Column(s) | Type | Sort | Constraint Name |
|---|---|---|---|
| HISTORY_ID | Primary key | Asc | INH_PK |
| DEST_AGENCY_CODE | Performance | Asc | INH_AGNCY_CD_DEST_FK_I |
| SRC_AGENCY_CODE | Performance | Asc | INH_AGNCY_CD_SRC_FK_I |
| INCIDENT_ID | Performance | Asc | INH_INCIDENT_ID_I |
| INCIDENT_ID + SUPP_SEQ | Performance | Asc/Asc | INH_INCSUP_FK_I |
| NOTIFY_TYPE_CD | Performance | Asc | INH_NDM_FK_I |
| SUPP_SEQ | Performance | Asc | INH_SUPP_SEQ_I |
|