SchemaSpy - View HLPDTEST.STATEGPS.V_NATIVE_TASK_MANAGER

Generated by
SchemaSpy

Legend:

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

T_PROJECT_TASK.PROJECT_TASK_ID

Implied Constraint R

MANAGER_COMMENTS

varchar2

4000

√

null

Analyzed at Sun Jan 17 01:06 IST 2021

View Definition:

select pt.project_task_id,( select tmc1.comments from t_task_manager_comment tmc1 where pt.project_task_id = tmc1.project_task_id and tmc1.comment_id = ( select max(tmc.comment_id) from t_task_manager_comment tmc where pt.project_task_id = tmc.project_task_id and tmc.comments is not null )) manager_comments from t_project_task pt

Possibly Referenced Tables/Views:

T_PROJECT_TASK T_TASK_MANAGER_COMMENT