View HLPDTEST.STATEGPS.T_GPS_APPLICATION_NODE_TYPES 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 varchar2 255  √  null
APPLICATION_ID number 22  √  null
T_GPS_APPLICATIONS.APPLICATION_ID Implied Constraint R
WORK_FLOW varchar2 255  √  null
WORKFLOW_TYPE_ID number 22  √  null
T_GPS_WORKFLOW_TYPES.WORKFLOW_TYPE_ID Implied Constraint R
STATE varchar2 255  √  null
NODE_TYPE varchar2 255  √  null
UPDATED_DATE date 7  √  null
DESCRIPTION varchar2 1000  √  null
NODETYPE_STATE_ID number 22  √  null
T_GPS_NODETYPE_STATES.NODETYPE_STATE_ID Implied Constraint R
NODETYPE_ID number 22  √  null
T_GPS_NODETYPES.NODETYPE_ID Implied Constraint R

Analyzed at Fri Oct 30 01:06 IST 2020

View Definition:
SELECT APPLICATIONS.Application_Name APPLICATION, APPLICATIONS.APPLICATION_ID APPLICATION_ID, WTYPES.WORKFLOW_TYPE_NAME WORK_FLOW, WTYPES.WORKFLOW_TYPE_ID WORKFLOW_TYPE_ID, WS.STATE_NAME STATE, GN.NODETYPE NODE_TYPE, NS.UPDATED_AT UPDATED_DATE, GN.DESCRIPTION DESCRIPTION, NS.NODETYPE_STATE_ID NODETYPE_STATE_ID, GN.NODETYPE_ID NODETYPE_ID FROM T_GPS_APPLICATIONS APPLICATIONS, T_GPS_WORKFLOW_TYPES WTYPES, t_gps_workflow_states WS, T_GPS_NODETYPE_STATES NS, T_GPS_NODETYPES GN WHERE APPLICATIONS.VISIBLE_FLAG = 'true' AND APPLICATIONS.APPLICATION_ID = WTYPES.APPLICATION_ID AND WTYPES.VISIBLE_FLAG = 'true' AND WTYPES.WORKFLOW_TYPE_ID = WS.WORKFLOW_TYPE_ID AND WS.STATE_ID = NS.STATE_ID AND WS.VISIBLE_FLAG = 'true' AND NS.NODETYPE_ID = GN.NODETYPE_ID AND WTYPES.VISIBLE_FLAG = 'true' UNION SELECT APPLICATIONS.Application_Name APPLICATION, APPLICATIONS.APPLICATION_ID APPLICATION_ID, NULL WORK_FLOW, NULL WORKFLOW_TYPE_ID, NULL STATE, GN.NODETYPE NODE_TYPE, NS.UPDATED_AT UPDATED_DATE, GN.DESCRIPTION DESCRIPTION, NS.NODETYPE_STATE_ID NODETYPE_STATE_ID, GN.NODETYPE_ID NODETYPE_ID FROM T_GPS_NODETYPE_STATES NS, T_GPS_NODETYPES GN, T_GPS_APPLICATIONS APPLICATIONS WHERE NS.NODETYPE_ID = GN.NODETYPE_ID AND NS.VISIBLE_FLAG = 'true' AND APPLICATIONS.APPLICATION_ID = NS.APPLICATION_ID AND APPLICATIONS.VISIBLE_FLAG = 'true'
 
Possibly Referenced Tables/Views:


Close relationships: