Skip to main content
Schema: movement.core Table: fact_changes Type: Base Table

What

This table contains the flattened changes from the transaction. Each change will have a unique change index within a transaction.

Columns

Column NameData TypeDescription
BLOCK_NUMBERNUMBERBLOCK_NUMBER column
BLOCK_TIMESTAMPTIMESTAMP_NTZThe date and time at which the block was produced.
TX_HASHTEXTTransaction hash is a unique 66-character identifier that is generated when a transaction is executed.
VERSIONNUMBERThe version also know as the height of the transactions that have been executed on the Movement blockchain. The first transaction in the blockchain has a version of 0. The version number is incremented by 1 for each transaction that is executed on the blockchain.
SUCCESSBOOLEANThe boolean value indicating whether the transaction was successful or not.
TX_TYPETEXTThe type of the transaction. Values will be one of “blockmetadatatransaction”,“statecheckpointtransaction”,“user_transaction”.
SENDERTEXTSender is the address of the originator account for a transaction. A transaction must be signed by the originator.
PAYLOAD_FUNCTIONTEXTThe function that is being called in the transaction payload.
CHANGE_INDEXNUMBERUnique identifier for the change. This is a monotonically increasing integer that is incremented for each change. This is useful for determining the order of changes.
CHANGE_DATAVARIANTThe “data” object within this change.
CHANGE_TYPETEXTThe “type” object from within this change. Values are: deleteresource, deletetableitem, writemodule, writeresource, writetable_item.
ADDRESSTEXTThe top level address for this change.
HANDLETEXTThe top level handle for this change.
INNER_CHANGE_TYPETEXTThe full three-part descriptive change type from change. The inner change type consists of the changeaddress :: changemodule :: change_resource.
CHANGE_ADDRESSTEXTThe first segment of the inner change type
CHANGE_MODULETEXTThe second segment of the inner change type
CHANGE_RESOURCETEXTThe third segment of the inner change type
KEYTEXTThe key value for the writetableitem change
VALUETEXTThe value for the writetableitem change
STATE_KEY_HASHTEXTSTATE_KEY_HASH column
FACT_CHANGES_IDTEXTThe unique identifier for each row in the table.
INSERTED_TIMESTAMPTIMESTAMP_NTZThe utc timestamp at which the row was inserted into the table.
MODIFIED_TIMESTAMPTIMESTAMP_NTZThe utc timestamp at which the row was last modified.