View HLPDTEST.STATEGPS.XXCAVIUM_SUPPORT_DAILY_SUMMARY 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
MOVED_OUT_DATE date 7  √  null
INSTANCE_ID number 22
T_GPS_WORKFLOW_INSTANCES.INSTANCE_ID Implied Constraint R
IA_ISSUE_NUMBER varchar2 4000  √  null
IA_ISSUE_TITLE varchar2 4000  √  null
STATE_NAME varchar2 255  √  null
INSTANCE_PRESENT number 22  √  null
BILLABLE_HOURS number 22  √  null
NON_BILLABLE_HOURS number 22  √  null
EXTRA_BILLABLE_HOURS number 22  √  null
CREATED_DATE date 7  √  null

Analyzed at Sun Oct 18 01:05 IST 2020

View Definition:
select tpa.application_name, tgi.moved_out_date, ti.instance_id, vip.ia_issue_number, vip.ia_issue_title, tgws.state_name, tgi.instance_present, nvl(tpa.billable_hours, 0) billable_hours, nvl(tpa.non_billable_hours, 0) non_billable_hours, nvl(tpa.extra_billable_hours, 0) extra_billable_hours, tpa.created_date 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, t_project_activity tpa where tpa.application_name = 'Cavium Support Project' and tpa.application_id = ti.application_id and ti.instance_id = tgi.instance_id 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 and tpt.project_task_id = tpa.project_task_id(+)
 
Possibly Referenced Tables/Views:


Close relationships: