View HLPDTEST.STATEGPS.XXCAVIUM_SUPPORT_DAILY_OPEN 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
APPLICATION_NAME varchar2 255  √  null
IA_ISSUE_NUMBER varchar2 4000  √  null
STATE_NAME varchar2 255  √  null

Analyzed at Mon May 23 01:05 IST 2022

View Definition:
select tpa.application_name, vip.ia_issue_number, tgws.state_name from t_gps_applications tpa, t_instances ti, t_gps_instances tgi, v_instance_props vip, t_gps_workflow_types tgwt, t_gps_workflow_states tgws, t_project_task tpt where tpa.application_name like 'Cavium Support Project' and tpa.application_id = ti.application_id and ti.instance_id = tgi.instance_id and tgi.instance_present = 1 and vip.instance_id = ti.instance_id and tpa.application_id = tgwt.application_id and tgwt.workflow_type_id = tgws.workflow_type_id and tgi.current_state_id = tgws.state_id and tpt.instance_id = ti.instance_id and tpt.state_id = tgws.state_id
 
Possibly Referenced Tables/Views: