Table HLPDTEST.STATEGPS.T_GV_OLAP_CONFIGURATION 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
CONFIG_ID number 22
MY_FOLLOW_UP_V.CONFIG_ID Implied Constraint R
T_GV_CONDITIONAL_CONFIG.CONFIG_ID Implied Constraint R
VIEWER_INSTANCES_ID number 22  √  null
T_GPS_VIEWER_INSTANCES.VIEWER_INSTANCES_ID VIEWER_OLAP_FKY C
DIMENSION varchar2 255  √  null
DIMENSION_LEVEL varchar2 255  √  null
JOINING_TABLE varchar2 255  √  null
JOINING_CONDITION varchar2 4000  √  null
GROUP_BY_COLUMN varchar2 255  √  null

Table contained 442 rows at Wed Oct 28 01:06 IST 2020

Indexes:
Column(s) Type Sort Constraint Name Anomalies
CONFIG_ID Primary key Asc SYS_C0015975  
VIEWER_INSTANCES_ID + DIMENSION + DIMENSION_LEVEL Must be unique Asc/Asc/Asc VIEWER_OLAP_UNIQUE These unique columns are also nullable

Close relationships  within of separation: