| Table slot9.WORLD.TSTA.CITATION_REPORTS This table stores external report identifiers and types (e.g. accident, court case) added to an citation in the application
|
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Analyzed at Mon Sep 20 21:05 MDT 2021 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Requirements (check constraints):
| Constraint | Constraint Name |
|---|---|
| "CITATION_ID" IS NOT NULL | CITREP_CITATION_ID_NN |
| "CITATION_REPORT_ID" IS NOT NULL | CITREP_ID_NN |
| "REPORT_NUMBER" IS NOT NULL | CITREP_REP_NUM_NN |
| "REPORT_TYPE_CODE" IS NOT NULL | CITREP_TYPE_CD_NN |
| "REPORT_TYPE_CODE_TYPE" IS NOT NULL | CITREP_TYPE_CD_TYPE_NN |
Indexes:
| Column(s) | Type | Sort | Constraint Name |
|---|---|---|---|
| CITATION_REPORT_ID | Primary key | Asc | CITREP_PK |
| CITATION_ID | Performance | Asc | CITREP_CITATION_FK_I |
| REPORT_TYPE_CODE_TYPE + REPORT_TYPE_CODE | Performance | Asc/Asc | CITREP_EC_TYPE_CODE_FK_I |
|