| height | NUMBER(38,0) | The block number (height) in the chain. |
| timestamp | TIMESTAMP_NTZ(9) | The time when the block was produced. |
| hash | VARCHAR(16777216) | Unique identifier (BLAKE2b-256 hash) of the block. |
| previous_block | VARCHAR(16777216) | Hash of the preceding block in the chain. |
| next_block | VARCHAR(16777216) | Hash of the following block in the chain. |
| epoch | NUMBER(38,0) | The epoch number (a 5-day period of 432,000 slots) in which the block was produced. |
| slot | NUMBER(38,0) | The absolute slot number in which the block was produced. |
| epoch_slot | NUMBER(38,0) | The position of the slot within its epoch, ranging from 0 to 431,999. |
| slot_leader | VARCHAR(16777216) | The stake pool or genesis key hash of the node that produced this block. |
| block_vrf | VARCHAR(16777216) | The verifiable random function (VRF) key hash used to verify the slot leader’s authority to produce this block. |
| op_cert | VARCHAR(16777216) | The operational certificate proving the stake pool operator’s authority to produce blocks, signed by the pool’s cold key. |
| op_cert_counter | NUMBER(38,0) | The issue counter for the operational certificate, used to invalidate compromised KES keys (higher values supersede lower ones). |
| size | NUMBER(38,0) | The size of the block in bytes. |
| fees | NUMBER(38,0) | Total transaction fees collected in this block, in lovelace. |
| output | VARCHAR(16777216) | Total output value of all transactions in this block, in lovelace. |
| confirmations | NUMBER(38,0) | Number of blocks that have been produced after this block. |
| transactions | VARIANT | Array of transaction hashes included in this block. |
| transaction_count | NUMBER(38,0) | Number of transactions included in this block. |
| _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. |
