ccdw_fact_promotion_activation
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) | Anonymous visitor ID. | No | |
customer_id | BIGINT | FK | Foreign key to ccdw_dim_customer . | Yes |
locale_id | SMALLINT | FK | Foreign key to ccdw_dim_locale . | Yes |
user_agent_id | INTEGER | FK | Foreign key to ccdw_dim_user_agent . | Yes |