| Table slot9.WORLD.TSTA.SEARCH_INTERFACE_FIELD_MAPS This table defines which fields are needed for given search interfaces
|
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Analyzed at Mon Sep 20 21:05 MDT 2021 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Requirements (check constraints):
| Constraint | Constraint Name |
|---|---|
| FORM_FIELD_TYPE = 'SEARCH_INTERFACE_FORM_FIELDS' | CK_SRCHINTFM_FRMFLDTYP |
| FORM_TYPE = 'SEARCH_INTERFACE_FORM_TYPES' | CK_SRCHINTFM_FRMTYP |
| RMS_FORM_FIELD_TYPE = 'RMS_FORM_FIELDS' | CK_SRCHINTFM_RMSFRMFLD |
| "FORM_CODE" IS NOT NULL | SRCHINTFM_FRMCD_NN |
| "FORM_FIELD_CODE" IS NOT NULL | SRCHINTFM_FRMFLDCD_NN |
| "FORM_FIELD_TYPE" IS NOT NULL | SRCHINTFM_FRMFLDTYP_NN |
| "FORM_TYPE" IS NOT NULL | SRCHINTFM_FRMTYP_NN |
| "RMS_FORM_FIELD_CODE" IS NOT NULL | SRCHINTFM_RMSFRMFLDC_NN |
| "RMS_FORM_FIELD_TYPE" IS NOT NULL | SRCHINTFM_RMSFRMFLDT_NN |
Indexes:
| Column(s) | Type | Sort | Constraint Name |
|---|---|---|---|
| RMS_FORM_FIELD_TYPE + RMS_FORM_FIELD_CODE + FORM_TYPE + FORM_CODE | Primary key | Asc/Asc/Asc/Asc | SRCHINTFM_PK |
| RMS_FORM_FIELD_TYPE + RMS_FORM_FIELD_CODE | Performance | Asc/Asc | SRCHINTFM_EJSCD_RFLD_FK_I |
| FORM_TYPE + FORM_CODE + FORM_FIELD_TYPE + FORM_FIELD_CODE | Performance | Asc/Asc/Asc/Asc | SRCHINTFM_EJSCDR_FTP_FK_I |
| FORM_FIELD_TYPE + FORM_FIELD_CODE | Performance | Asc/Asc | SRCHINTFM_FRMFT_I |
| FORM_TYPE + FORM_CODE | Performance | Asc/Asc | SRCHINTFM_FRMTYP_I |
|