WP_CALENDAR_CONSTRAINTS

This table stores lists of the calendar constraints applied to tasks within a work plan. For example, a task needs to start no later than some date.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_USERS

USER_ID

CREATED_BY

KNTA_USERS

USER_ID

LAST_UPDATED_BY

Column Descriptions

Column Name

Null?

Data Type

Description

CALENDARCONSTRAINT_ID

NOT NULL

NUMBER

System-generated identifier

VERSION

NOT NULL

NUMBER

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

CONSTRAINT_DATE

NULLABLE

DATE

Specifies the relevant the date defining the constraint (along with the TYPE).

MANDATORY

NULLABLE

NUMBER

Not used.

TYPE

NULLABLE

VARCHAR2(4)

Specifies the type of the constraint For example, ASAP = as soon as possible, SNET = start no earlier than, MSO = must start on.

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

OWNER_TASK_ID

NULLABLE

NUMBER

ID of the task in WP_TASKS table

Indexes

Index Name

Index Type

Sequence

Column Name

SYS_C005201602

UNIQUE

1

CALENDARCONSTRAINT_ID

Sequences

Sequence Name

Sequence Type

WP_CALENDAR_CONSTRAINTS_S

CALENDARCONSTRAINT_ID