| tipset_height | NUMBER(38,0) | Filecoin tipset height (block height). A tipset is a set of blocks at the same height that form the canonical chain. |
| tipset_timestamp | TIMESTAMP_NTZ(9) | Timestamp (UTC) of the Filecoin tipset. |
| block_cid | VARCHAR(16777216) | Content identifier (CID) of this Filecoin block, used as the block’s unique address in the content-addressed storage system |
| block_index | NUMBER(38,0) | Position of this block within the tipset’s block array |
| miner | VARCHAR(16777216) | The address of the beneficiary to whom the mining rewards were given. |
| bls_aggregate | VARIANT | Aggregated BLS signature covering all BLS-signed messages in this block |
| beacon_entries | VARIANT | Array of Drand randomness beacon entries included in this Filecoin block for verifiable randomness |
| block_sig | VARIANT | Block producer’s BLS signature over this block |
| election_proof | VARIANT | Winning proof-of-spacetime ticket that qualified this miner to produce a block in this epoch |
| fork_signalling | NUMBER(38,0) | Miner-signalled value for network upgrade voting |
| messages_root | VARIANT | CID of the AMT (Array Mapped Trie) containing all messages in this block |
| parent_base_fee | NUMBER(38,0) | Base fee of the parent tipset (attoFIL per gas unit), used to compute this tipset’s base fee |
| parent_weight | NUMBER(38,0) | Cumulative chain weight at the parent tipset |
| parent_message_receipts | VARIANT | CID of the parent message receipts AMT |
| parent_state_root | VARIANT | CID of the state tree root after applying the parent tipset |
| parent_block_cids | VARIANT | Array of CIDs of the parent tipset’s blocks |
| ticket | VARIANT | Miner’s randomness ticket used to determine leader election eligibility |
| winning_proof_of_spacetime_proof | VARIANT | Winning proof-of-spacetime submitted by the miner to claim the block reward for this epoch |
| block_cid_raw | VARCHAR(16777216) | Raw bytes of the block CID before CID encoding |
| messages | VARIANT | Array of messages emitted or received in this transaction. |
| message_count | NUMBER(38,0) | Number of messages included in this Filecoin block or tipset |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was created in the database. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was last updated in the database. |
