Table HLPDTEST.STATEGPS.T_GPS_COMPRESSED_PATHS 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
COMPRESSED_PATH_ID number 22
T_GPS_COM_PATH_CLASSES.COMPRESSED_PATH_ID FK_T_GPS_COM_PATH_CLASSES C
APPLICATION_ID number 22  √  null
T_GPS_APPLICATIONS.APPLICATION_ID FK_T_GPS_COMPRESSED_PATHS C
EDYNAMO_CLASS varchar2 255  √  null
COMPRESSION_BY varchar2 10  √  null
GROUPBY_COMPRESSION varchar2 10  √  null
COMPRESSED_PATH_NAME varchar2 30  √  null

Table contained 2 rows at Tue Aug 11 01:05 IST 2020

Indexes:
Column(s) Type Sort Constraint Name
APPLICATION_ID Performance Asc T_GPS_COMPD_PATHS_APP_ID_INDEX
COMPRESSED_PATH_ID + APPLICATION_ID + COMPRESSED_PATH_NAME Performance Asc/Asc/Asc T_GPS_COMPRESSED_PATHS_INDEX

Close relationships  within of separation: