SchemaSpy - Table HLPDTEST.STATEGPS.T_GPS_ROLE_LEVEL_EWKS_ACTIONS

Generated by
SchemaSpy

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

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