Table HLPDTEST.STATEGPS.T_GPS_ROLE_MENUCONFIG 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
T_GPS_ROLE_APPLICATIONS.ROLE_APP_ID SYS_C0010405 C
MENU_ID number 22
T_GPS_MENUCONFIG.MENU_ID SYS_C0010404 C
MENU_NAME varchar2 200
MODE_ID number 22
T_GPS_MENUCONFIG_MODE.MODE_ID SYS_C0010403 R

Table contained 146,119 rows at Sat Dec 05 01:06 IST 2020

Indexes:
Column(s) Type Sort Constraint Name
ROLE_APP_ID + MENU_ID + MENU_NAME + MODE_ID Must be unique Asc/Asc/Asc/Asc SYS_C0013696
ROLE_APP_ID Performance Asc T_GPS_ROLE_MENUCFG_INDEX1
ROLE_APP_ID + MENU_ID Performance Asc/Asc T_GPS_ROLE_MENUCFG_INDEX2

Close relationships  within of separation: