View HLPDTEST.STATEGPS.ISSUE_MODULE_LINKED_TC_VW 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
CASE_ID number 22  √  null
REPLAY_SEQUENCE number 22  √  null
INSTANCE_ID number 22
T_GPS_WORKFLOW_INSTANCES.INSTANCE_ID Implied Constraint R

Analyzed at Sun Oct 18 01:05 IST 2020

View Definition:
select max(maxtc.case_id) case_id,bsm.replay_sequence,inp.instance_id from t_gps_instance_properties inp,tri2gps_dev.issues iss,tri2gps_dev.issues issues, tri2gps_dev.links links, tri2gps_dev.test_cases tc,tri2gps_dev.test_cases maxtc, tri2gps_dev.bsm_main bsm where inp.property_name = 'tri2.SG_TRI2_ENTITY.IA_ISSUE_NUMBER' and iss.issue_number = inp.property_value and issues.application_module= iss.application_module and links.link_type='ISS' and links.reference_type='TC' and links.entity_id= issues.issue_id and links.reference_identifier=tc.case_id and maxtc.bsm_number = tc.bsm_number and maxtc.bsm_number = bsm.bsm_number and (bsm.active_flag is null or bsm.active_flag = 'true') -- and inp.instance_id = 186099 group by bsm.replay_sequence,maxtc.bsm_number,inp.instance_id
 
Possibly Referenced Tables/Views:


Close relationships: