Table slot9.WORLD.TSTA.PROFILE_SCREEN_ITEMS
This table defines custom screen setup. Users have the ability customize their home page and this table stores the settings
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
INSTANCE_ID number 38
PROFILE_SCREEN_ITEM_PARAMS.INSTANCE_ID PROSCRIP_PROSI_FK R
INC_REVIEW_ROUTE_INSTANCES.INSTANCE_ID Implied Constraint R
LOGIN_ID varchar2 100
IJIS_USER_PROFILES.LOGIN_ID PROSI_IUP_FK R
ITEM_ID number 38
SCREEN_ITEMS.ITEM_ID PROSI_SCRI_FK R
DISPLAY_INDEX number 0
MINIMIZED char 1  √  'N'
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
MINIMIZED IN ( 'Y','N') CK_PROSI_MINIMIZED
"DISPLAY_INDEX" IS NOT NULL PROSI_DIS_INDEX_NN
"INSTANCE_ID" IS NOT NULL PROSI_INSTNACE_ID_NN
"ITEM_ID" IS NOT NULL PROSI_ITEM_CODE_NN
"LOGIN_ID" IS NOT NULL PROSI_LOGIN_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
INSTANCE_ID Primary key Asc PROSI_PK
LOGIN_ID Performance Asc PROSI_IUP_FK_I
ITEM_ID Performance Asc PROSI_SCRI_FK_I

Close relationships  within of separation: