Table HLPDTEST.STATEGPS.T_TASK_MANAGER_COMMENT 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
COMMENT_ID number 22
PROJECT_TASK_ID number 22
T_PROJECT_TASK.PROJECT_TASK_ID PROJECT_TASK_ID C
COMMENTS varchar2 4000  √  null
UPDATED_AT date 7  √  null
RESOURCE_ID number 22  √  null
PRIORITY number 22  √  null
PROMISED_DATE date 7  √  null
UPDATED_BY varchar2 255  √  null
RESOURCE_NAME varchar2 255  √  null

Table contained 813,341 rows at Sun Jan 17 01:06 IST 2021

Indexes:
Column(s) Type Sort Constraint Name
COMMENT_ID Primary key Asc COMMENT_ID
RESOURCE_ID Performance Asc T_TASK_MANAGER_COM_RSC_IDX
PROJECT_TASK_ID Performance Asc T_TASK_MANAGER_COM_TK_IDX

Close relationships  within of separation: