Difference between field_data and field_revision tables? I have a lot of custom functions; I just want to make sure I'm doing this right.
If I want the most recent version—the live version—of a node, I go to the field_data_field_xyz table, right?  

My understanding is the field_revision_field_xyz keeps all older versions, correct?
That is correct: Working with Field SQL Storage.


  Database tables:  
  
  
  {field_data_[field_name]} Standard data storage for a field.  
  {field_revision_[field_name]} Standard revision storage for a field.