ccdw_aggr_promotion_cobuy
Each row in this table represents a pair of promotions in the same purchases.
| Column Alias | Data Type | Key | Description | Index? |
|---|---|---|---|---|
submit_date | DATE | PK | The date the orders were submitted. | Yes |
promotion_one_id | INTEGER | FK | Foreign key to ccdw_dim_promotion for first promotion. | Yes |
promotion_two_id | INTEGER | FK | Foreign key to ccdw_dim_promotion for second promotion. | Yes |
promotion_one_class | VARCHAR | PK | The class of the first promotion (ex 'Shipping'). | Yes |
promotion_two_class | VARCHAR | PK | The class of the second promotion (ex 'Shipping'). | Yes |
order_channel | VARCHAR | PK | Order channel designation. | Yes |
nsite_id | VARCHAR | PK | Natural site identifier. | Yes |
registered | BOOLEAN | PK | true for records that represent register users, false otherwise. | Yes |
first_time_buyer | BOOLEAN | PK | true for records the represent first time buyers, false otherwise. | Yes |
device_class_code | VARCHAR | PK | Device classification code. | Yes |
locale_code | VARCHAR | PK | Locale code for language/region. | Yes |
frequency_count | BIGINT | The frequency of occurrences between the two promotions. | No |