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