View HLPDTEST.STATEGPS.T_WORKFLOW_STATE_TASK_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
T_GPS_WORKFLOW_STATES.STATE_ID Implied Constraint R
STATE_NAME varchar2 255  √  null

Analyzed at Tue Aug 11 01:05 IST 2020

View Definition:
SELECT A.STATE_ID,A.STATE_NAME FROM T_GPS_WORKFLOW_STATES A , T_GPS_NODETYPE_STATES B WHERE A.STATE_ID = B.STATE_ID
 
Possibly Referenced Tables/Views:
T_GPS_NODETYPE_STATES T_GPS_WORKFLOW_STATES 


Close relationships: