View HLPDTEST.STATEGPS.INCIDENT_SOFT_CLOSE_V 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  √  null
T_INSTANCES.INSTANCE_ID Implied Constraint R
WORKFLOW_TYPE_ID number 22  √  null
T_GPS_WORKFLOW_TYPES.WORKFLOW_TYPE_ID Implied Constraint R
CURRENT_STATE_ID number 22  √  null
PROPERTY_VALUE varchar2 100  √  null
END_STATE_ID number 22  √  null

Analyzed at Fri Dec 03 01:06 IST 2021

View Definition:
select a.instance_id,a.workflow_type_id,state_id current_state_id, b.issue_number property_value, (select state_id from stategps.t_gps_workflow_states ws where ws.state_type='END_STATE' and ws.workflow_type_id=c.workflow_type_id) end_state_id from stategps.t_instances a , tri2gps_dev.issues b ,stategps.t_gps_workflow_states c, stategps.t_gps_instances d where a.instance_id=b.instance_id and c.workflow_type_id=a.workflow_type_id and d.instance_id=a.instance_id and d.instance_present = 1 and d.current_state_id=c.state_id union select a.instance_id,a.workflow_type_id,state_id current_state_id, b.parent_issue_number property_value, (select state_id from stategps.t_gps_workflow_states ws where ws.state_type='END_STATE' and ws.workflow_type_id=c.workflow_type_id) end_state_id from stategps.t_instances a , tri2gps_dev.issues b ,stategps.t_gps_workflow_states c, stategps.t_gps_instances d where a.instance_id=b.instance_id and c.workflow_type_id=a.workflow_type_id and d.instance_id=a.instance_id and d.instance_present = 1 and d.current_state_id=c.state_id union select a.instance_id,a.workflow_type_id,state_id current_state_id, i.parent_issue_number property_value, (select state_id from stategps.t_gps_workflow_states ws where ws.state_type='END_STATE' and ws.workflow_type_id=c.workflow_type_id) end_state_id from stategps.t_instances a , tri2gps_dev.t_migration_requests b ,stategps.t_gps_workflow_states c, stategps.t_gps_instances d, tri2gps_dev.issues i where a.instance_id=b.instance_id and c.workflow_type_id=a.workflow_type_id and d.instance_id=a.instance_id and b.migration_request_number=i.issue_number and d.instance_present = 1 and d.current_state_id=c.state_id
 
Possibly Referenced Tables/Views:


Close relationships: