WP_DEPENDENCIES

This table stores the predecessor-successor relationships between tasks.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_USERS

USER_ID

CREATED_BY

KNTA_USERS

USER_ID

LAST_UPDATED_BY

WP_TASKS

TASK_ID

PREDECESSOR_ID

WP_TASKS

TASK_ID

SUCCESSOR_ID

Column Descriptions

Column Name

Null?

Data Type

Description

DEPENDENCY_ID

NOT NULL

NUMBER

System-generated identifier

VERSION

NOT NULL

NUMBER

System-generated version for the entity. This column must not be updated manually

SUCCESSOR_ID

NULLABLE

NUMBER

Foreign key to the WP_TASKS table identifying the successor part of the relationship.

PREDECESSOR_ID

NULLABLE

NUMBER

Foreign key to the WP_TASKS table identifying the predecessor part of the relationship.

TYPE

NULLABLE

VARCHAR2(2)

Defines the type of the relationship (SF = start to finish, FF = finish to finish, and so on)

LAG

NULLABLE

FLOAT

Defines the lag in days for this relationship.

LAG_FORMAT

NULLABLE

NUMBER

Not used.

EXTERNAL

NULLABLE

VARCHAR2(1)

Indicates whether the tasks (predecessor and successor) belong to the same work plan or not.

CREATED_BY

NOT NULL

NUMBER

Identifier for the user who created the record

CREATION_DATE

NOT NULL

DATE

Date record was created

LAST_UPDATED_BY

NOT NULL

NUMBER

Identifier for the user who last updated the record

LAST_UPDATE_DATE

NOT NULL

DATE

Date record was last updated

Indexes

Index Name

Index Type

Sequence

Column Name

FK36AD00CF147BDE95_I

NONUNIQUE

1

SUCCESSOR_ID

FK36AD00CFB588F1D2_I

NONUNIQUE

1

PREDECESSOR_ID

SYS_C005201603

UNIQUE

1

DEPENDENCY_ID

Sequences

This table uses no sequences.