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 |
