Documentation Index
Fetch the complete documentation index at: https://docs.dune.com/llms.txt
Use this file to discover all available pages before exploring further.
Table description
Theaptos.signatures table documents the signatures associated with transactions on the Aptos blockchain. Signatures are critical for securing transactions, proving the identity of the sender, and ensuring data integrity. This table includes the signature type, data, and the transaction it authenticates, offering insights into the security mechanisms at play.
Table Schema
| Column | Type | Description |
|---|---|---|
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 (e.g. user_transaction, block_metadata) |
tx_hash | VARBINARY | Unique hash identifying the transaction |
tx_version | UINT256 | Global sequential version number of the transaction |
tx_gas_used | UINT256 | Amount of gas consumed by the transaction |
tx_vm_status | VARCHAR | Detailed status message returned by the Move VM |
tx_success | BOOLEAN | Whether the transaction executed successfully |
tx_state_change_hash | VARBINARY | Hash of all state changes produced by the transaction |
tx_event_root_hash | VARBINARY | Merkle root hash of all events emitted by the transaction |
tx_state_checkpoint_hash | VARBINARY | Hash of the state checkpoint after this transaction |
tx_accumulator_root_hash | VARBINARY | Root hash of the transaction accumulator after this transaction |
tx_timestamp | UINT256 | Unix timestamp of the transaction in microseconds |
tx_sender | VARBINARY | Address of the account that submitted the transaction |
tx_max_gas_amount | UINT256 | Maximum gas units the sender is willing to pay |
tx_gas_unit_price | UINT256 | Price per gas unit in octas (1 APT = 10^8 octas) |
tx_sequence_number | UINT256 | Sender’s account sequence number at the time of this transaction |
tx_expiration_timestamp_secs | UINT256 | Unix timestamp (seconds) after which the transaction expires |
type | VARCHAR | Top-level signature scheme type (e.g. ed25519, multi_ed25519, multi_agent) |
signer_type | VARCHAR | Role of the signer (e.g. sender, secondary_signer, fee_payer) |
signer_signature_type | VARCHAR | Cryptographic algorithm used by this signer (e.g. ed25519, secp256k1_ecdsa) |
is_single_sender | BOOLEAN | Whether the transaction has a single sender (as opposed to multi-agent) |
signer_address | VARBINARY | Address of this particular signer |
secondary_signer_index | INTEGER | Index of this signer among secondary signers (-1 for primary sender) |
public_key | VARBINARY | Public key used to create the signature |
signature | VARBINARY | Cryptographic signature bytes |
bitmap | VARBINARY | Bitmap indicating which keys signed in a multi-key scheme |
bitmap_public_key_index | INTEGER | Index of this public key within the bitmap |
threshold | BIGINT | Minimum number of signatures required for multi-key authentication |