Table HLPDTEST.STATEGPS.T_GPS_VIEWER_ADV_GRAPH_CONFIG 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
EWKS_GRAPH_CONFIG_ID number 22
T_GPS_VIEWER_ADV_GRAPH_DATA.EWKS_GRAPH_CONFIG_ID FK_EWKS_GRAPH_CONFIG_DATA C
GRAPH_TYPE varchar2 30  √  null
GRAPH_CONFIG_PROPERTY varchar2 100  √  null
GRAPH_CONFIG_ACTUAL_PROPERTY varchar2 400  √  null
GRAPH_CONFIG_PROPERTY_TYPE varchar2 40  √  null
DESCRIPTION varchar2 2000  √  null

Table contained 116 rows at Fri Aug 14 01:05 IST 2020

Indexes:
Column(s) Type Sort Constraint Name Anomalies
EWKS_GRAPH_CONFIG_ID Primary key Asc SYS_C0034501  
GRAPH_TYPE + GRAPH_CONFIG_PROPERTY Must be unique Asc/Asc UNIQUE_GRAPH_ADV_PROP These unique columns are also nullable

Close relationships  within of separation: