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, state_checkpoint) |
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 |
events_count | INTEGER | Number of events emitted by this transaction |
changes_count | INTEGER | Number of state changes produced by this transaction |
