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

What

This table contains transaction level data for the Movement blockchain. Each transaction will have a unique transaction hash and version. For more information see [docs.movementlabs.xyz docs] Each transaction will have a unique transaction hash

Columns

Column NameData TypeDescription
BLOCK_NUMBERNUMBERBLOCK_NUMBER column
BLOCK_TIMESTAMPTIMESTAMP_NTZThe date and time at which the block was produced.
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.
TX_HASHTEXTTransaction hash is a unique 66-character identifier that is generated when a transaction is executed.
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.
SIGNATURETEXTA signature is the result of hashing the signing message with the client’s private key. By default Movement uses the Ed25519 scheme to generate the signature of the raw transaction.
PAYLOADVARIANTThe data that is being carried by a transaction.
PAYLOAD_FUNCTIONTEXTThe function that is being called in the transaction payload.
CHANGESVARIANTThe changes that the transaction executed.
EVENTSVARIANTThe events that the transaction executed.
GAS_UNIT_PRICENUMBERThe cost per unit of gas, determining the transaction fee paid by the sender for each unit of computational resource consumed
GAS_USEDNUMBERThe amount of gas used for the transaction
MAX_GAS_AMOUNTNUMBERThe maximum amount of gas allocated for the execution of a transaction
EXPIRATION_TIMESTAMP_SECSNUMBERThe time at which the transaction ceases to valid.
VM_STATUSTEXTFor failed transactions, this fields provides context to why the transaction failed. For successful transactions, this field will be set to Executed successfully.
STATE_CHANGE_HASHTEXTSTATE_CHANGE_HASH column
ACCUMULATOR_ROOT_HASHTEXTThe root hash of a Merkle accumulator.
EVENT_ROOT_HASHTEXTThe root hash for the event.
STATE_CHECKPOINT_HASHTEXTSTATE_CHECKPOINT_HASH column
FACT_TRANSACTIONS_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.