Quote Pricing Data Model

Entity Relationship Diagram (ERD) for the B2B pricing (quote pricing) data model, showing relationships between customers, merchants, products, and quote lines.

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

Tables Summary

Object	Primary Key	Foreign Keys	Required
customer	customer_id, updated_at	-	Yes
merchant	merchant_id, updated_at	-	No
product	product_id, updated_at	-	Yes
project	project_id, updated_at	-	No (highly recommended)
region	region_id, updated_at	-	Yes
competitor_price	product_id, region_id, updated_at	product_id → product, region_id → region	No
list_price	product_id, region_id, price_list_id, updated_at	product_id → products, region_id → region	Yes
product_cost	product_id, region_id, updated_at	product_id → product, region_id → region	Yes
quote_line	quote_id, product_id	product_id → product, customer_id → customer, merchant_id → merchant, project_id → project, region_id → region	Yes
sale	sale_id, product_id	product_id → product, customer_id → customer, merchant_id → merchant, quote_id → quote_lines	Yes