KNTA_USER_NOTIF_OPT

This table stores the users’ preferences on whether to receive email notifications for different modules.

Foreign Keys

Primary Key Table Primary Key Column Foreign Key Column
KNTA_USERS USER_ID USER_ID
KNTA_USERS USER_ID CREATED_BY
KNTA_USERS USER_ID LAST_UPDATED_BY

Column Descriptions

Column Name Null? Data Type Description
USER_ID NOT NULL NUMBER Indicates the user associated with these notification settings.
NOTIFICATION_ENTITY_ID NOT NULL NUMBER The notification entity ID
OPT_IN NOT NULL CHAR(1) Determines whether to receive the email notification.
CREATION_DATE NOT NULL DATE Date record was created
CREATED_BY NOT NULL NUMBER Identifier for the user who created the record
LAST_UPDATED_DATE NOT NULL DATE Date record was last updated
LAST_UPDATED_BY NOT NULL NUMBER Identifier for the user who last updated the record

Indexes

Index Name Index Type Sequence Column Name
KNTA_USER_NOTIF_OPT_UX1 Unique 1 USER_ID
KNTA_USER_NOTIF_OPT_UX1 Unique 2 NOTIFICATION_ENTITY_ID
KNTA_USER_NOTIF_OPT_IX1 Normal 1 USER_ID
KNTA_USER_NOTIF_OPT_IX2 Normal 1 NOTIFICATION_ENTITY_ID

Sequences

This table uses no sequences.