block_height | BIGINT | Sequential number identifying the block’s position in the chain |
block_date | DATE | Date of the block for daily aggregations |
block_time | TIMESTAMP | Timestamp when the block was committed |
block_hash | VARBINARY | Unique cryptographic hash identifying the block |
block_first_version | UINT256 | First transaction version included in the block |
block_last_version | UINT256 | Last transaction version included in the block |
block_proposer | VARBINARY | Address of the validator that proposed the block |
block_round | UINT256 | Consensus round number for the block |
block_epoch | UINT256 | Epoch number during which the block was created |
block_metadata_id | VARBINARY | Unique identifier for the block metadata event |
block_failed_proposer_indices | ARRAY(INTEGER) | Indices of validators that failed to propose before this block |
block_previous_block_votes_bitvec | ARRAY(SMALLINT) | Bit vector of validator votes on the previous block |
tx_index | INTEGER | Position of the transaction within the block |
tx_type | VARCHAR | Type of the transaction (always user_transaction for this table) |
hash | VARBINARY | Unique hash identifying this transaction |
version | UINT256 | Global sequential version number assigned to this transaction |
gas_used | UINT256 | Amount of gas consumed by the transaction |
vm_status | VARCHAR | Detailed status message returned by the Move VM after execution |
success | BOOLEAN | Whether the transaction executed successfully |
state_change_hash | VARBINARY | Hash of all state changes produced by the transaction |
event_root_hash | VARBINARY | Merkle root hash of all events emitted by the transaction |
state_checkpoint_hash | VARBINARY | Hash of the state checkpoint after this transaction |
accumulator_root_hash | VARBINARY | Root hash of the transaction accumulator after this transaction |
timestamp | UINT256 | Unix timestamp of the transaction in microseconds |
sender | VARBINARY | Address of the account that submitted the transaction |
max_gas_amount | UINT256 | Maximum gas units the sender is willing to pay |
gas_unit_price | UINT256 | Price per gas unit in octas (1 APT = 10^8 octas) |
sequence_number | UINT256 | Sender’s account sequence number at the time of this transaction |
expiration_timestamp_secs | UINT256 | Unix timestamp (seconds) after which the transaction expires |
events_count | INTEGER | Number of events emitted by this transaction |
changes_count | INTEGER | Number of state changes produced by this transaction |
payload_type | VARCHAR | Type of transaction payload (e.g. entry_function_payload, script_payload) |
entry_function_name | VARCHAR | Name of the entry function called (empty if script payload) |
entry_function_module_name | VARCHAR | Module containing the entry function called |
entry_function_module_address | VARBINARY | Address of the module containing the entry function |
script_bytecode | VARBINARY | Compiled bytecode of the script payload (empty if entry function) |
script_abi | VARCHAR | ABI definition of the script payload |
type_arguments | ARRAY(VARCHAR) | Generic type arguments passed to the entry function or script |
arguments | ARRAY(VARCHAR) | Arguments passed to the entry function or script |
