ER (Entity Relationships) Diagram for Drupal Commerce

I'm currently working on understanding Drupal Commerce. I only have a fuzzy idea of how all the different entities (not just Drupal "entities") relate.

We have a list here: http://www.drupalcommerce.org/specification/entities
Product entity
Customer profile entity
Line item entity
Order entity
Payment transaction entity

Here's my guess so far:

Feel free to revise if you know better :) Edit here -> https://docs.google.com/drawings/d/1ocgXSkwALAUPhjtY6X9-jU2ObWVlPDOvAQI2...

Posted: Jan 24, 2012


rfay Randy Fay on January 24, 2012

I'm not sure that the traditional ER diagram is the right concept for Drupal's entities and fields, but that's OK. It works well enough. Drupal is always redefining terms.

The easy way to get all these right is just to look at the "reference" fields on each entity. So as far as I can tell, everything you have is right, except that a line item does not necessarily have a product reference (only product line items do).