Table description
The blocks table stores basic information about Substrate blocks, with one record per block, including the block hash and statistics on the number of extrinsics, events, and transfers contained in each block.Table Schema
| Column | Type | Description |
|---|---|---|
year | INTEGER | Calendar year of the block (partition column) |
month | INTEGER | Calendar month of the block (partition column) |
day | INTEGER | Calendar day of the block (partition column) |
block_time | TIMESTAMP | The timestamp when the block was produced |
number | BIGINT | The sequential block number |
spec_version | BIGINT | Runtime specification version active at this block |
relay_block_number | BIGINT | Corresponding relay chain block number (for parachains) |
hash | VARBINARY | Unique hash identifying this block |
parent_hash | VARBINARY | Hash of the preceding block |
state_root | VARBINARY | Root hash of the state trie after this block |
extrinsics_root | VARBINARY | Root hash of the extrinsics trie for this block |
author_ss58 | VARCHAR | SS58-encoded address of the block author/validator |
author_pub_key | VARBINARY | Public key of the block author/validator |
relay_state_root | VARBINARY | State root of the relay chain at this block (for parachains) |
extrinsic_count | BIGINT | Number of extrinsics included in this block |
event_count | BIGINT | Number of events emitted in this block |
transfer_count | BIGINT | Number of token transfers in this block |
trace_count | BIGINT | Number of traces recorded for this block |
updated_at | TIMESTAMP | When this record was last updated in the database |
ingested_at | TIMESTAMP | When this record was first ingested into the database |