Skip to main content

Table Details

PropertyValue
Table Namestellar.raw.transactions_v2
Table StatusProduction-Ready
Unique Keyhash
Clustering Key(s)to_date("ledger_close_time")
Search Optimizationhash, ledger_sequence, source_account

Table Columns

Column NameData TypeDescription
hashVARCHAR(16777216)Hash of this transaction.
transaction_indexNUMBER(38,0)Position of the transaction within its ledger.
source_accountVARCHAR(16777216)Account (G-address) that created and signed this transaction.
source_account_muxedVARCHAR(16777216)Multiplexed (M-address) form of the source account, if used.
source_account_sequenceNUMBER(38,0)Sequence number of the source account at the time of this transaction.
transaction_resultVARCHAR(16777216)Transaction result code.
successfulBOOLEANTrue if this transaction was included in a ledger and executed without errors.
memo_typeVARCHAR(16777216)Type of memo attached to this transaction (none, text, id, hash, return).
memoVARCHAR(16777216)Memo attached to this transaction.
memo_bytesVARCHAR(16777216)Raw bytes of the transaction memo (for memo_type hash or return).
transaction_max_feeNUMBER(38,0)Maximum fee the sender authorized for this transaction, in stroops.
inner_transaction_max_feeNUMBER(38,0)Maximum fee set on the inner transaction of a fee-bump, in stroops.
fee_chargedNUMBER(38,0)Actual fee charged for this transaction, in stroops.
total_non_refundable_resource_fee_chargedNUMBER(38,0)Soroban resource fees charged that are non-refundable regardless of execution result, in stroops.
total_refundable_resource_fee_chargedNUMBER(38,0)Soroban resource fees charged that are refundable if execution uses less than budgeted, in stroops.
resource_fee_chargedNUMBER(38,0)Resource fee charged for Soroban execution, in stroops.
inclusion_fee_chargedNUMBER(38,0)Fee charged for including this transaction in the ledger, in stroops.
resource_fee_refundNUMBER(38,0)Unused resource fee refunded to the sender after Soroban execution, in stroops.
fee_accountVARCHAR(16777216)Account (G-address) that paid the transaction fees.
fee_account_muxedVARCHAR(16777216)Multiplexed (M-address) form of the fee-paying account, if used.
fee_account_muxed_idVARCHAR(16777216)64-bit sub-account id of the multiplexed fee-paying account.
fee_bump_transactionVARIANTDetails of the fee-bump wrapper transaction, if this is a fee-bump.
envelope_xdrVARCHAR(16777216)Base64-encoded XDR of the full transaction envelope including signatures.
fee_meta_xdrVARCHAR(16777216)Base64-encoded XDR of the fee metadata for this transaction.
result_xdrVARCHAR(16777216)Base64-encoded XDR of the transaction execution result.
result_meta_xdrVARCHAR(16777216)Base64-encoded XDR of the transaction result metadata including all ledger changes.
preconditionsVARIANTPreconditions on this transaction (time bounds, ledger bounds, etc.).
inner_transactionVARIANTThe inner (wrapped) transaction in a fee-bump transaction.
signaturesVARCHAR(16777216)Decorated signatures authorizing this transaction.
ledger_sequenceNUMBER(38,0)Sequence number of the ledger containing this transaction.
ledger_close_timeTIMESTAMP_NTZ(9)Time when the ledger containing this transaction closed and was finalized.
ledger_hashVARCHAR(16777216)Hash of the ledger containing this transaction.
operation_countNUMBER(38,0)Number of operations included in this transaction.
_extra_fieldsVARIANTCatch-all of additional source fields not mapped to a dedicated column.
_created_atTIMESTAMP_NTZ(9)Timestamp of when the entry was created in the database.
_updated_atTIMESTAMP_NTZ(9)Timestamp of when the entry was last updated in the database.
transaction_eventsVARIANTArray of token-transfer and SEP-41 events emitted in the transaction.