Table HLPDTEST.STATEGPS.T_GPS_USER_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
USER_APP_ID number 22
T_GPS_USER_APPLICATIONS.USER_APP_ID SYS_C0010219 C
MENU_ID number 22
T_GPS_MENUCONFIG.MENU_ID SYS_C0010218 C
MENU_NAME varchar2 200
MODE_ID number 22
T_GPS_MENUCONFIG_MODE.MODE_ID SYS_C0010217 R

Table contained 934,388 rows at Sat Dec 05 01:06 IST 2020

Indexes:
Column(s) Type Sort Constraint Name
USER_APP_ID + MENU_ID + MENU_NAME + MODE_ID Must be unique Asc/Asc/Asc/Asc SYS_C0013707
USER_APP_ID Performance Asc T_GPS_USER_MENUCFG_INDEX1
USER_APP_ID + MENU_ID Performance Asc/Asc T_GPS_USER_MENUCFG_INDEX2

Close relationships  within of separation: