UD_AUDIENCE_TO_TRIGGER_CURRENT_STATE_MAP
Description
This table maps audience members to their current trigger state.
Columns
| Column Name | Data Type | Description |
|---|---|---|
| TRIGGER_ID | BIGINT | The trigger ID associated with the mapping. |
| AUDIENCE_KEY | VARCHAR(255) | The unique key for the audience member. |
| EXECUTION_ID | BIGINT | The identifier for the trigger execution. |
| CURRENT_STATE | BIGINT | The current state ID. |
| IS_FINAL_STATE | BIT | Indicates whether the current state is a final state. |
| TIME_STAMP_EPOCH | BIGINT | The timestamp when the state was entered in epoch format. |
| DURATION_IN_MILLIS | BIGINT | The duration in milliseconds for time-based states. |
| DEADLINE_EPOCH | BIGINT | The deadline timestamp in epoch format. |
| EXEC_STATE_JSON | LONGTEXT | JSON data associated with the trigger execution state. |