View HLPDTEST.STATEGPS.V_MANAGER_COMMENTS 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
T_GPS_WORKFLOW_INSTANCES.INSTANCE_ID Implied Constraint R
MANAGER_COMMENTS varchar2 4000  √  null

Analyzed at Sun Oct 18 01:05 IST 2020

View Definition:
select inst.instance_id,( select tmc1.comments from t_task_manager_comment tmc1, t_project_task pt1 where pt1.instance_id = inst.instance_id and pt1.project_task_id = tmc1.project_task_id and tmc1.comment_id = ( select max(tmc.comment_id) from t_project_task pt, t_task_manager_comment tmc where pt.instance_id=inst.instance_id and pt.project_task_id = tmc.project_task_id and tmc.comments is not null )) manager_comments from t_instances inst
 
Possibly Referenced Tables/Views:


Close relationships: