Table HLPDTEST.STATEGPS.T_PROJECT_TASK 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
STATE_ID number 22  √  null
T_GPS_WORKFLOW_STATES.STATE_ID FK_T_PROJECT_TASK C
TASK_ID varchar2 2500  √  null
START_DATE date 7  √  null
FINISH_DATE date 7  √  null
DURATION number 22  √  null
DAYSREMAINING number 22  √  null
RESOURCE_NAME varchar2 2000  √  null
TASK_NAME varchar2 2000  √  null
USER_NAME varchar2 2000  √  null
ACTUALSTART_DATE date 7  √  null
ACTUALFINISH_DATE date 7  √  null
NEXT_OPERTION_ID number 22  √  null
INSTANCE_ID number 22  √  null
T_INSTANCES.INSTANCE_ID FK1_T_PROJECT_TASK C
PRIORITY number 22  √  null
PROJECT_TASK_ID number 22
MV_RESOURCE_PERFORMANCE.PROJECT_TASK_ID Implied Constraint R
MYVIEW.PROJECT_TASK_ID Implied Constraint R
PROJECT_NATIVE_TASKS_V.PROJECT_TASK_ID Implied Constraint R
PROJECT_TASK_AUDIT_V.PROJECT_TASK_ID Implied Constraint R
T_DUE_TASKS_V.PROJECT_TASK_ID Implied Constraint R
T_PROJECT_ACTIVITY.PROJECT_TASK_ID PROJECT_TASK_ID_FK C
T_PROJECT_CRITICAL_TASKS_V.PROJECT_TASK_ID Implied Constraint R
T_PROJECT_CURRENT_PLAN_TASKS_V.PROJECT_TASK_ID Implied Constraint R
T_PROJECT_NATIVE_TASK_V.PROJECT_TASK_ID Implied Constraint R
T_PROJECT_TASK_HISTORY.PROJECT_TASK_ID SYS_C0010270 C
T_PROJECT_TASK_V.PROJECT_TASK_ID Implied Constraint R
T_REPORTING_PLAN_TASK_DETAIL1.PROJECT_TASK_ID FK_PLAN_TASK_DET_PRJ_TASK_I R
T_REPORTING_PLAN_TASK_DETAILS.PROJECT_TASK_ID FK_PLAN_TASK_DET_PRJ_TASK_ID R
T_RESOURCE_USAGE.PROJECT_TASK_ID FK_2_T_PROJECT_TASK C
T_SCRIPT_REPLAY_RESULTS.PROJECT_TASK_ID FK_PROJECT_TASK_ID C
T_STARTED_TASKS_V.PROJECT_TASK_ID Implied Constraint R
T_TASK_ACTION_ITEMS.PROJECT_TASK_ID T_TASK_ACTION_ITEMS_FK R
T_TASK_MANAGER_COMMENT.PROJECT_TASK_ID PROJECT_TASK_ID C
T_TASK_PREDECESSOR.PREDECESSOR_TASK_ID PREDECESSOR_TASK_ID_FK C
T_TASK_PREDECESSOR.TASK_ID TASK_ID_FK C
T_TASK_PREDECESSOR_EXISTS_V.PROJECT_TASK_ID Implied Constraint R
T_TICKET_DETAILS_V.PROJECT_TASK_ID Implied Constraint R
TICKET_TASKS_V.PROJECT_TASK_ID Implied Constraint R
V_ACTUAL_HOURS.PROJECT_TASK_ID Implied Constraint R
V_NATIVE_TASK_COMMENTS.PROJECT_TASK_ID Implied Constraint R
V_NATIVE_TASK_MANAGER_COMMENTS.PROJECT_TASK_ID Implied Constraint R
V_PA_SUMMARY.PROJECT_TASK_ID Implied Constraint R
V_TASKS_WHITEBOARD.PROJECT_TASK_ID Implied Constraint R
COMMENTS varchar2 4000  √  null
ROLE_ID number 22  √  null
T_GPS_ROLES.ROLE_ID Implied Constraint R
USER_ID number 22  √  null
T_GPS_USERS.USER_ID Implied Constraint R
DOCUMENT_PATH varchar2 200  √  null
MANAGER_COMMENTS varchar2 4000  √  null
BASELINECOST number 22  √  null
BASELINEDURATION number 22  √  null
BASELINEFINISH date 7  √  null
BASELINESTART date 7  √  null
BASELINEWORK number 22  √  null
FIXEDCOST number 22  √  null
FIXEDCOSTACCRUAL number 22  √  null
COST number 22  √  null
OVERTIMECOST number 22  √  null
ACTUALCOST number 22  √  null
ACTUALOVERTIMECOST number 22  √  null
REMAININGCOST number 22  √  null
REMAININGOVERTIMECOST number 22  √  null
PROMISED_DUE_DATE date 7  √  null
CONSTRAINT_TYPE number 22  √  null
CONSTRAINT_DATE date 7  √  null
CRITICAL number 22  √  null
BASELINESTART1 date 7  √  null
BASELINEFINISH1 date 7  √  null

Table contained 632,718 rows at Fri Sep 25 01:05 IST 2020

Indexes:
Column(s) Type Sort Constraint Name
PROJECT_TASK_ID Primary key Asc T_TASK_PR
STATE_ID Performance Asc T_PROJECT_TASK_CN1
DURATION Performance Asc T_PROJECT_TASK_CN3
DAYSREMAINING Performance Asc T_PROJECT_TASK_CN4
DURATION + DAYSREMAINING Performance Asc/Asc T_PROJECT_TASK_DR_IDX
INSTANCE_ID Performance Asc T_PROJECT_TASK_INDEX
USER_NAME Performance Asc T_PROJECT_TASK_N2

Close relationships  within of separation: