Table description
Theaptos.blocks table represents the blocks in the Aptos blockchain. A block is a collection of transactions, and is identified by a unique block identifier. Each block contains a timestamp and a reference to the previous block hash, forming a chain of blocks. The block structure is crucial for the blockchain’s integrity and security, ensuring a verifiable and tamper-evident ledger.
Table Schema
| Column | Type | Description |
|---|---|---|
block_height | BIGINT | Sequential number identifying the block’s position in the chain |
time | TIMESTAMP | Timestamp when the block was proposed and committed |
block_date | DATE | Date of the block, truncated from the timestamp for daily aggregations |
block_hash | VARBINARY | Unique cryptographic hash identifying this block |
first_version | UINT256 | The first transaction version included in this block |
last_version | UINT256 | The last transaction version included in this block |
proposer | VARBINARY | Address of the validator that proposed this block |
round | UINT256 | Consensus round number in which this block was produced |
epoch | UINT256 | Epoch number during which this block was created |
metadata_id | VARBINARY | Unique identifier for the block metadata event |
failed_proposer_indices | ARRAY(INTEGER) | Indices of validators that failed to propose before this block was finalized |
previous_block_votes_bitvec | ARRAY(SMALLINT) | Bit vector indicating which validators voted on the previous block |
transactions_count | INTEGER | Total number of transactions included in this block |