Table HLPDTEST.STATEGPS.T_PROJECT_TASK_HISTORY 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
HISTORY_ID number 22
T_GPS_WF_INSTANCE_HISTORY.HISTORY_ID Implied Constraint R
PROJECT_TASK_ID number 22  √  null
T_PROJECT_TASK.PROJECT_TASK_ID SYS_C0010270 C
RESOURCE_ID number 22  √  null
UPDATE_DATE date 7  √  null
UPDATE_TIMESTAMP timestamp(6) 11,6  √  null
COMMENTS varchar2 4000  √  null
DAYSREMAINING number 22  √  null
DURATION number 22  √  null
RESOURCE_NAME varchar2 255  √  null
SUB_TASK_PDD timestamp(6) 11,6  √  null
UPDATED_BY varchar2 255  √  null
EXECUTION_ID number 22  √  null
T_GPS_SERVER_MEMORY_STATUS.EXECUTION_ID Implied Constraint R
START_DATE timestamp(6) 11,6  √  null
FINISH_DATE timestamp(6) 11,6  √  null

Table contained 1,076,581 rows at Sat Dec 05 01:06 IST 2020

Indexes:
Column(s) Type Sort Constraint Name
HISTORY_ID Primary key Asc SYS_C0010182
COMMENTS Performance Asc T_PROJECT_TASK_HIST_COMM_IDX
UPDATE_DATE Performance Asc T_PROJECT_TASK_HIST_DATE_IDX
PROJECT_TASK_ID Performance Asc T_PROJECT_TASK_HISTORY_INDEX
RESOURCE_ID Performance Asc T_PROJECT_TASK_HISTORY_RES_IDX

Close relationships  within of separation: