Table HLPDTEST.STATEGPS.T_GPS_ROLE_LEVEL_EWKS_ACTIONS 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
ACCESS_CONTROL_ID number 22
VIEWER_INSTANCES_ID number 22  √  null
T_GPS_VIEWER_INSTANCES.VIEWER_INSTANCES_ID FK_ROLE_LEVEL_EWKS_ACTIONS C
ROLE_ID number 22  √  null
T_ROLES.ROLE_ID FK_T_ROLES_EWKS_ROLE_ID C
DISABLE_UPDATEACCESS varchar2 10  √  null
DISABLE_INSERTACCESS varchar2 10  √  null
DISABLE_DELETEACCESS varchar2 10  √  null
DISABLE_EXPORTEXCELACCESS varchar2 10  √  null
DISABLE_SAVESHAREACCESS varchar2 10  √  null
DISABLE_COLUMNREORDERACCESS varchar2 10  √  null
DISABLE_QUERYDAILOGACCESS varchar2 10  √  null
DISABLE_WORKSHEETINFOACCESS varchar2 10  √  null
DISABLE_COLUMNSORTACCESS varchar2 10  √  'false'
DISABLE_PIVOTCONFIGACCESS varchar2 10  √  'false'
DISABLE_RECORDVIEWACCESS varchar2 10  √  'false'
DISABLE_TRANSIENTCOLUMNACCESS varchar2 10  √  'false'
DISABLE_COLORCONDITIONACCESS varchar2 10  √  'false'
DISABLE_FREEZEPANEACCESS varchar2 10  √  'false'
DISABLE_DATECONVERSIONACCESS varchar2 10  √  'false'
DISABLE_WRAPUNWRAPACCESS varchar2 10  √  'false'
DISABLE_OPENINNEWTABACCESS varchar2 10  √  'false'
DISABLE_GRAPHCONFIGACCESS varchar2 10  √  'false'

Table contained 15 rows at Wed Oct 28 01:06 IST 2020

Indexes:
Column(s) Type Sort Constraint Name Anomalies
ACCESS_CONTROL_ID Primary key Asc SYS_C0034079  
ROLE_ID + VIEWER_INSTANCES_ID Must be unique Asc/Asc T_GPS_ROLE_EWKS_ACTIONS_UNIQUE These unique columns are also nullable

Close relationships  within of separation: