Skip to main content
Schema: movement.core Table: fact_transactions Type: View Core transaction data for all Movement transactions. Contains comprehensive information about each transaction including payload, gas, and execution results.

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.
SIGNATUREOBJECTThe transaction signature.
PAYLOADOBJECTThe transaction payload.
PAYLOAD_FUNCTIONTEXTThe function called in the payload.
CHANGESARRAYArray of state changes.
EVENTSARRAYArray of events emitted.
GAS_UNIT_PRICENUMBERThe gas unit price.
GAS_USEDNUMBERThe amount of gas used.
MAX_GAS_AMOUNTNUMBERThe maximum gas amount specified.
EXPIRATION_TIMESTAMP_SECSNUMBERThe transaction expiration timestamp.
VM_STATUSTEXTThe VM execution status.
STATE_CHANGE_HASHTEXTHash of the state changes.
ACCUMULATOR_ROOT_HASHTEXTThe accumulator root hash.
EVENT_ROOT_HASHTEXTThe event root hash.
FACT_TRANSACTIONS_IDTEXTUnique identifier for the row.
INSERTED_TIMESTAMPTIMESTAMP_NTZTimestamp when the record was inserted.
MODIFIED_TIMESTAMPTIMESTAMP_NTZTimestamp when the record was last modified.