View HLPDTEST.STATEGPS.T_GPS_APP_WORKFLOW_STATES_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
STATE_ID number 22
T_GPS_WORKFLOW_STATES.STATE_ID Implied Constraint R
STATE_NAME varchar2 255  √  null
STATES_DESCRIPTION varchar2 1000  √  null

Analyzed at Sun Nov 29 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",T3.STATE_ID,T3.STATE_NAME,T3.DESCRIPTION "STATES_DESCRIPTION" FROM T_GPS_APPLICATIONS T1,T_GPS_WORKFLOW_TYPES T2,T_GPS_WORKFLOW_STATES T3 WHERE T1.APPLICATION_ID = T2.APPLICATION_ID AND T2.WORKFLOW_TYPE_ID = T3.WORKFLOW_TYPE_ID )
 
Possibly Referenced Tables/Views:
T_GPS_APPLICATIONS T_GPS_WORKFLOW_STATES T_GPS_WORKFLOW_TYPES 


Close relationships: