| Table slot9.WORLD.TSTA.INCIDENT_LOCATIONS This table stores the associations to additional MASTER ADDRESSES along with their role that are added to the INCIDENT in the application
|
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Analyzed at Mon Sep 20 21:05 MDT 2021 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Requirements (check constraints):
| Constraint | Constraint Name |
|---|---|
| "ADDRESS_ID" IS NOT NULL | INC_LOC_ADDRESS_ID_NN |
| "ID" IS NOT NULL | INC_LOC_ID_NN |
| "INCIDENT_ID" IS NOT NULL | INC_LOC_INCIDENT_ID_NN |
| "SUPP_SEQ" IS NOT NULL | INC_LOC_SUPP_SEQ_NN |
| "LOC_TYPE_CODE" IS NOT NULL | INC_LOC_TYP_CD_NN |
| "LOC_TYPE_CODE_TYPE" IS NOT NULL | INC_LOC_TYPE_CD_TYP_NN |
Indexes:
| Column(s) | Type | Sort | Constraint Name |
|---|---|---|---|
| ID | Primary key | Asc | INC_LOC_PK |
| ADDRESS_ID | Performance | Asc | INC_LOC_ADDR_FK_I |
| LOC_TYPE_CODE_TYPE + LOC_TYPE_CODE | Performance | Asc/Asc | INC_LOC_EJSCD_LOCTYPE_FK_I |
| INCIDENT_ID | Performance | Asc | INC_LOC_INCIDENT_ID_I |
| INCIDENT_ID + SUPP_SEQ | Performance | Asc/Asc | INC_LOC_INCSUP_FK_I |
|