promotion_dimension
This table describes every promotion ever done by the retail chain.
This table describes every promotion ever done by the retail chain.
| Column Name | Data Type | NULLs |
promotion_key |
INTEGER | No |
promotion_name |
VARCHAR(128) | Yes |
price_reduction_type |
VARCHAR(32) | Yes |
promotion_media_type |
VARCHAR(32) | Yes |
ad_type |
VARCHAR(32) | Yes |
display_type |
VARCHAR(32) | Yes |
coupon_type |
VARCHAR(32) | Yes |
ad_media_name |
VARCHAR(32) | Yes |
display_provider |
VARCHAR(128) | Yes |
promotion_cost |
INTEGER | Yes |
promotion_begin_date |
DATE | Yes |
promotion_end_date |
DATE | Yes |