| Table slot9.WORLD.TSTA.VALIDATION_ELEMENTS Used for search interface fields
|
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Analyzed at Mon Sep 20 21:05 MDT 2021 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Requirements (check constraints):
| Constraint | Constraint Name |
|---|---|
| NOT_FLAG IN ('Y','N') | CK_VALELEMTS_NOT_FLAG |
| OPTIONAL_FLAG IN ('Y','N') | CK_VALELEMTS_OPTIONAL_FLAG |
| RMS_FORM_FIELD_TYPE = 'RMS_FORM_FIELDS' | CK_VALELEMTS_RMS_FRM_FLD_TYP |
| "AND_GROUP_NUMBER" IS NOT NULL | VALELEMTS_AND_GRP_NUM_NN |
| "ELEMENT_ID" IS NOT NULL | VALELEMTS_ELE_ID_NN |
| "NOT_FLAG" IS NOT NULL | VALELEMTS_NOT_FLAG_NN |
| "OPTIONAL_FLAG" IS NOT NULL | VALELEMTS_OPT_FLAG_NN |
| "RMS_FORM_FIELD_CODE" IS NOT NULL | VALELEMTS_RMSFRMFLDCD_NN |
| "RMS_FORM_FIELD_TYPE" IS NOT NULL | VALELEMTS_RMSFRMFLDTYP_NN |
| "VALIDATOR_ID" IS NOT NULL | VALELEMTS_VAL_ID_NN |
Indexes:
| Column(s) | Type | Sort | Constraint Name |
|---|---|---|---|
| VALIDATOR_ID + ELEMENT_ID | Primary key | Asc/Asc | VALELEMTS_PK |
| RMS_FORM_FIELD_TYPE + RMS_FORM_FIELD_CODE | Performance | Asc/Asc | VALELEMTS_EJSCD_FLDTYP_FK_I |
| VALIDATOR_ID | Performance | Asc | VALELEMTS_SRCHINTV_FK_I |
|