Table HLPDTEST.STATEGPS.MV_RESOURCE_PERFORMANCE 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
IA_ISSUE_NUMBER varchar2 100  √  null
IA_ISSUE_TITLE varchar2 4000  √  null
USER_NAME varchar2 2000  √  null
QUALITY_RANK number 22  √  null
COMPLEXITY_RANK number 22  √  null
ESTIMATED_HOURS number 22  √  null
MOVED_OUT_DATE date 7  √  null
APPLICATION_NAME varchar2 255  √  null
WORKFLOW_TYPE_NAME varchar2 255
STATE_NAME varchar2 255  √  null
TASK_WEIGHTAGE varchar2 4000  √  null
ACTUAL_HOURS number 22  √  null
PROJECT_TASK_ID number 22  √  null
T_PROJECT_TASK.PROJECT_TASK_ID Implied Constraint R
RESOURCE_PERFORMANCE number 22  √  null
TASK_COMPLETED_ON varchar2 15  √  null
WORK_ESTIMATE varchar2 15  √  null
PROMISED_DUE_DATE date 7  √  null

Table contained 22,204 rows at Mon Sep 20 01:06 IST 2021


Close relationships: