Table slot9.WORLD.TSTA.USER_FIELD_ROWS
This table defines rows of custom fields within groups on a screen in the application
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
ROW_ID number 38
USER_FIELDS.ROW_ID USRSCRN_F_USRSCRN_UFR_FK R
EVIDENCE_LABEL_ROWS.ROW_ID Implied Constraint R
GROUP_ID number 38  √  null
USER_FIELD_GROUPS.GROUP_ID USRSCRN_UFR_USRSCRN_FG_FK R
DISPLAY_INDEX number 38  √  null
CREATOR_ID varchar2 100  √  null Domain to store an Oracle USER ID
CREATOR_DATE date 7  √  null
UPDATOR_ID varchar2 100  √  null Domain to store an Oracle USER ID
UPDATOR_DATE date 7  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"ROW_ID" IS NOT NULL USRSCRN_UFR_ROW_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
ROW_ID Primary key Asc USRSCRN_UFR_PK
GROUP_ID Performance Asc USRSCRN_UFR_USRSCRN_FG_FK_I

Close relationships  within of separation: