Exclusive: all our customers get a free six-month subscription to EDNA, a next-gen data and AI learning platform

Knowledge base

Data Model Explorer

Our Data Model Explorer provides an Entity Relationship Diagram (ERD) of your BigCommerce data, allowing you to see the relationships between your different tables.

  1. Drag tables around the workspace, by clicking and dragging anywhere on a table
  2. Drag the entire workspace around by clicking and dragging the background
  3. Minimize/maximize your workspace to take up your entire browser screen

Relationships

Relationships are depicted by the arrows running between table properties. For a tidier view, you may select the Relationships Only checkbox, which will hide all the other columns which are not part of a relationship

Endpoints

  • Brand
  • Category
  • Product
  • Channel
  • Customer
  • Location
  • Order
  • Site
  • Tax class
  • Tax rate
  • Tax zone
  • Product category
  • Product variant
  • Product variant option
  • Customer address
  • Location operating hours
  • Shipping consignment
  • Digital consignment
  • Site url
  • Tax rate class rate
  • Product variant option selected value
  • Product variant option value
  • Shipping consignment line
  • Digital consignment line