PM_TASK_NS_MILESTONE_GROUPS

This table stores the recipients for the "milestone is complete" notification. The recipients are a list of security groups.

Foreign Keys

Primary Key Table	Primary Key Column	Foreign Key Column
KNTA_SECURITY_GROUPS_NLS	SECURITY_GROUP_ID	NOTIFY_ON_MS_SGS
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_SGS	NOT NULL	NUMBER	Identifies the security group. This column is a foreign key to the KNTA_SECURITY_GROUPS table
SEQ	NOT NULL	NUMBER	Specifies the ordering within the list

Indexes

Index Name	Index Type	Sequence	Column Name
FKA5D35105CE5C54EF_I	NONUNIQUE	1	NOTIFY_ON_MS_SGS
SYS_C005201568	UNIQUE	1	TASK_NOTIFICATION_SETUP_ID
SYS_C005201568	UNIQUE	2	SEQ

Sequences

This table uses no sequences.