Table HLPDTEST.STATEGPS.T_GPS_VIEWER_INSTANCES_SET Generated by
SchemaSpy
Legend: SourceForge.net
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
APPLICATION_ID number 22  √  null
T_GPS_APPLICATIONS.APPLICATION_ID FK_T_GPS_VIEWER_INSTANCES C
SET_ID number 22
T_GPS_CUSTOM_SETS.FOLDER_ID FK_CS_FOLDER_ID C
T_GPS_ROLE_VIEWER_SETS.SET_ID FK_T_GPS_ROLE_VIEWERSET C
T_GPS_USER_VIEWER_SETS.VIEWERSET_ID FK_T_GPS_USER_VIEWERSET C
T_GPS_VIEWER_INSTANCES.SET_ID FK_T_GPS_VIEWER_INSTANCES_NT C
T_GPS_WORKFLOW_TYPES.FOLDER_ID FK_WT_FOLDER_ID C
T_GPS_COND_ST_CHANGE_SETS.SET_ID Implied Constraint R
SET_NAME varchar2 255  √  null
DESCRIPTION varchar2 1000  √  null
VISIBLE_FLAG varchar2 30  √  'true'
DISABLE_DIRECT_ACCESS varchar2 5  √  'false'
SET_IMAGE varchar2 255  √  null
DISPLAY_NAME varchar2 255  √  null
CREATED_DATE date 7  √  now
GROUP_NAME varchar2 255  √  null
VISIBLE_IN_SEARCH varchar2 10  √  'true'
VIEWER_SET_ORDER number 22  √  null To Sort viewer set in left menu in portal

Table contained 518 rows at Mon Mar 01 01:05 IST 2021

Indexes:
Column(s) Type Sort Constraint Name Anomalies
SET_ID Primary key Asc SYS_C0010125  
APPLICATION_ID Performance Asc T_GPS_VIEWER_INST_SET_INDEX  
APPLICATION_ID + VISIBLE_FLAG Performance Asc/Asc T_GPS_VIEWER_INSTANCES_SET_CN2  
APPLICATION_ID + DISPLAY_NAME Must be unique Asc/Asc UK1_T_GPS_VIEWER_INSTANCES_SET These unique columns are also nullable
APPLICATION_ID + SET_NAME Must be unique Asc/Asc UK_T_GPS_VIEWER_INSTANCES_SET These unique columns are also nullable

Close relationships  within of separation: