| Table slot9.WORLD.TSTA.USER_FIELD_CODE_VALUES This table stores the values entered in the application for custom code type fields
|
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Analyzed at Mon Sep 20 21:05 MDT 2021 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Requirements (check constraints):
| Constraint | Constraint Name |
|---|---|
| "CODE" IS NOT NULL | USRSCRN_UFCV_CODE_NN |
| "CODE_TYPE" IS NOT NULL | USRSCRN_UFCV_CODE_TYPE_NN |
| "INST_CODE_VALUE_ID" IS NOT NULL | USRSCRN_UFCV_CODEVAL_ID_NN |
| "FIELD_INSTANCE_ID" IS NOT NULL | USRSCRN_UFCV_FIELDINST_ID_NN |
Indexes:
| Column(s) | Type | Sort | Constraint Name |
|---|---|---|---|
| INST_CODE_VALUE_ID | Primary key | Asc | USRSCRN_UFCV_PK |
| CODE_TYPE + CODE | Performance | Asc/Asc | USRSCRN_UFCV_EJS_CODE_FK_I |
| FIELD_INSTANCE_ID | Performance | Asc | USRSCRN_UFCV_USR_FINST_FK_I |
|