View HLPDTEST.STATEGPS.T_INSTANCE_DOCUMENTS_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
ISSUE_NUMBER varchar2 100  √  null
PARENT_ISSUE_NUMBER varchar2 100  √  null
STATE_TYPE varchar2 50  √  null
STATE_NAME varchar2 255  √  null
DOCUMENT varchar2 4000  √  null
STATE_ID number 22  √  null
T_GPS_WORKFLOW_STATES.STATE_ID Implied Constraint R

Analyzed at Sat Oct 31 01:06 IST 2020

View Definition:
SELECT ISSUES.ISSUE_NUMBER, ISSUES.PARENT_ISSUE_NUMBER, STATE_TYPE, STATE_NAME, T_INSTANCE_DOCUMENTS.DOCUMENT || '/' || T_INSTANCE_CHILD_DOCS.DOCUMENT_NAME AS DOCUMENT, T_INSTANCE_CHILD_DOCS.STATE_ID FROM TRI2GPS_DEV.ISSUES ISSUES, STATEGPS.T_INSTANCE_DOCUMENTS T_INSTANCE_DOCUMENTS, TRI2GPS_DEV.ISSUES ISSUES1, STATEGPS.T_GPS_WORKFLOW_STATES T_GPS_WORKFLOW_STATES RIGHT OUTER JOIN STATEGPS.T_INSTANCE_CHILD_DOCS T_INSTANCE_CHILD_DOCS ON T_INSTANCE_CHILD_DOCS.STATE_ID = T_GPS_WORKFLOW_STATES.STATE_ID WHERE T_INSTANCE_DOCUMENTS.DOCUMENT_ID = T_INSTANCE_CHILD_DOCS.DOCUMENT_ID AND ((ISSUES.INSTANCE_ID = T_INSTANCE_DOCUMENTS.INSTANCE_ID) OR (ISSUES1.INSTANCE_ID = T_INSTANCE_DOCUMENTS.INSTANCE_ID)) AND ISSUES.PARENT_ISSUE_NUMBER = ISSUES1.ISSUE_NUMBER AND ISSUES.ISSUE_NUMBER IS NOT NULL
 
Possibly Referenced Tables/Views:


Close relationships: