| Table slot9.WORLD.TSTA.SEARCH_INT_FORM_TYPES This table defines the different types of search types for external searches
|
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Analyzed at Mon Sep 20 21:05 MDT 2021 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Requirements (check constraints):
| Constraint | Constraint Name |
|---|---|
| ACTIVE_FLAG IN('Y','N') | CK_SRCHINTFT_ACTIVE_FLAG |
| FORM_TYPE = ('SEARCH_INTERFACE_FORM_TYPES') | CK_SRCHINTFT_FORM_TYPE |
| "ACTIVE_FLAG" IS NOT NULL | SRCHINTFT_ACTFLG_NN |
| "FORM_CODE" IS NOT NULL | SRCHINTFT_FRMCD_NN |
| "FORM_TYPE" IS NOT NULL | SRCHINTFT_FRMTYP_NN |
| "INTERFACE_ID" IS NOT NULL | SRCHINTFT_INTID_NN |
| "SEARCH_INT_FORM_TYPE_ID" IS NOT NULL | SRCHINTFT_NN |
Indexes:
| Column(s) | Type | Sort | Constraint Name |
|---|---|---|---|
| SEARCH_INT_FORM_TYPE_ID | Primary key | Asc | SRCHINTFT_PK |
| OVERRIDE_AGENCY_CODE | Performance | Asc | SRCHINTFT_AGNCY_CD_FK_I |
| FORM_TYPE + FORM_CODE | Performance | Asc/Asc | SRCHINTFT_EJSCD_FT_FK_I |
| INTERFACE_ID | Performance | Asc | SRCHINTFT_SRCHINT_FK_I |
| OVERRIDE_AGENCY_CODE + INTERFACE_ID | Must be unique | Asc/Asc | SRCHINTFT_UK |
|