View HLPDTEST.STATEGPS.TAG_BASED_PLAN_CONFIG_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
TAG_CONG varchar2 5  √  null
TAG_BASELINE varchar2 5  √  null
PROJECT_ID number 22
T_PROJECT_DETAILS.PROJECT_ID Implied Constraint R

Analyzed at Fri Dec 03 01:06 IST 2021

View Definition:
SELECT CASE WHEN COUNT(T_GPS_WORKFLOW_STATES.PROJECT_TAG_ID)= COUNT(T_PROJECT_TASK.PROJECT_TASK_ID)THEN 'true' ELSE 'false' END TAG_CONG, CASE WHEN COUNT(T_INSTANCES.INSTANCE_ID)> 0 THEN 'false' ELSE 'true' END TAG_BASELINE, T_GPS_APPLICATIONS.APPLICATION_ID PROJECT_ID FROM STATEGPS.T_GPS_APPLICATIONS T_GPS_APPLICATIONS LEFT OUTER JOIN T_INSTANCES T_INSTANCES ON T_INSTANCES.APPLICATION_ID = T_GPS_APPLICATIONS.APPLICATION_ID JOIN STATEGPS.T_GPS_WORKFLOW_TYPES T_GPS_WORKFLOW_TYPES ON T_GPS_APPLICATIONS.APPLICATION_ID = T_GPS_WORKFLOW_TYPES.APPLICATION_ID AND T_GPS_WORKFLOW_TYPES.VISIBLE_FLAG = 'true' JOIN STATEGPS.T_GPS_WORKFLOW_STATES T_GPS_WORKFLOW_STATES ON T_GPS_WORKFLOW_TYPES.WORKFLOW_TYPE_ID = T_GPS_WORKFLOW_STATES.WORKFLOW_TYPE_ID AND T_GPS_WORKFLOW_STATES.VISIBLE_FLAG = 'true' JOIN STATEGPS.T_PROJECT_TASK T_PROJECT_TASK ON T_GPS_WORKFLOW_STATES.STATE_ID = T_PROJECT_TASK.STATE_ID AND T_PROJECT_TASK.INSTANCE_ID IS NULL GROUP BY T_GPS_APPLICATIONS.APPLICATION_ID
 
Possibly Referenced Tables/Views:


Close relationships: