View HLPDTEST.STATEGPS.T_PROJECT_ISSUES_STATUS_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_ID number 22
T_GPS_APPLICATIONS.APPLICATION_ID Implied Constraint R
APPLICATION_NAME varchar2 255  √  null
WORKFLOW_TYPE_ID number 22
T_GPS_WORKFLOW_TYPES.WORKFLOW_TYPE_ID Implied Constraint R
WORKFLOW_TYPE_NAME varchar2 255
INSTANCE_ID number 22
T_GPS_WORKFLOW_INSTANCES.INSTANCE_ID Implied Constraint R
IA_ISSUE_NUMBER varchar2 4000  √  null
IA_ISSUE_TITLE varchar2 4000  √  null
ISSUE_ID number 20
CREATED_DATE date 7  √  null
ISSUE_TYPE varchar2 100  √  null
REPORTED_BY varchar2 255  √  null
RAISED_DUETO varchar2 255  √  null
APPLICATION_MODULE varchar2 50  √  null
ISSUE_TYPE_CATEGORY varchar2 11  √  null
COUNT number 22  √  null

Analyzed at Sat Dec 05 01:06 IST 2020

View Definition:
SELECT T_GPS_APPLICATIONS.APPLICATION_ID , T_GPS_APPLICATIONS.APPLICATION_NAME , T_GPS_WORKFLOW_TYPES.WORKFLOW_TYPE_ID , T_GPS_WORKFLOW_TYPES.WORKFLOW_TYPE_NAME , T_INSTANCES.INSTANCE_ID , V_INSTANCE_PROPS.IA_ISSUE_NUMBER , V_INSTANCE_PROPS.IA_ISSUE_TITLE , ISSUES.ISSUE_ID , ISSUES.CREATED_DATE , ISSUES.ISSUE_TYPE , ISSUES.REPORTED_BY , ISSUES.RAISED_DUETO , ISSUES.APPLICATION_MODULE, DECODE(ISSUES.ISSUE_TYPE,'5.Enhancements-Nice To Have','Enhancement' ,'4.Enhancements-Critical','Enhancement' ,'Enhancement','Enhancement' ,'Enhancements','Enhancement' ,'2.Bugs without workaround','Bug' ,'3.Bugs with workaround','Bug' ,'Bug','Bug') as ISSUE_TYPE_CATEGORY, 1 AS COUNT FROM STATEGPS.V_INSTANCE_PROPS V_INSTANCE_PROPS , STATEGPS.T_INSTANCES T_INSTANCES , STATEGPS.T_GPS_INSTANCES T_GPS_INSTANCES , STATEGPS.T_GPS_APPLICATIONS T_GPS_APPLICATIONS , STATEGPS.T_GPS_WORKFLOW_TYPES T_GPS_WORKFLOW_TYPES , TRI2GPS_DEV.ISSUES ISSUES WHERE T_GPS_APPLICATIONS.APPLICATION_ID = T_INSTANCES.APPLICATION_ID AND T_GPS_INSTANCES.FROM_STATE_ID = ( SELECT MIN(STATE_ID) FROM T_GPS_WORKFLOW_STATES WHERE WORKFLOW_TYPE_ID = T_GPS_WORKFLOW_TYPES.WORKFLOW_TYPE_ID AND T_GPS_WORKFLOW_TYPES.APPLICATION_ID=T_INSTANCES.APPLICATION_ID ) AND V_INSTANCE_PROPS.INSTANCE_ID = T_INSTANCES.INSTANCE_ID AND T_GPS_INSTANCES.INSTANCE_ID = T_INSTANCES.INSTANCE_ID AND ISSUES.ISSUE_NUMBER = V_INSTANCE_PROPS.IA_ISSUE_NUMBER AND T_GPS_INSTANCES.WORKFLOW_TYPE_ID = T_GPS_WORKFLOW_TYPES.WORKFLOW_TYPE_ID AND T_INSTANCES.ACTIVE = 1 AND T_GPS_INSTANCES.VISIBLE_FLAG IS NULL
 
Possibly Referenced Tables/Views:


Close relationships: