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.