Table HLPDTEST.STATEGPS.T_REPORTING_PLAN_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_REPORTING_PLAN_TASK_DETAIL1.EXECUTION_ID FK_PLAN_TASK_DET_EXE_I R
T_REPORTING_PLAN_TASK_DETAILS.BASELINE_EXECUTION_ID FK_BASELINE_EXEC_ID R
T_REPORTING_PLAN_TASK_DETAILS.EXECUTION_ID FK_PLAN_TASK_DET_EXE_ID R
T_REPORTING_PLAN_TASKS.HISTORY_ID FK1_T_REPORTING_PLAN_TASKS C
T_GPS_WF_INSTANCE_HISTORY.HISTORY_ID Implied Constraint R
PROJECT_ID number 22  √  null
T_GPS_APPLICATIONS.APPLICATION_ID FK_PROJECT_ID C
DATE_TIME timestamp(6) 11,6  √  null
PLAN_START_DATE date 7  √  null
PLAN_END_DATE date 7  √  null
BASE_LINE varchar2 10  √  null
INACTIVE varchar2 6  √  null
PROJECT_BUFFER_START_DATE date 7  √  null
PROJECT_BUFFER_END_DATE date 7  √  null
BUFFER_USAGE_IN_PERCENTAGE number 22  √  null
PROJECT_BUFFER_IN_DAYS number 22  √  null
UPDATED_BY varchar2 255  √  null
UPDATED_DATE timestamp(6) 11,6 current_timestamp
TAG_BASED_PLAN varchar2 255  √  null
PROJECT_BUFFER_PULLED_IN varchar2 10  √  null
GAINED_BUFFER_IN_DAYS number 22  √  null

Table contained 20,812 rows at Wed May 25 01:05 IST 2022

Indexes:
Column(s) Type Sort Constraint Name
HISTORY_ID Primary key Asc PK_HISTORY_ID

Close relationships  within of separation: