Table HLPDTEST.STATEGPS.T_GPS_CLASS_TABGROUPS 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
CLASS_ID number 22  √  null
T_GPS_NT_STATE_CLASSES.CLASS_ID FK_T_GPS_CLASS_TABGROUPS C
TAB_ID number 22
T_GPS_CLASS_TABGROUP_CHILDS.TAB_ID FK_T_GPS_CLASS_TABGROUP_CHILDS C
T_GPS_PROPERTY_ORDER.TAB_ID FK_T_GPS_PROPERTY_ORDER C
T_GPS_VIEWER_CLASS_TABGROUPS.TAB_ID Implied Constraint R
TAB_NAME varchar2 255
DISPLAY varchar2 10  √  null
TAB_COLOR varchar2 255  √  null
FOCUS_ON varchar2 10  √  null
DISPLAY_ON varchar2 10  √  'TRUE'

Table contained 36,855 rows at Tue Aug 11 01:05 IST 2020

Indexes:
Column(s) Type Sort Constraint Name
TAB_ID Primary key Asc SYS_C0010003
CLASS_ID + TAB_ID Performance Asc/Asc T_GPS_CLASS_TABGROUPS_INDEX

Close relationships  within of separation: