| Table slot9.WORLD.TSTA.SEARCH_INTERFACE_VALIDATORS This table defines the the search interface validations
|
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Analyzed at Mon Sep 20 21:05 MDT 2021 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Requirements (check constraints):
| Constraint | Constraint Name |
|---|---|
| ACTIVE_FLAG IN ('Y','N') | CK_SRCHINTV_ACTIVE_FLAG |
| FORM_TYPE = 'SEARCH_INTERFACE_FORM_TYPES' | CK_SRCHINTV_FORM_TYPE |
| "ACTIVE_FLAG" IS NOT NULL | SRCHINTV_FRM_ACTFLG_NN |
| "FORM_CODE" IS NOT NULL | SRCHINTV_FRM_CD_NN |
| "FORM_TYPE" IS NOT NULL | SRCHINTV_FRM_TYP_NN |
| "VALIDATOR_ID" IS NOT NULL | SRCHINTV_VAL_ID_NN |
Indexes:
| Column(s) | Type | Sort | Constraint Name |
|---|---|---|---|
| VALIDATOR_ID | Primary key | Asc | SRCHINTV_PK |
| OVERRIDE_AGENCY_CODE | Performance | Asc | SRCHINTV_AGNCY_CD_FK_I |
| FORM_TYPE + FORM_CODE | Performance | Asc/Asc | SRCHINTV_EJSCD_FRM_FK_I |
| FORM_TYPE + FORM_CODE + OVERRIDE_AGENCY_CODE | Must be unique | Asc/Asc/Asc | SRCHINTV_UK |
|