Skip to main content
Schema: movement.core Table: fact_changes Type: View State change tracking for transactions. Records all state changes that occur as a result of transaction execution.

Columns

Column NameData TypeDescription
BLOCK_NUMBERNUMBERThe block number.
BLOCK_TIMESTAMPTIMESTAMP_NTZThe timestamp of the block.
TX_HASHTEXTThe transaction hash.
VERSIONNUMBERThe transaction version number.
SUCCESSBOOLEANWhether the transaction succeeded.
TX_TYPETEXTThe type of transaction.
SENDERTEXTThe sender address.
PAYLOAD_FUNCTIONTEXTThe function called in the payload.
CHANGE_INDEXNUMBERThe index of the change within the transaction.
CHANGE_DATAOBJECTThe change data object.
CHANGE_TYPETEXTThe type of state change.
ADDRESSTEXTThe address affected by the change.
HANDLETEXTThe resource handle.
INNER_CHANGE_TYPETEXTThe inner change type classification.
CHANGE_ADDRESSTEXTThe address associated with the change.
CHANGE_MODULETEXTThe module associated with the change.
CHANGE_RESOURCETEXTThe resource being changed.
KEYTEXTThe key for the change.
VALUETEXTThe value of the change.
STATE_KEY_HASHTEXTHash of the state key.
FACT_CHANGES_IDTEXTUnique identifier for the row.
INSERTED_TIMESTAMPTIMESTAMP_NTZTimestamp when the record was inserted.
MODIFIED_TIMESTAMPTIMESTAMP_NTZTimestamp when the record was last modified.