Table HLPDTEST.STATEGPS.T_REPORTING_PLAN_TASKS 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
TASK_ID number 22
T_PROJECT_PLAN_REMOVED_TASKS_V.TASK_ID Implied Constraint R
T_PROJECT_PLAN_TAGS_V.TASK_ID Implied Constraint R
T_PROJECT_PLAN_TASKS_V.TASK_ID Implied Constraint R
T_REPORTING_PLAN_TASKS_V.TASK_ID Implied Constraint R
HISTORY_ID number 22  √  null
T_REPORTING_PLAN_HISTORY.HISTORY_ID FK1_T_REPORTING_PLAN_TASKS C
JS_GANTT_CHART_TASK varchar2 4000  √  null
TASK_ORDER number 22  √  null
TASK_TYPE varchar2 50  √  null
JS_GANTT_CHART_TASK_ID number 22  √  null
JS_GANTT_CHART_PARENT_ID number 22  √  null
WORKFLOW_ID number 22  √  null
T_GPS_WORKFLOW_TYPES.WORKFLOW_TYPE_ID FK_T_REPRT_PLAN_TSK_WKF_ID R
MODULE varchar2 4000  √  null
TAG varchar2 4000  √  null
START_DATE timestamp(6) 11,6  √  null
END_DATE timestamp(6) 11,6  √  null
DURATION number 22  √  null
TOTAL_TASKS number 22  √  null
TASKS_COMPLETED number 22  √  null
TAG_ID number 22  √  null
T_REPORTING_PLAN_TAGS.TAG_ID T_REPORTING_PLAN_TASKS_FK R

Table contained 8,650,012 rows at Mon Apr 12 01:05 IST 2021

Indexes:
Column(s) Type Sort Constraint Name
TASK_ID Primary key Asc PK_T_REPORTING_PLAN_TASKS
HISTORY_ID Performance Asc T_REPORTING_PLAN_TASKS_INDEX

Close relationships  within of separation: