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 |
