Rebuy & Replenishment Data Model

Entity Relationship Diagram (ERD) for the Rebuy & Replenishment data model, showing relationships between locations, products, stock, orders, and supplier entities.

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

Tables Summary

Table	Primary Key	Foreign Keys	Required
locations	location_id	-	Required
products	product_id	-	Required
suppliers	supplier_id	-	Required
stock_daily	product_id, location_id, day_date	product_id → products, location_id → locations	Required
pricing	product_id, location_id, created_at	product_id → products, location_id → locations	Required
order_parameters	product_id, location_id	product_id → products, location_id → locations	Required
purchase_orders	order_number	product_id → products, location_id → locations	Required
sales_daily	product_id, location_id, day_date	product_id → products, location_id → locations	Required
transfers	product_id, location_id, order_number	product_id → products, location_id → locations	Optional. This table can be empty if no transfers exist
product_extra	product_id, product_extra_id	product_id → products	Optional. Tenant-specific product attributes in key-value format
sku_calendar	product_id, location_id	product_id → products, location_id → locations	Optional. End date required for discontinued products
products_parent_child_mapping	child_id	parent_id → products, child_id → products	Optional. Parent-child relationships between products for substitution and hierarchy modelling