View HLPDTEST.STATEGPS.V_INSTANCE_PROPS 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
INSTANCE_ID number 22
T_GPS_WORKFLOW_INSTANCES.INSTANCE_ID Implied Constraint R
PRIORITY number 22  √  null
IA_ISSUE_NUMBER varchar2 4000  √  null
IA_ISSUE_TITLE varchar2 4000  √  null

Analyzed at Sat Oct 31 01:06 IST 2020

View Definition:
select i.instance_id, i.priority, property_value AS IA_ISSUE_NUMBER, (select property_value from t_gps_instance_properties where instance_id = ip.instance_id and property_name = 'tri2.SG_TRI2_ENTITY.IA_ISSUE_TITLE') IA_ISSUE_TITLE from t_gps_instance_properties ip, t_instances i where ip.instance_id = i.instance_id and property_name = 'tri2.SG_TRI2_ENTITY.IA_ISSUE_NUMBER' and property_value is not null
 
Possibly Referenced Tables/Views:


Close relationships: