UD_TRIGGER_STATE_TRANSITION

Description

This table stores trigger state transitions for tracking audience movement through states.

Columns

Column Name Data Type Description
ID BIGINT The unique identifier for the state transition.
TRIGGER_ID BIGINT The trigger ID associated with the transition.
AUDIENCE_KEY VARCHAR(255) The unique key for the audience member.
CURRENT_STATE BIGINT The current state ID.
TYPE VARCHAR(50) The type of transition.
TO_STATE BIGINT The target state ID.
TIME_STAMP_EPOCH BIGINT The timestamp of the transition in epoch format.
PAYLOAD_JSON longtext JSON payload associated with the transition.