Table HLPDTEST.STATEGPS.T_GPS_MENUCONFIG_RELATIONS 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
MENU_ORDER_ID number 22
MENU_ID number 22  √  null
T_GPS_MENUCONFIG.MENU_ID FK_T_GPS_MENUCONFIG_RELATIONS C
CHILD_MENU_ID number 22  √  null
T_GPS_MENUCONFIG.MENU_ID FKCHILD_MENUCONFIG_RELATIONS C

Table contained 153,497 rows at Sat Dec 05 01:06 IST 2020

Indexes:
Column(s) Type Sort Constraint Name
MENU_ORDER_ID Primary key Asc PK_T_GPS_MENUCONFIG_RELATIONS
MENU_ID + MENU_ORDER_ID Performance Asc/Asc T_GPS_MENU_REL_INDEX
CHILD_MENU_ID Performance Asc T_GPS_MENUCONFIG_RELATIONS_CN1

Close relationships  within of separation: