SchemaSpy - Table HLPDTEST.STATEGPS.T_REPORTING_PLAN_TASK_DETAILS

Generated by
SchemaSpy

Legend:

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

TASK_DETAIL_ID

number

22

T_REPORTING_PLAN_TASK_DETAIL1.TASK_DETAIL_ID

Implied Constraint R

EXECUTION_ID

number

22

T_REPORTING_PLAN_HISTORY.HISTORY_ID

FK_PLAN_TASK_DET_EXE_ID R

PROJECT_TASK_ID

number

22

√

null

T_PROJECT_TASK.PROJECT_TASK_ID

FK_PLAN_TASK_DET_PRJ_TASK_ID C

START_DATE

timestamp(6)

11,6

END_DATE

timestamp(6)

11,6

TAG

varchar2

4000

√

null

MODULE

varchar2

4000

√

null

PROJECT_ID

number

22

T_GPS_APPLICATIONS.APPLICATION_ID

FK_PLAN_TASK_DET_PROJECT_ID R

WORKFLOW_ID

number

22

√

null

T_GPS_WORKFLOW_TYPES.WORKFLOW_TYPE_ID

FK_PLAN_TASK_DET_WORKFLOW_ID R

STATE_ID

number

22

√

null

T_GPS_WORKFLOW_STATES.STATE_ID

FK_PLAN_TASK_DET_STATE_ID R

RESOURCE_ID

number

22

√

null

DURATION

number

22

√

null

DAYS_REMAINING

number

22

√

null

DURATION_DIFFERENCE

number

22

√

null

TASK_ADDED

varchar2

5

√

null

TASK_REMOVED

varchar2

5

√

null

TASK_COMPLETED

varchar2

5

√

null

WORKFLOW_ORDER

number

22

√

null

CREATED_BY

varchar2

255

'Reporting Plan'

CREATED_DATE

timestamp(6)

11,6

now

BASELINE_EXECUTION_ID

number

22

√

null

T_REPORTING_PLAN_HISTORY.HISTORY_ID

FK_BASELINE_EXEC_ID R

Table contained 4,188,465 rows at Mon May 23 01:05 IST 2022

Indexes:

Column(s)	Type	Sort	Constraint Name
TASK_DETAIL_ID	Primary key	Asc	PK_T_REPORTING_PLAN_TASK_DET
EXECUTION_ID	Performance	Asc	PLAN_TASK_DETAILS_EXECUTION_ID