View HLPDTEST.STATEGPS.T_PROJECT_DA_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
STATE_ID number 22  √  null
T_GPS_WORKFLOW_STATES.STATE_ID Implied Constraint R
TASK_ID varchar2 2500  √  null
TASK_NAME varchar2 2258  √  null

Analyzed at Wed Oct 28 01:06 IST 2020

View Definition:
(SELECT A.STATE_ID, A.TASK_ID, A.TASK_NAME || ' @ ' || B.STATE_NAME AS TASK_NAME FROM T_PROJECT_TASK A, T_GPS_WORKFLOW_STATES B WHERE A.TASK_NAME != B.STATE_NAME AND A.STATE_ID = B.STATE_ID) UNION (SELECT A.STATE_ID, A.TASK_ID, A.TASK_NAME FROM T_PROJECT_TASK A, T_GPS_WORKFLOW_STATES B WHERE A.TASK_NAME = B.STATE_NAME AND A.STATE_ID = B.STATE_ID)
 
Possibly Referenced Tables/Views:


Close relationships: