Table HLPDTEST.STATEGPS.T_GPS_ROLES 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_ID number 22
GPS_EWKS_NODE_PROPS_CONFIG_V.ROLE_ID Implied Constraint R
GPS_EWKS_NODE_PROPS_VW.ROLE_ID Implied Constraint R
GPS_NODE_PORPS_CONFIG_V.ROLE_ID Implied Constraint R
GPS_NODE_PROPS_VW.ROLE_ID Implied Constraint R
PROJECT_NATIVE_TASKS_V.ROLE_ID Implied Constraint R
T_GPS_ROLE_APPLICATIONS.ROLE_ID FK_T_GPS_ROLES_ROLE_ID C
T_PROJECT_NATIVE_TASK_V.ROLE_ID Implied Constraint R
T_PROJECT_ROLE_USERS.ROLE_ID Implied Constraint R
T_PROJECT_TASK.ROLE_ID Implied Constraint R
ROLE_NAME varchar2 255  √  null
DESCRIPTION varchar2 255  √  null
LAST_UPDATED_ON timestamp(6) 11,6  √  now
USER_NAME varchar2 255  √  null

Table contained 2,371 rows at Wed Oct 28 01:06 IST 2020

Indexes:
Column(s) Type Sort Constraint Name Anomalies
ROLE_ID Primary key Asc SYS_C0010078  
ROLE_NAME Must be unique Asc SYS_C0010079 This unique column is also nullable
ROLE_NAME + ROLE_ID Performance Asc/Asc T_GPS_ROLES_RNAME_INDEX  

Close relationships  within of separation: