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.