Table HLPDTEST.STATEGPS.T_GPS_CUSTOM_SETS 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
CUSTOM_SET_ID number 22
T_BPM_PUBLISHED_MODEL_VERSIONS.CUSTOM_SET_ID CUSTOM_SET_ID_FKEY C
T_GPS_CUSTOM_SETS_BKP.CUSTOM_SET_ID Implied Constraint R
T_GPS_ROLE_CUSTOM_SETS.CUSTOM_SET_ID FK_GPS_ROLE_CUSTOM_SETS C
T_GPS_USER_CUSTOM_SETS.CUSTOM_SET_ID FK_GPS_USER_CUSTOM_SETS C
APPLICATION_ID number 22
T_GPS_APPLICATIONS.APPLICATION_ID FK_T_GPS_CUSTOM_SETS C
CUSTOM_URL varchar2 4000  √  null
CUSTOM_DISPLAY_ON varchar2 200  √  null
CUSTOM_SET_NAME varchar2 255  √  null
VISIBLE_FLAG varchar2 10  √  'true'
IS_HELP_DOC varchar2 20  √  'false'
CUSTOM_IMAGE varchar2 255  √  null
DISPLAY_NAME varchar2 255  √  null
IS_WIDGET varchar2 10  √  null
GROUP_NAME varchar2 255  √  null
CREATED_BY varchar2 200  √  null
CREATED_DATE date 7  √  null
LAST_UPDATED_BY varchar2 200  √  null
LAST_UPDATED_DATE date 7  √  null
IS_SHOW_ALL_DASHBOARDS varchar2 25  √  null
VISIBLE_IN_SEARCH varchar2 10  √  'true'
FOLDER_ID number 22  √  null
T_GPS_VIEWER_INSTANCES_SET.SET_ID FK_CS_FOLDER_ID C
To link custom sets with viewer instances set
CUSTOM_SET_ORDER number 22  √  null To sort custom sets in left menu in portal

Table contained 843 rows at Thu Aug 13 01:05 IST 2020

Indexes:
Column(s) Type Sort Constraint Name
CUSTOM_SET_ID Primary key Asc SYS_C0010011
APPLICATION_ID + CUSTOM_SET_NAME Must be unique Asc/Asc SYS_C0014071
APPLICATION_ID Performance Asc T_GPS_CUSTOM_SETS_INDEX
VISIBLE_FLAG Performance Asc T_GPS_CUSTOM_SETS_VIS_CN1
APPLICATION_ID + DISPLAY_NAME Must be unique Asc/Asc UK_T_GPS_CUSTOM_SETS

Close relationships  within of separation: