View HLPDTEST.STATEGPS.XXT_PROJECT_NAME_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
STATE_ID number 22  √  null
T_GPS_WORKFLOW_STATES.STATE_ID Implied Constraint R
APPLICATION_ID number 22
T_GPS_APPLICATIONS.APPLICATION_ID Implied Constraint R
APPLICATION_NAME varchar2 255  √  null

Analyzed at Thu Aug 13 01:05 IST 2020

View Definition:
select distinct d.state_id,a.application_id,a.application_name from t_gps_applications a, t_gps_workflow_types b, t_gps_workflow_states c, t_project_task d where d.state_id=c.state_id and c.workflow_type_id=b.workflow_type_id and b.application_id=a.application_id and (a.visible_flag = 'true' or a.visible_flag is null)
 
Possibly Referenced Tables/Views:


Close relationships: