I'm in the process of migrating a complex D6 site up to D8 using the Migration tool. An old table
content_field_gallery seems to have been migrated to a
node_revision__field_gallery table, but there is also a
node__field_gallery table with about half as many rows.
I'm guessing that the
node__field_X version has only the latest revision and the
node_revision__field_X has ALL revisions. Is that correct? Isn't that redundant? And a good index should make a single table pretty efficient? Where can I read more about this?