View HLPDTEST.STATEGPS.T_PROJECT_NATIVE_TASK_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
STATE_ID number 22  √  null
T_GPS_WORKFLOW_STATES.STATE_ID Implied Constraint R
STATE_NAME varchar2 255  √  null
STATE_DESCRIPTOR varchar2 100  √  null
PROJECT_TASK_ID number 22  √  null
T_PROJECT_TASK.PROJECT_TASK_ID Implied Constraint R
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
DURATION number 22  √  null
PROJECT_ID number 22  √  null
T_PROJECT_DETAILS.PROJECT_ID Implied Constraint R
STATE_ORDER number 22  √  null

Analyzed at Sun Nov 29 01:06 IST 2020

View Definition:
SELECT T_GPS_APPLICATIONS.APPLICATION_NAME , T_GPS_WORKFLOW_TYPES.WORKFLOW_TYPE_NAME , T_GPS_WORKFLOW_STATES.STATE_ID , T_GPS_WORKFLOW_STATES.STATE_NAME , T_GPS_WORKFLOW_STATES.STATE_DESCRIPTOR , T_PROJECT_TASK.PROJECT_TASK_ID , T_PROJECT_TASK.RESOURCE_NAME , T_PROJECT_TASK.ROLE_ID , T_PROJECT_TASK.USER_NAME , T_PROJECT_TASK.USER_ID , T_PROJECT_TASK.DURATION, T_GPS_APPLICATIONS.APPLICATION_ID, T_GPS_WORKFLOW_STATES.STATE_ORDER FROM STATEGPS.T_GPS_APPLICATIONS T_GPS_APPLICATIONS , 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_GPS_WORKFLOW_TYPES.APPLICATION_ID = T_GPS_APPLICATIONS.APPLICATION_ID AND T_GPS_WORKFLOW_STATES.WORKFLOW_TYPE_ID = T_GPS_WORKFLOW_TYPES.WORKFLOW_TYPE_ID AND T_PROJECT_TASK.INSTANCE_ID IS NULL AND ( T_GPS_APPLICATIONS.VISIBLE_FLAG = 'true' OR T_GPS_APPLICATIONS.VISIBLE_FLAG IS NULL ) AND T_GPS_WORKFLOW_STATES.STATE_DESCRIPTOR IN ( 'Default State','Notification State','Start State','Stop State','Escalation State') UNION SELECT T_GPS_APPLICATIONS.APPLICATION_NAME , T_GPS_WORKFLOW_TYPES.WORKFLOW_TYPE_NAME , T_GPS_WORKFLOW_STATES.STATE_ID , T_GPS_WORKFLOW_STATES.STATE_NAME , T_GPS_WORKFLOW_STATES.STATE_DESCRIPTOR , NULL , NULL , NULL , NULL , NULL , NULL, T_GPS_APPLICATIONS.APPLICATION_ID, T_GPS_WORKFLOW_STATES.STATE_ORDER FROM STATEGPS.T_GPS_APPLICATIONS T_GPS_APPLICATIONS , 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 IN ( 'Default State','Notification State','Start State','Stop State','Escalation 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_PROJECT_TASK.INSTANCE_ID IS NULL ) AND ( T_GPS_APPLICATIONS.VISIBLE_FLAG = 'true' OR T_GPS_APPLICATIONS.VISIBLE_FLAG IS NULL )
 
Possibly Referenced Tables/Views:


Close relationships: