Node Revision table

Posted under » Drupal on 28 Mar 2025

As mentioned in database schema and Node, Drupal strength is its versioning of contents.

node_field_revision

This is an extension of the node_field_data. There are several versions of title for example. The latest title will be reflected in the 'node_field_data'

• vid
• title
• created
• changed

node_revision

This is an extension of the node_field_revision. Thus you will get the same nid and vid in node and node_revision.

• revision_timestamp

node_revision__body

This is an extension of the node_revision. The latest body is at node__body

node_revision__comment

This is an extension of the node_revision. The latest body is at node__comment.