View HLPDTEST.STATEGPS.PROJECT_NATIVE_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
APPLICATION_NAME varchar2 255  √  null
WORKFLOW_TYPE_NAME varchar2 255  √  null
PROJECT_TASK_ID number 22  √  null
T_PROJECT_TASK.PROJECT_TASK_ID Implied Constraint R
TASK_NAME varchar2 2000  √  null
RESOURCE_NAME varchar2 2000  √  null
ROLE_ID number 22  √  null
T_GPS_ROLES.ROLE_ID Implied Constraint R
USER_NAME varchar2 2000  √  null
USER_ID number 22  √  null
T_GPS_USERS.USER_ID Implied Constraint R
START_DATE date 7  √  null
FINISH_DATE date 7  √  null
DURATION number 22  √  null
STATE_ID number 22  √  null
T_GPS_WORKFLOW_STATES.STATE_ID Implied Constraint R
STATE_ID_STR varchar2 40  √  null

Analyzed at Fri Oct 30 01:06 IST 2020

View Definition:
( SELECT T_GPS_APPLICATIONS.APPLICATION_NAME , T_GPS_WORKFLOW_TYPES.WORKFLOW_TYPE_NAME , T_PROJECT_TASK.PROJECT_TASK_ID , T_PROJECT_TASK.TASK_NAME , T_PROJECT_TASK.RESOURCE_NAME , T_PROJECT_TASK.ROLE_ID , T_PROJECT_TASK.USER_NAME , T_PROJECT_TASK.USER_ID , T_PROJECT_TASK.START_DATE , T_PROJECT_TASK.FINISH_DATE , T_PROJECT_TASK.DURATION , T_PROJECT_TASK.STATE_ID STATE_ID, TO_CHAR(T_GPS_WORKFLOW_STATES.STATE_ID) STATE_ID_STR FROM STATEGPS.T_GPS_APPLICATIONS T_GPS_APPLICATIONS, STATEGPS.T_GPS_APP_PROPERTIES T_GPS_APP_PROPERTIES, STATEGPS.T_GPS_WORKFLOW_TYPES T_GPS_WORKFLOW_TYPES, STATEGPS.T_GPS_WORKFLOW_STATES T_GPS_WORKFLOW_STATES, STATEGPS.T_PROJECT_TASK T_PROJECT_TASK WHERE T_PROJECT_TASK.STATE_ID = T_GPS_WORKFLOW_STATES.STATE_ID AND T_PROJECT_TASK.TASK_NAME = T_GPS_WORKFLOW_STATES.STATE_NAME AND T_GPS_WORKFLOW_TYPES.APPLICATION_ID = T_GPS_APPLICATIONS.APPLICATION_ID AND T_GPS_APP_PROPERTIES.APPLICATION_ID = T_GPS_APPLICATIONS.APPLICATION_ID AND T_GPS_APP_PROPERTIES.PROPERTY_NAME = 'PROJECTPLAN_APPLICATION' AND T_GPS_APP_PROPERTIES.PROPERTY_VALUE = 'TRUE' AND T_GPS_WORKFLOW_STATES.WORKFLOW_TYPE_ID = T_GPS_WORKFLOW_TYPES.WORKFLOW_TYPE_ID AND ( T_GPS_APPLICATIONS.VISIBLE_FLAG IS NULL OR T_GPS_APPLICATIONS.VISIBLE_FLAG = 'true' ) UNION SELECT T_GPS_APPLICATIONS.APPLICATION_NAME , T_GPS_WORKFLOW_TYPES.WORKFLOW_TYPE_NAME , NULL , T_GPS_WORKFLOW_STATES.STATE_NAME , NULL , NULL , NULL , NULL , NULL , NULL , NULL , T_GPS_WORKFLOW_STATES.STATE_ID , TO_CHAR(T_GPS_WORKFLOW_STATES.STATE_ID) STATE_ID_STR FROM STATEGPS.T_GPS_APPLICATIONS T_GPS_APPLICATIONS, STATEGPS.T_GPS_APP_PROPERTIES T_GPS_APP_PROPERTIES, STATEGPS.T_GPS_WORKFLOW_TYPES T_GPS_WORKFLOW_TYPES, STATEGPS.T_GPS_WORKFLOW_STATES T_GPS_WORKFLOW_STATES WHERE T_GPS_APPLICATIONS.APPLICATION_ID = T_GPS_WORKFLOW_TYPES.APPLICATION_ID AND T_GPS_WORKFLOW_TYPES.WORKFLOW_TYPE_ID = T_GPS_WORKFLOW_STATES.WORKFLOW_TYPE_ID AND T_GPS_WORKFLOW_STATES.STATE_DESCRIPTOR NOT IN ( 'Workflow','Workflow Start','Workflow End','AND State' ) AND NOT EXISTS ( SELECT T_PROJECT_TASK.STATE_ID FROM STATEGPS.T_PROJECT_TASK T_PROJECT_TASK WHERE T_GPS_WORKFLOW_STATES.STATE_ID = T_PROJECT_TASK.STATE_ID ) AND T_GPS_APPLICATIONS.APPLICATION_ID = T_GPS_APP_PROPERTIES.APPLICATION_ID AND T_GPS_APP_PROPERTIES.PROPERTY_NAME = 'PROJECTPLAN_APPLICATION' AND T_GPS_APP_PROPERTIES.PROPERTY_VALUE = 'TRUE' AND ( T_GPS_APPLICATIONS.VISIBLE_FLAG = 'true' OR T_GPS_APPLICATIONS.VISIBLE_FLAG IS NULL ) )
 
Possibly Referenced Tables/Views:


Close relationships: