| Table slot9.WORLD.TSTA.USER_FIELD_SUB_INST_VALUES This table stores the values entered in the application for sub-instances of the custom fields
|
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Analyzed at Mon Sep 20 21:05 MDT 2021 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Requirements (check constraints):
| Constraint | Constraint Name |
|---|---|
| "DISPLAY_INDEX" IS NOT NULL | UFSIV_DISP_IND_NN |
| "FIELD_INSTANCE_ID" IS NOT NULL | UFSIV_FIELDINST_ID_NN |
| "SUB_INSTANCE_ID" IS NOT NULL | UFSIV_SUBINST_ID_NN |
| "INST_SUB_VALUE_ID" IS NOT NULL | UFSIV_SUBVAL_ID_NN |
Indexes:
| Column(s) | Type | Sort | Constraint Name |
|---|---|---|---|
| INST_SUB_VALUE_ID | Primary key | Asc | UFSIV_PK |
| FIELD_INSTANCE_ID | Performance | Asc | UFSIV_USRSCRN_FINST_FK_I |
| SUB_INSTANCE_ID | Performance | Asc | UFSIV_USRSCRN_INST_FK_I |
|