PM_TASK_NS_LATE_RSCS
This table stores the recipients for the "task running late" notification.
Foreign Keys
Primary Key Table |
Primary Key Column |
Foreign Key Column |
---|---|---|
KNTA_USERS |
USER_ID |
RESOURCE_USER_ID |
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 |
RESOURCE_USER_ID |
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 |
---|---|---|---|
FK933D2928E34A13C9_I |
NONUNIQUE |
1 |
RESOURCE_USER_ID |
SYS_C005201567 |
UNIQUE |
1 |
TASK_NOTIFICATION_SETUP_ID |
SYS_C005201567 |
UNIQUE |
2 |
SEQ |
Sequences
This table uses no sequences.