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, and so on.

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 (ASAP = as soon as possible, SNET = start no earlier than, MSO = must start on, and so 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