aptos.signatures

Aptos transaction signatures — authentication data including public keys and signature schemes.

Table description

The aptos.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

Table Sample