I am working on a query that involves the field_data_body Drupal table, and I have been asked to return corresponding node ids for the relevant rows in field_data_body.
However, after reaching a copy of what I think is the accurate database diagram for Drupal databases here -
I don't see how the node table relates to the field_data_body table, so I don't know what kinds of joins I could do to connect them.
I am a DBA working with the database so I am using only SQL. Although if there is a better way to return a report linking these two (in PHP, etc.) I'd be grateful if someone could let me know that, too.
Thanks for any help, jrdevdba