| Table slot9.WORLD.TSTA.USI_OFFENSES This table maps an instance of an offense to the instance of the associated custom form
|
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Analyzed at Mon Sep 20 21:05 MDT 2021 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Requirements (check constraints):
| Constraint | Constraint Name |
|---|---|
| "INCIDENT_ID" IS NOT NULL | USI_OFF_INCIDENT_ID_NN |
| "INSTANCE_ID" IS NOT NULL | USI_OFF_INSTANCE_ID_NN |
| "OFFENSE_NUMBER" IS NOT NULL | USI_OFF_OFFENSE_NUM_NN |
| "SUPP_SEQ" IS NOT NULL | USI_OFF_SUPP_SEQ_NN |
Indexes:
| Column(s) | Type | Sort | Constraint Name |
|---|---|---|---|
| INSTANCE_ID + INCIDENT_ID + SUPP_SEQ + OFFENSE_NUMBER | Primary key | Asc/Asc/Asc/Asc | USI_OFF_PK |
| INCIDENT_ID + OFFENSE_NUMBER + SUPP_SEQ | Performance | Asc/Asc/Asc | USI_OFF_OFFNSE_FK_I |
| INSTANCE_ID | Performance | Asc | USI_OFF_USRSCRN_INST_FK_I |
|