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.