Table Columns

Unique Key:

Column NameData TypeDescription
consensus_timestampTIMESTAMP_NTZ(9)The consensus timestamp when the action was executed
transaction_idVARCHARUnique identifier for the transaction
payer_account_idVARCHARAccount ID of the account that paid for the transaction
action_indexBIGINTIndex of the action within the transaction
recipientVARCHARAddress or account ID of the action recipient
recipient_typeVARCHARType of recipient (account, contract, etc.)
valueBIGINTAmount transferred in tinybars
call_depthBIGINTDepth of the call stack for contract calls
call_operation_typeVARCHARType of operation (CALL, DELEGATECALL, etc.)
call_typeVARCHARType of call (internal, external, etc.)
callerVARCHARAddress or account ID of the caller
caller_typeVARCHARType of caller (account, contract, etc.)
gasBIGINTGas limit for the action
gas_usedBIGINTAmount of gas actually used
inputVARCHARInput data for the action (hex encoded)
result_dataVARCHARResult data from the action (hex encoded)
result_data_typeVARCHARType of result data
errorVARCHARError message if the action failed
statusBIGINTStatus code of the action
consensus_timestamp_rawDECIMAL(29,9)Raw consensus timestamp as decimal
action_idVARCHARUnique identifier for the action
selectorVARCHARFunction selector for contract calls
block_numberBIGINTBlock number containing this action
block_hashVARCHARHash of the block containing this action
transaction_indexBIGINTIndex of the transaction within the block
transaction_nonceBIGINTNonce of the transaction
transaction_resultVARCHARResult of the parent transaction
extra_evm_fieldsVARIANTAdditional EVM-specific fields
_created_atTIMESTAMP_NTZ(9)Timestamp when this record was created
_updated_atTIMESTAMP_NTZ(9)Timestamp when this record was last updated