Markdown and Promotions Data Model

Entity Relationship Diagram (ERD) for the B2C pricing (markdown and promotions) data model, showing relationships between products, locations, and pricing entities.

This data model supports the Merchandising solution. For a full overview of the solution, see About the Merchandising Solution.

Tables Summary

Object	Primary Key	Foreign Keys
location	location_id	-
product_category	product_category_id	-
product	product_id	lowest_product_category_id → product_category
product_extra	product_extra_attribute, product_extra_value, product_id	product_id → product
product_pricing_daily	location_id, pricing_at, product_id	location_id → location, product_id → product
purchase_order	order_number, product_id	product_id → product, location_id → location
sale	location_id, product_id, sold_at	location_id → location, product_id → product
sale_extra	product_id, location_id, product_variant, sold_at	product_id → product, location_id → location
stock	location_id, product_id, stock_date_at	location_id → location, product_id → product
stock_extra	product_id, location_id, product_variant, stock_date_at	product_id → product, location_id → location
tax	product_id, location_id, created_at	location_id → location, product_id → product
currency_conversion	from_currency, to_currency, created_at	-