Table HLPDTEST.STATEGPS.T_REPORTING_PLAN_TASK_DETAILS 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_DETAIL_ID number 22
T_REPORTING_PLAN_TASK_DETAIL1.TASK_DETAIL_ID Implied Constraint R
EXECUTION_ID number 22
T_REPORTING_PLAN_HISTORY.HISTORY_ID FK_PLAN_TASK_DET_EXE_ID R
PROJECT_TASK_ID number 22  √  null
T_PROJECT_TASK.PROJECT_TASK_ID FK_PLAN_TASK_DET_PRJ_TASK_ID R
START_DATE timestamp(6) 11,6
END_DATE timestamp(6) 11,6
TAG varchar2 4000  √  null
MODULE varchar2 4000  √  null
PROJECT_ID number 22
T_GPS_APPLICATIONS.APPLICATION_ID FK_PLAN_TASK_DET_PROJECT_ID R
WORKFLOW_ID number 22  √  null
T_GPS_WORKFLOW_TYPES.WORKFLOW_TYPE_ID FK_PLAN_TASK_DET_WORKFLOW_ID R
STATE_ID number 22  √  null
T_GPS_WORKFLOW_STATES.STATE_ID FK_PLAN_TASK_DET_STATE_ID R
RESOURCE_ID number 22  √  null
DURATION number 22  √  null
DAYS_REMAINING number 22  √  null
DURATION_DIFFERENCE number 22  √  null
TASK_ADDED varchar2 5  √  null
TASK_REMOVED varchar2 5  √  null
TASK_COMPLETED varchar2 5  √  null
WORKFLOW_ORDER number 22  √  null
CREATED_BY varchar2 255 'Reporting Plan'
CREATED_DATE timestamp(6) 11,6 now
BASELINE_EXECUTION_ID number 22  √  null
T_REPORTING_PLAN_HISTORY.HISTORY_ID FK_BASELINE_EXEC_ID R

Table contained 1,726,333 rows at Sun Nov 29 01:06 IST 2020

Indexes:
Column(s) Type Sort Constraint Name
TASK_DETAIL_ID Primary key Asc PK_T_REPORTING_PLAN_TASK_DET

Close relationships  within of separation: