| Table slot9.WORLD.TSTA.REPORT_AGENCIES This table defines the reports that are valid for an agency within the Forms and Reports module in the application
|
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Analyzed at Mon Sep 20 21:05 MDT 2021 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Requirements (check constraints):
| Constraint | Constraint Name |
|---|---|
| "AGENCY_CODE" IS NOT NULL | REPAG_AGENCY_CODE_NN |
| "MASTER_REPORT_ID" IS NOT NULL | REPAG_MASTER_REPORT_ID_NN |
Indexes:
| Column(s) | Type | Sort | Constraint Name |
|---|---|---|---|
| MASTER_REPORT_ID + AGENCY_CODE | Primary key | Asc/Asc | REPAG_PK |
| AGENCY_CODE | Performance | Asc | REPAG_AGNCY_CD_FK_I |
| MASTER_REPORT_ID | Performance | Asc | REPAG_MREP_FK_I |
|