View HLPDTEST.STATEGPS.T_PROJECT_PLAN_REMOVED_TASKS_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
TASK_ID number 22
T_REPORTING_PLAN_TASKS.TASK_ID Implied Constraint R
START_DATE date 7  √  null
END_DATE date 7  √  null
TASK varchar2 1000  √  null
MODULE varchar2 50  √  null
WORKFLOW varchar2 255
PROJECT varchar2 255  √  null
DURATION number 22  √  null
DAYSREMAINING number 22  √  null
USER_ID number 22  √  null
T_GPS_USERS.USER_ID Implied Constraint R
STATE_ID number 22
T_GPS_WORKFLOW_STATES.STATE_ID Implied Constraint R
WORKFLOW_ID number 22
PROJECT_ID number 22
T_PROJECT_DETAILS.PROJECT_ID Implied Constraint R
WORKFLOW_ORDER number 22  √  null

Analyzed at Thu Aug 13 01:05 IST 2020

View Definition:
select tp.project_task_id, tp.start_date, tp.finish_date, coalesce(tws.description, tws.state_name), i.application_module, tgw.workflow_type_name, tga.application_name, tp.duration, tp.daysremaining, tp.user_id, tws.state_id, tgw.workflow_type_id, tga.application_id, tgw.workflow_order from t_gps_applications tga, t_gps_workflow_types tgw, t_gps_workflow_states tws, t_instances tgi, tri2gps_dev.issues i, t_project_task tp, t_project_task_history pph where tga.application_id = tgw.application_id and tgw.workflow_type_id = tws.workflow_type_id and tga.visible_flag = 'true' and tgw.visible_flag = 'true' and tgi.application_id = tga.application_id and tgw.workflow_type_id = tgi.workflow_type_id and tgi.instance_id = i.instance_id and tp.state_id = tws.state_id and tp.instance_id = i.instance_id and tgi.active = 0 and pph.project_task_id = tp.project_task_id and pph.execution_id = get_previous_history_id(tga.application_id)
 
Possibly Referenced Tables/Views:


Close relationships: