View HLPDTEST.STATEGPS.PROJECT_LINKED_TESTCASES_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
APPLICATION_ID number 22  √  null
T_GPS_APPLICATIONS.APPLICATION_ID Implied Constraint R

Analyzed at Thu Aug 13 01:05 IST 2020

View Definition:
select max(maxtc.case_id) case_id,bsm.replay_sequence,ins.application_id from t_instances ins, v_instance_props prop, tri2gps_dev.links links, tri2gps_dev.issues iss, tri2gps_dev.test_cases tc, tri2gps_dev.test_Cases maxtc, tri2gps_dev.bsm_main bsm, T_GPS_APPLICATIONS APP, T_GPS_APP_PROPERTIES APP_PROP where prop.INSTANCE_ID = ins.instance_id and links.reference_type like 'TC' and links.link_type = 'ISS' and iss.issue_id = links.entity_id and tc.case_id = links.reference_identifier and maxtc.bsm_number = tc.bsm_number and iss.issue_number = prop.IA_ISSUE_NUMBER and maxtc.bsm_number = bsm.bsm_number and ins.application_id = app.application_id AND (APP.VISIBLE_FLAG = 'true' OR APP.VISIBLE_FLAG IS NULL) AND APP_PROP.APPLICATION_ID = APP.APPLICATION_ID AND APP_PROP.PROPERTY_NAME = 'RT_EXECUTION_TYPE' AND APP_PROP.PROPERTY_VALUE ='PROJECT' group by bsm.replay_sequence,maxtc.bsm_number,ins.application_id
 
Possibly Referenced Tables/Views:


Close relationships: