View HLPDTEST.STATEGPS.T_GPS_APP_WORKFLOW_VIEW 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
WORKFLOW_DESCRIPTION varchar2 1000  √  null

Analyzed at Fri Oct 30 01:06 IST 2020

View Definition:
( SELECT T1.APPLICATION_ID,T1.APPLICATION_NAME,T2.WORKFLOW_TYPE_ID,T2.WORKFLOW_TYPE_NAME, T2.DESCRIPTION "WORKFLOW_DESCRIPTION" FROM T_GPS_APPLICATIONS T1,T_GPS_WORKFLOW_TYPES T2 WHERE T1.APPLICATION_ID = T2.APPLICATION_ID )
 
Possibly Referenced Tables/Views:
T_GPS_APPLICATIONS T_GPS_WORKFLOW_TYPES 


Close relationships: