View HLPDTEST.STATEGPS.OBJECT_VIEWER_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
INSTANCE_ID number 22  √  null
T_GPS_WORKFLOW_INSTANCES.INSTANCE_ID Implied Constraint R
APPLICATION_NAME varchar2 255  √  null
WORKFLOW_TYPE_NAME varchar2 255  √  null
TO_STATE varchar2 255  √  null
FROM_STATE varchar2 255  √  null
PROPERTY_VALUE varchar2 4000  √  null

Analyzed at Sun Oct 18 01:05 IST 2020

View Definition:
select i.instance_id, a.application_name, wt.workflow_type_name, w_to_s.state_name to_state, w_from_s.state_name from_state, --ip.property_name, ip.property_value from stategps.t_gps_instances i, stategps.t_gps_applications a, stategps.t_gps_workflow_types wt, stategps.t_gps_workflow_states w_to_s, stategps.t_gps_workflow_states w_from_s, stategps.t_gps_instance_properties ip where i.application_id=a.application_id(+) and i.workflow_type_id=wt.workflow_type_id(+) and i.current_state_id=w_to_s.state_id(+) and i.from_state_id=w_from_s.state_id(+) and i.instance_id=ip.instance_id Order By i.instance_id, i.current_state_id
 
Possibly Referenced Tables/Views:


Close relationships: