PM_WP_TEMPLATE_OWNERS

This table stores work plan template owners information.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_USERS

MANAGER_USER_ID

MANAGER_USER_ID

PM_WORKPLAN_TEMPLATES

WORKPLAN_TEMPLATE_ID

WP_TEMPLATE_ID

Column Descriptions

Column Name

Null?

Data Type

Description

WP_TEMPLATE_ID

NOT NULL

NUMBER

Stores work plan template ID It references the workplan_template_id of pm_workplan_templates table.

MANAGER_USER_ID

NOT NULL

NUMBER

Stores work plan template owner's user ID It is a foreign key reference to manager_user_id of knta_users table.

Indexes

Index Name

Index Type

Sequence

Column Name

FK8481FFA1DF6D5068_I

NONUNIQUE

1

MANAGER_USER_ID

SYS_C005201573

UNIQUE

1

WP_TEMPLATE_ID

SYS_C005201573

UNIQUE

2

MANAGER_USER_ID

Sequences

This table uses no sequences.