View HLPDTEST.STATEGPS.V_NATIVE_TASK_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
PROJECT_TASK_ID number 22
T_PROJECT_TASK.PROJECT_TASK_ID Implied Constraint R
COMMENTS varchar2 4000  √  null

Analyzed at Thu Aug 13 01:05 IST 2020

View Definition:
select pt.project_task_id, ( select pth1.comments from t_project_task_history pth1 where pt.project_task_id = pth1.project_task_id and pth1.history_id = ( select max(pth.history_id) from t_project_task_history pth where pt.project_task_id = pth.project_task_id and pth.comments is not null )) comments from t_project_task pt
 
Possibly Referenced Tables/Views:


Close relationships: