NOTIFICATION_MSG_CONF
This table holds the details notification message configuration.
Column Descriptions:
Name | Type | Description |
---|---|---|
MSGCONF_ID | INT4 NOT NULL | The unique identifier for the notification message configuration |
EVENT_ID | INT4 NOT NULL | Reference to the event for which the configuration is created. |
ARCHIVE_MSG | BOOLEAN | Indicates whether the message to be archived or not. Possible values: true-Message to be archived. False – Message should not be archived |
RECIPIENT_TYPE | VARCHAR(254) | Type of the recipient for the message configuration. (e.g., Submitter or Administrator) |
SEND_MODE | INT4 | Indicates whether message should be sent immediately or picked up by scheduler. Possible values : 0 - To be sent by scheduler, 1 – To be sent immediately |
INTERACTION_CONF | JSONB |
Configurations for the message. Sample for email
|
IS_NOTIFICATION_ENABLED | BOOLEAN | Indicates whether notification is enabled or not. Possible values: Y – Notification is enabled, N – Notification is disabled |
MAX_RETRIES | INT4 | Maximum number of attempts made to send the message before marking as failed. |
NOTIFICATION_HELPER_CLASS | TEXT | Helper class used to form the email message for the event. |
Indexes:
Name | Column Names | Type |
---|---|---|
NOTIFICATION_MSG_CONF_PKEY | MSGCONF_ID | Primary Key |
Constrained by parent tables:
Constraint | Columns | Parent Table | Parent Columns | Type |
---|---|---|---|---|
NOTIFICATION_MSG_CONF_EVENT_ID_FKEY | EVENT_ID | NOTIFICATION_MSG_CONF | EVENT_ID | Simple |
Referenced by child tables:
Constraint | Columns | Child Table | Child Columns | Type |
---|---|---|---|---|
NOTIFICATION_MSGSTORE_MSGCONF_ID_FKEY | MSGCONF_ID | NOTIFICATION_MSGSTORE | MSGCONF_ID | Simple |
NOTIFICATION_ARCHIVES_MSGCONF_ID_FKEY | MSGCONF_ID | NOTIFICATION_ARCHIVES | MSGCONF_ID | Simple |