Table HLPDTEST.STATEGPS.T_GPS_ROLE_APPLICATIONS 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
ROLE_APP_ID number 22
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 22
T_GPS_ROLES.ROLE_ID FK_T_GPS_ROLES_ROLE_ID C
APPLICATION_ID number 22
T_GPS_APPLICATIONS.APPLICATION_ID FK_T_GPS_ROLES_APP_ID C
DESCRIPTION varchar2 255  √  null

Table contained 3,160 rows at Tue Sep 22 01:05 IST 2020

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

Close relationships  within of separation: