This table records instances where promotions are activated.
| Column Alias | Data Type | Key | Description | Index? |
|---|---|---|---|---|
promotion_activation_id |
BIGINT | PK | Unique identifier for a promotion activation event. | Yes |
utc_activation_timestamp |
TIMESTAMP | UTC timestamp of the promotion activation. | Yes | |
utc_activation_day_id |
SMALLINT | FK | Foreign key to ccdw_dim_date for the UTC activation day. |
Yes |
utc_activation_time_id |
SMALLINT | FK | Foreign key to ccdw_dim_time for the UTC activation time. |
No |
utc_update_timestamp |
TIMESTAMP | Last modified UTC timestamp of this record. | Yes | |
std_activation_timestamp |
TIMESTAMP | Timestamp of the promotion activation, in standard time. | No | |
std_activation_day_id |
SMALLINT | FK | Foreign key to ccdw_dim_date for the standard activation day. |
Yes |
std_activation_time_id |
SMALLINT | FK | Foreign key to ccdw_dim_time for the standard activation time. |
No |
std_activation_timezone_id |
SMALLINT | FK | Foreign key to ccdw_dim_timezone for the standard activation time zone. |
No |
promotion_id |
INTEGER | FK | Foreign key to ccdw_dim_promotion. |
Yes |
campaign_id |
INTEGER | FK | Foreign key to ccdw_dim_campaign. |
Yes |
activation_site_id |
SMALLINT | FK | Foreign key to ccdw_dim_site where the promotion was activated. |
Yes |
visitor_id |
VARCHAR(100) | Unique identifier for a visitor session. This ID persists across sessions and is associated with an anonymous tracking cookie (for example, dwanonymous). | No | |
customer_id |
BIGINT | FK | Foreign key to ccdw_dim_customer. For unregistered buyers, this value is 1 and can't distinguish one unregistered buyer from another. |
Yes |
is_anonymous |
BOOLEAN | Indicates whether customer is anonymous or registered. | No | |
locale_id |
SMALLINT | FK | Foreign key to ccdw_dim_locale. |
Yes |
user_agent_id |
INTEGER | FK | Foreign key to ccdw_dim_user_agent. |
Yes |