Table HLPDTEST.STATEGPS.REPORTING_PLAN_TEST 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_ID number 22  √  null
T_PROJECT_DETAILS.PROJECT_ID Implied Constraint R
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
TAG_BASED_PLAN varchar2 255  √  null
PROJECT_BUFFER_PULLED_IN varchar2 10  √  null
GAINED_BUFFER_IN_DAYS number 22  √  null

Table contained 20,016 rows at Fri Dec 03 01:06 IST 2021


Close relationships: