Table slot9.WORLD.TSTA.SCREEN_ITEM_PARAMETERS
Legacy table. This table is not currently used
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
PARAMETER_ID number 38
PROFILE_SCREEN_ITEM_PARAMS.PARAMETER_ID PROSCRIP_SCRIP_FK R
PARAMETER_NAME varchar2 100
ITEM_ID number 38
SCREEN_ITEMS.ITEM_ID SCRIP_SCRI_FK R
DEFAULT_LABEL varchar2 100  √  null
CREATOR_ID varchar2 100  √  null
CREATOR_DATE date 7  √  null
UPDATOR_ID varchar2 100  √  null
UPDATOR_DATE date 7  √  null
REC_ID number 0  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"ITEM_ID" IS NOT NULL SCRIP_ITEM_ID_NN
"PARAMETER_ID" IS NOT NULL SCRIP_PARAM_ID_NN
"PARAMETER_NAME" IS NOT NULL SCRIP_PARAM_NAME_NN

Indexes:
Column(s) Type Sort Constraint Name
PARAMETER_ID Primary key Asc SCRIP_PK
ITEM_ID Performance Asc SCRIP_SCRI_FK_I

Close relationships  within of separation: