WP_TASK_OWNERS

This table stores the relationships between the task owners and the task they own.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_USERS

USER_ID

OWNER_RESOURCE_ID

WP_TASKS

TASK_ID

TASK_ID

Column Descriptions

Column Name

Null?

Data Type

Description

TASK_ID

NOT NULL

NUMBER

Identifies the task

OWNER_RESOURCE_ID

NOT NULL

NUMBER

Identifies the user who owns the task

OWNER_SEQ

NOT NULL

NUMBER

Indicates the sequence number of the owner (relative to the other owners) on a specific task

Indexes

Index Name

Index Type

Sequence

Column Name

FKA542CBB440348217_I

NONUNIQUE

1

OWNER_RESOURCE_ID

SYS_C005201614

UNIQUE

1

TASK_ID

SYS_C005201614

UNIQUE

2

OWNER_SEQ

Sequences

This table uses no sequences.