Table HLPDTEST.STATEGPS.T_GPS_DRILL_DOWN_PROPERTIES 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
DRILL_DOWN_PROPERTY_ID number 22
T_GPS_DRILL_DOWN_CONDITION.DRILL_DOWN_PROPERTY_ID FK_DD_PROPERTY_ID C
T_GPS_VDD_BUILDFR_MAPPINGS.DRILL_DOWN_PROPERTY_ID FK_T_GPS_VDD_BUILDFR_MAPPINGS C
T_GPS_VDD_COLUMNS_MAPPING.DRILL_DOWN_PROPERTY_ID FK_T_GPS_VDD_COLUMNS_MAPPING C
T_GPS_VDD_CUSTOMLINK_MAPPINGS.DRILL_DOWN_PROPERTY_ID FK_CUSTOMLINK_MAPPINGS C
T_GPS_VIEWER_DRILL_DOWNS.DRILL_DOWN_PROPERTY_ID Implied Constraint R
PROPERTY_ID number 22  √  null
T_GPS_VIEWER_INST_CLASS_PROPS.PROPERTY_ID FK_T_GPS_DRILL_DOWN_PROPERTIES C
APPLICATION varchar2 255  √  null
OBJECT_TYPES varchar2 255  √  null
OBJECT varchar2 4000  √  null
DESCRIPTION varchar2 1000  √  null
DATA_SOURCE varchar2 255  √  null
INVOCATION_TYPE varchar2 255  √  null
EXTRA_INFO varchar2 4000  √  null
DRILLDOWN_ORDER number 22  √  null

Table contained 7,802 rows at Fri Oct 30 01:06 IST 2020

Indexes:
Column(s) Type Sort Constraint Name
DRILL_DOWN_PROPERTY_ID Primary key Asc SYS_C0010014
PROPERTY_ID Performance Asc T_GPS_DRILL_DOWN_PROP_INDEX

Close relationships  within of separation: