where does drupal store the actual content in the database?

Question

Hi experts,, I have opened the database of drupal 7 and looked up in the tables node, node_revisions and node types and couldn't find where drupal stores the actual body of the node (content). any body have a clue?

Answer 1

Ohh I've just found it,, in D7 they implemented fields to allow custom fields in content. so the node body is considered just a field and it's value is stored in the table field_revision_body now (in D7) instead of node_revision in D6.

if you cite any references for drupal database structure that would be helpful.

thanks for reading.