Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
Can someone explain the difference between the two tables please?
Thanks
Comments
Comment #1
rszrama CreditAttribution: rszrama commentedPer the issue submission guidelines, we don't offer support in this issue queue. Please repost this question on http://www.drupalcommerce.org/questions and link to it. I'm happy to provide an answer there.
Comment #2
GuyPaddock CreditAttribution: GuyPaddock at RedBottle Design, LLC for Inveniem commented@bsandor: I believe that
field_data_commerce_line_items
represents the data in the order line items field exposed to Entity API, whereascommerce_line_item
stores the line items that the data table points to. The former is an entity reference, while the latter is the actual order line item information.Technically, the data table should be unnecessary because it's possible to JOIN the order table to the
commerce_line_item
table via theorder_id
column of the line item to find the line items for the order. If I had to guess the data table is probably required for the Entity API to be able to navigate the order's relationships.