View HLPDTEST.STATEGPS.T_TASK_PRIORITY_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_NAME varchar2 2000  √  null
TASK_ID varchar2 2500  √  null
PRIORITY number 22  √  null
APPLICATION_NAME varchar2 255  √  null

Analyzed at Mon May 23 01:05 IST 2022

View Definition:
( SELECT UNIQUE PROJECTTASKS.TASK_NAME, PROJECTTASKS.TASK_ID, PROJECTTASKS.PRIORITY, APPLICATIONS.APPLICATION_NAME FROM T_GPS_APPLICATIONS APPLICATIONS, T_GPS_WORKFLOW_TYPES WORKFLOWS, T_GPS_WORKFLOW_STATES STATES, T_PROJECT_TASK PROJECTTASKS WHERE PROJECTTASKS.STATE_ID = STATES.STATE_ID AND STATES.WORKFLOW_TYPE_ID = WORKFLOWS.WORKFLOW_TYPE_ID AND WORKFLOWS.APPLICATION_ID = APPLICATIONS.APPLICATION_ID AND PROJECTTASKS.TASK_NAME IS NOT NULL AND PROJECTTASKS.INSTANCE_ID IS NOT NULL and (APPLICATIONS.VISIBLE_FLAG IS NULL OR APPLICATIONS.VISIBLE_FLAG = 'true') )
 
Possibly Referenced Tables/Views: