| timestamp | TIMESTAMP_NTZ(9) | Timestamp indicating when this block was mined. |
| number | NUMBER(38,0) | The number of the block in the blockchain. |
| hash | VARCHAR(66) | The unique identifier or hash of the block. |
| confirmations | NUMBER(38,0) | Number of blocks that have been mined after this block, indicating how deeply it is embedded in the chain. |
| version | NUMBER(38,0) | The block version number. |
| merkle_root | VARCHAR(66) | The root of the Merkle tree of all transactions in the block, used to verify transaction integrity. |
| median_time | NUMBER(38,0) | The median timestamp of the last 11 blocks, used for time-lock transactions. |
| nonce | NUMBER(38,0) | A 32-bit number that miners change to try to get a valid block hash. |
| bits | VARCHAR(16777216) | The encoded difficulty target for this block. |
| difficulty | FLOAT | The difficulty target for this block, indicating how hard it was to mine. |
| chainwork | VARCHAR(16777216) | The total amount of work that has been done to mine all blocks up to and including this one. |
| transaction_count | NUMBER(38,0) | The number of transactions included in this block. |
| previous_block_hash | VARCHAR(66) | The hash of the previous block in the chain. |
| next_block_hash | VARCHAR(66) | The hash of the next block in the chain. |
| stripped_size | NUMBER(38,0) | The size of the block in bytes, excluding witness data. |
| size | NUMBER(38,0) | The total size of the block in bytes, including all transaction data. |
| weight | NUMBER(38,0) | The block weight, used to measure block size limits in the network. |
| auxpow | VARIANT | Auxiliary Proof of Work data, used in merged mining with other cryptocurrencies. |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of when this record was created in the database. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of when this record was last updated in the database. |
