transaction_digest | string | Unique hash identifier of the transaction |
checkpoint | decimal(20,0) | Checkpoint sequence number containing this transaction |
epoch | decimal(20,0) | Epoch number when the transaction was executed |
timestamp_ms | decimal(20,0) | Unix timestamp in milliseconds when transaction was executed |
date | date | Date of when the transaction was executed |
sender | binary | Binary representation of the address that initiated the transaction |
transaction_kind | string | Type of transaction (e.g., “ProgrammableTransaction”, “ChangeEpoch”, “Genesis”) |
is_system_txn | boolean | Whether this is a system transaction |
is_sponsored_tx | boolean | Whether this is a sponsored transaction |
transaction_count | decimal(20,0) | Number of transactions in the batch |
execution_success | boolean | Whether the transaction executed successfully |
input | decimal(20,0) | Number of input objects |
shared_input | decimal(20,0) | Number of shared input objects |
gas_coins | decimal(20,0) | Number of gas coins used |
created | decimal(20,0) | Number of objects created |
mutated | decimal(20,0) | Number of objects mutated |
deleted | decimal(20,0) | Number of objects deleted |
transfers | decimal(20,0) | Number of transfers performed |
split_coins | decimal(20,0) | Number of coin splits performed |
merge_coins | decimal(20,0) | Number of coin merges performed |
publish | decimal(20,0) | Number of packages published |
upgrade | decimal(20,0) | Number of package upgrades |
others | decimal(20,0) | Number of other operations |
move_calls | decimal(20,0) | Number of move calls made |
packages | string | Packages involved in the transaction |
gas_owner | binary | Binary representation of the gas owner address |
gas_object_id | binary | Binary representation of the gas object ID |
gas_object_sequence | decimal(20,0) | Sequence number of the gas object |
gas_object_digest | string | Digest of the gas object |
gas_budget | decimal(20,0) | Gas budget allocated for the transaction |
total_gas_cost | bigint | Total gas cost for the transaction |
computation_cost | decimal(20,0) | Computation cost component of gas |
storage_cost | decimal(20,0) | Storage cost component of gas |
storage_rebate | decimal(20,0) | Storage rebate received |
non_refundable_storage_fee | decimal(20,0) | Non-refundable storage fees |
gas_price | decimal(20,0) | Gas price for the transaction |
raw_transaction | string | Raw transaction data |
has_zklogin_sig | boolean | Whether the transaction has zkLogin signature |
has_upgraded_multisig | boolean | Whether the transaction has upgraded multisig |
transaction_json | string | JSON representation of the transaction |
effects_json | string | JSON representation of the transaction effects |
transaction_position | decimal(20,0) | Position of the transaction within the checkpoint |
events_digest | string | Digest of events emitted by the transaction |
transaction_data_bcs_length | decimal(20,0) | Length of transaction data BCS in bytes |
effects_bcs_length | decimal(20,0) | Length of effects BCS in bytes |
events_bcs_length | decimal(20,0) | Length of events BCS in bytes |
signatures_bcs_length | decimal(20,0) | Length of signatures BCS in bytes |
_updated_at | timestamp | Last time the record was updated |
_ingested_at | timestamp | Time when the record was ingested |