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. |