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 |
write_set_change_index | INTEGER | Index of this state change within the transaction’s write set |
write_set_change_type | VARCHAR | Type of write set change (e.g. write_resource, delete_resource) |
move_state_key_hash | VARBINARY | Hash of the state key affected by this change |
move_is_deletion | BOOLEAN | Whether this change represents a deletion of the resource |
move_data | VARCHAR | JSON-encoded data payload of the Move resource |
move_address | VARBINARY | Address of the account that owns this resource |
move_module_address | VARBINARY | Address of the module that defines this resource type |
move_resource_module | VARCHAR | Name of the module that defines this resource type |
move_resource_name | VARCHAR | Name of the resource struct type |
move_resource_generic_type_params | ARRAY(VARCHAR) | Generic type parameters applied to this resource instance |
