I'm writing a complex custom query to get order information from a Drupal Commerce install for export.
field_data_commerce_customer_address has a column
entity_id. I've tried to join that field on
order_id, but my results are incorrect. It doesn't match to user id... hmm.
What field should I join
And, more generally, is there a drupal entity informational function that would tell me what columns should be joined to what? Or a master entity table, or anything? Some central location that would tell me things like this so I don't have to dig around?
Looking around the database and googling but haven't found it yet.