PM_TASK_NS_MILESTONE_RSCS

This table stores the recipients for the "milestone is complete" notification.

Foreign Keys

Primary Key Table	Primary Key Column	Foreign Key Column
KNTA_USERS	USER_ID	NOTIFY_ON_MS_RESOURCES
PM_TASK_NOTIFICATION_SETUPS	TASK_NOTIFICATION_SETUP_ID	TASK_NOTIFICATION_SETUP_ID

Column Descriptions

Column Name	Null?	Data Type	Description
TASK_NOTIFICATION_SETUP_ID	NOT NULL	NUMBER	System-generated identifier
NOTIFY_ON_MS_RESOURCES	NOT NULL	NUMBER	Identifies the user ID of the recipient. This is a foreign key to the KNTA_USERS table
SEQ	NOT NULL	NUMBER	Specifies the ordering within the list of users

Indexes

Index Name	Index Type	Sequence	Column Name
FK10711DE26A217121_I	NONUNIQUE	1	NOTIFY_ON_MS_RESOURCES
SYS_C005201569S	UNIQUE	1	TASK_NOTIFICATION_SETUP_ID
SYS_C005201569	UNIQUE	2	SEQ

Sequences

This table uses no sequences.