UD_USER_COMMUNICATIONS_NON_HJAXB

Description

This table stores user communication logs for tracking messages sent to users.

Columns

Column Name Data Type Description
ID BIGINT The unique identifier for the communication record.
PIPELINE_ID BIGINT The pipeline ID that triggered the communication.
PIPELINE_NAME VARCHAR(255) The name of the pipeline.
ENDPOINT VARCHAR(255) The endpoint where the message was sent.
EVENT_ID VARCHAR(255) The event ID that triggered the communication.
EVENT_TRANSACTION_ID VARCHAR(255) The transaction ID for the event.
FAILURE_REASON LONGTEXT The reason for failure if the communication failed.
MESSAGE LONGTEXT The message content sent to the user.
MESSAGE_DATETIME TIMESTAMP The date and time when the message was sent.
OFFER_INDEX INT(11) The index of the offer sent.
SUCCESS_FLAG SMALLINT(6) Indicates if the communication was successful.
USER VARCHAR(255) The user who received the communication.