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