View HLPDTEST.STATEGPS.T_INSTANCE_OWNER_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
OWNER varchar2 500  √  null
INSTANCE_ID number 22  √  null
T_GPS_WORKFLOW_INSTANCES.INSTANCE_ID Implied Constraint R
CURRENT_STATE_ID number 22  √  null
CREATED_DATE date 7  √  null

Analyzed at Sun Oct 18 01:05 IST 2020

View Definition:
SELECT A.OWNER,A.INSTANCE_ID,A.CURRENT_STATE_ID,A.CREATED_DATE FROM T_GPS_INSTANCES A WHERE A.CREATED_DATE = (SELECT MIN(Y.CREATED_DATE) FROM T_GPS_INSTANCES Y WHERE A.INSTANCE_ID = Y.INSTANCE_ID AND Y.CURRENT_STATE_ID = (SELECT MIN(X.CURRENT_STATE_ID) FROM T_GPS_INSTANCES X WHERE A.INSTANCE_ID = X.INSTANCE_ID))
 
Possibly Referenced Tables/Views:


Close relationships: