SchemaSpy - Table HLPDTEST.STATEGPS.T_GPS_ROLE

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

ROLE_APP_ID

number

GPS_EWKS_NODE_PROPS_CONFIG_V.ROLE_APP_ID	Implied Constraint R
GPS_EWKS_NODE_PROPS_VW.ROLE_APP_ID	Implied Constraint R
GPS_NODE_PORPS_CONFIG_V.ROLE_APP_ID	Implied Constraint R
GPS_NODE_PROPS_VW.ROLE_APP_ID	Implied Constraint R
T_GPS_ROLE_APP_OPERATIONS.ROLE_APP_ID	FK_T_GPS_ROLE_APPOPERATION C
T_GPS_ROLE_CATEGORIES.ROLE_APP_ID	FK_T_GPS_ROLE_CAT_APP_ID C
T_GPS_ROLE_CUSTOM_SETS.ROLE_APP_ID	FK_T_GPS_ROLE_CUSTOM_SETS C
T_GPS_ROLE_MENUCONFIG.ROLE_APP_ID	SYS_C0010405 C
T_GPS_ROLE_NODETYPES.ROLE_APP_ID	FK_T_GPS_ROLE_APP_ID C
T_GPS_ROLE_VIEWER_SETS.ROLE_APP_ID	FK_T_GPS_ROLE_VIEWER_APP_ID C
T_GPS_ROLE_WORKFLOW_TYPES.ROLE_APP_ID	FK_T_GPS_ROLE_WFT_APP_ID C

ROLE_ID

number

T_GPS_ROLES.ROLE_ID

FK_T_GPS_ROLES_ROLE_ID C

APPLICATION_ID

number

T_GPS_APPLICATIONS.APPLICATION_ID

FK_T_GPS_ROLES_APP_ID C

DESCRIPTION

varchar2

255

√

null

Table contained 3,344 rows at Mon Mar 01 01:05 IST 2021

Indexes:

Column(s)	Type	Sort	Constraint Name
ROLE_APP_ID	Primary key	Asc	SYS_C0010080
ROLE_ID + APPLICATION_ID	Must be unique	Asc/Asc	SYS_C0013684
ROLE_ID + ROLE_APP_ID	Performance	Asc/Asc	T_GPS_ROLE_APPLICATIONS_INDEX