Compare schema of Movement network and Aptos network

[ganymedio]

We need to ensure that Indexer V2 is backward compatible and works with the transactions in our current database.

• Compare Indexer V2’s schema (as defined in the code or via migrations) against our current schema (used by the current Movement indexer DB)

• Identify any:

  • Removed fields
  • Renamed tables
  • Changed types
  • Additional data not present in current DB

[ganymedio]

I've read in the documentation that the schema should be strictly backward compatible. So far when I'm running GraphQL queries the results seem consistent, that is, data from a Movement DB is able to be indexed. There are some tests that can be used to formally complete this, see https://www.notion.so/movementlabs/Indexer-migration-22818675b2d780148e5ffab000da3ab4