NOTIFICATION_ARCHIVES
This table holds the details notification message which are archived.
Column Descriptions:
Name | Type | Description |
---|---|---|
MSGARCHIVE_ID | INT4 NOT NULL | The unique identifier for the notification archive |
MSGCONF_ID | INT4 NOT NULL | Reference to the configuration for which the message is archived. |
APPROVAL_ID | INT4 NOT NULL | Reference to the approval record for which the message is archived. |
MSG_INDEX | INT4 | Index for the message body. Used in case the message is large and divided into multiple shards. |
MSG_BODY | BYTEA | Contents of the message body. |
INTERACTION_SPEC | JSONB |
Configuration for the message. Sample for email
|
STATUS | VARCHAR(30) | Indicates the status of the message. Possible values:
SUCCESS – Message is successfully delivered. FAILED – Message delivery has failed after maximum configured retries. |
MSG_CREATED | TIMESTAMP | Time when the message is saved in this table. |
MSG_UPDATED | TIMESTAMP | Time when there is an update in this table for the message |
Indexes:
Name | Column Names | Type |
---|---|---|
NOTIFICATION_ARCHIVES_PKEY | MSGARCHIVE_ID | Primary Key |
Constrained by parent tables:
Constraint | Columns | Parent Table | Parent Columns | Type |
---|---|---|---|---|
NOTIFICATION_ARCHIVES_APPROVAL_ID_FKEY | APPROVAL_ID | APPROVAL | APPROVAL_ID | Simple |
NOTIFICATION_ARVHICES_MSGCONF_ID_FKEY | MSGCONF_ID | NOTIFICATION_MSG_CONFF | MSGCONF_ID | Simple |