View HLPDTEST.STATEGPS.T_PROJECT_CURRENT_PLAN_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
EXECUTION_ID number 22  √  null
T_GPS_SERVER_MEMORY_STATUS.EXECUTION_ID Implied Constraint R
PROJECT_TASK_ID number 22  √  null
T_PROJECT_TASK.PROJECT_TASK_ID Implied Constraint R
START_DATE date 7  √  null
END_DATE date 7  √  null
TAG varchar2 1000  √  null
MODULE varchar2 50  √  null
PROJECT_ID number 22  √  null
T_PROJECT_DETAILS.PROJECT_ID Implied Constraint R
WORKFLOW_ID number 22  √  null
STATE_ID number 22  √  null
T_GPS_WORKFLOW_STATES.STATE_ID Implied Constraint R
RESOURCE_ID number 22  √  null
DURATION number 22  √  null
DAYS_REMAINING number 22  √  null
DURATION_DIFFERENCE number 22  √  null
TASK_ADDED varchar2 5  √  null
TASK_REMOVED varchar2 5  √  null
TASK_COMPLETED varchar2 5  √  null
WORKFLOW_ORDER number 22  √  null

Analyzed at Fri Sep 25 01:05 IST 2020

View Definition:
select h.execution_id, p."TASK_ID",p."START_DATE",p."END_DATE",p."TASK",p."MODULE",p."PROJECT_ID",p."WORKFLOW_ID",p."STATE_ID",p."USER_ID",p."DURATION",p."DAYSREMAINING",p."DURATION_DIFFERENCE",p."TASK_ADDED",p."TASK_REMOVED",p."TASK_COMPLETED",p."WORKFLOW_ORDER" from (select max(history_id) execution_id, project_id from t_reporting_plan_history group by project_id) h, (select task_id, start_date, end_date, task, module, project_id, workflow_id, state_id, user_id, duration, daysremaining, duration_difference, decode(task_count, 0, 'false', 'true') task_added, 'false' task_removed, decode(tasks_completed, 0, 'false', 'true') task_completed, workflow_order from t_project_plan_tasks_v union all select task_id, start_date, end_date, task, module, project_id, workflow_id, state_id, user_id, duration, daysremaining, 0 duration_difference, 'false' task_added, 'true' task_removed, 'false' task_completed, workflow_order from t_project_plan_removed_tasks_v) p where h.project_id = p.project_id -- and p.project_id = 8522
 
Possibly Referenced Tables/Views:


Close relationships: