promotion_dimension

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