| Table slot9.WORLD.TSTA.USER_SCREEN_VIEW_COLUMNS This table is used for custom form searches in the application
|
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Analyzed at Mon Sep 20 21:05 MDT 2021 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Requirements (check constraints):
| Constraint | Constraint Name |
|---|---|
| REC_DISPLAY_FLAG IN ('Y', 'N') | CK_USRSCRN_VWCL_DISP_FLAG |
| "COLUMN_NAME" IS NOT NULL | USRSCRN_VWCL_CN_NN |
| "DISPLAY_NAME" IS NOT NULL | USRSCRN_VWCL_DSN_NN |
| "VIEW_ID" IS NOT NULL | USRSCRN_VWCL_VWID_NN |
Indexes:
| Column(s) | Type | Sort | Constraint Name |
|---|---|---|---|
| VIEW_ID + COLUMN_NAME | Primary key | Asc/Asc | USRSCRN_VWCL_PK |
| COLUMN_NAME | Performance | Asc | USRSCRN_VWCL_COLUMN_NAME_I |
| VIEW_ID | Performance | Asc | USRSCRN_VWCL_USRSCRN_VW_FK_I |
|