Table HLPDTEST.STATEGPS.T_GPS_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
APPLICATION_ID number 22  √  null
T_GPS_APPLICATIONS.APPLICATION_ID FK_T_GPS_MENUCONFIG C
MENU_ID number 22
T_GPS_MENUCONFIG_RELATIONS.CHILD_MENU_ID FKCHILD_MENUCONFIG_RELATIONS C
T_GPS_MENUCONFIG_RELATIONS.MENU_ID FK_T_GPS_MENUCONFIG_RELATIONS C
T_GPS_ROLE_MENUCONFIG.MENU_ID SYS_C0010404 C
T_GPS_USER_MENUCONFIG.MENU_ID SYS_C0010218 C
NAME varchar2 255  √  null
ALIAS varchar2 255  √  null
MNEMONIC varchar2 255  √  null
INTERNAL_FRAME varchar2 255  √  null
IMAGE varchar2 255  √  null
TOOLBAR_FLAG varchar2 255  √  null
DISPLAY_FLAG varchar2 255  √  null
DEFAULT_FLAG varchar2 255  √  null
SEPARATOR_FLAG varchar2 255  √  null
TOOLBAR_ORDER number 22  √  null
RMC_DISPLAY_FLAG varchar2 255  √  null
MODE_ID number 22
T_GPS_MENUCONFIG_MODE.MODE_ID SYS_C0010257 R

Table contained 151,646 rows at Tue Aug 11 01:05 IST 2020

Indexes:
Column(s) Type Sort Constraint Name
MENU_ID Primary key Asc SYS_C0010031
APPLICATION_ID + MODE_ID Performance Asc/Asc T_GPS_MENUCONFIG_CN2
APPLICATION_ID + MODE_ID + DISPLAY_FLAG Performance Asc/Asc/Asc T_GPS_MENUCONFIG_CN3
APPLICATION_ID + DISPLAY_FLAG Performance Asc/Asc T_GPS_MENUCONFIG_CN4
APPLICATION_ID + MENU_ID + NAME Performance Asc/Asc/Asc T_GPS_MENUCONFIG_INDEX

Close relationships  within of separation: