> ## Documentation Index
> Fetch the complete documentation index at: https://docs.allium.so/llms.txt
> Use this file to discover all available pages before exploring further.

# Blocks 🌱

### Table Details

| Property          | Value                                      |
| ----------------- | ------------------------------------------ |
| Table Name        | `ton_testnet.raw.blocks`                   |
| Table Status      | Beta 🌱                                    |
| Unique Key        | `gen_utime`, `workchain`, `shard`, `seqno` |
| Clustering Key(s) | `to_date("gen_utime")`                     |

### Table Columns

| Column Name                  | Data Type         | Description                                                           |
| ---------------------------- | ----------------- | --------------------------------------------------------------------- |
| after\_merge                 | BOOLEAN           | Indicates if the block was created after merging two shardchains.     |
| after\_split                 | BOOLEAN           | Indicates if the block was created after splitting a shardchain.      |
| before\_split                | BOOLEAN           | Indicates if the block was created before splitting a shardchain.     |
| created\_by                  | VARCHAR(16777216) | The entity (usually a validator's public key) that created the block. |
| end\_lt                      | NUMBER(38,0)      | End logical time associated with the block.                           |
| file\_hash                   | VARCHAR(16777216) | The hash of the block file.                                           |
| flags                        | NUMBER(38,0)      | Additional flags for the block.                                       |
| gen\_catchain\_seqno         | NUMBER(38,0)      | Catchain sequence number related to the block.                        |
| gen\_utime                   | TIMESTAMP\_NTZ(9) | The generation time of the block.                                     |
| global\_id                   | NUMBER(38,0)      | An ID of the network where this block is created.                     |
| key\_block                   | BOOLEAN           | Indicates if this block is a key block.                               |
| master\_ref\_seqno           | NUMBER(38,0)      | The sequence number of the masterchain block.                         |
| masterchain\_block\_ref      | VARIANT           | Reference to the corresponding masterchain block.                     |
| masterchain\_seqno           | NUMBER(38,0)      | Sequence number of the corresponding masterchain block.               |
| min\_ref\_mc\_seqno          | NUMBER(38,0)      | Minimum reference sequence number of the masterchain block.           |
| prev\_blocks                 | VARIANT           | List of previous blocks in the shardchain.                            |
| prev\_key\_block\_seqno      | NUMBER(38,0)      | Sequence number of the previous key block.                            |
| rand\_seed                   | VARCHAR(16777216) | Random seed used in the block.                                        |
| root\_hash                   | VARCHAR(16777216) | The root hash of the block.                                           |
| seqno                        | NUMBER(38,0)      | The sequence number of the block.                                     |
| shard                        | VARCHAR(16777216) | The shard identifier of the block.                                    |
| start\_lt                    | NUMBER(38,0)      | Start logical time associated with the block.                         |
| tx\_count                    | NUMBER(38,0)      | The count of transactions in the block.                               |
| validator\_list\_hash\_short | NUMBER(38,0)      | Short hash of the validator list.                                     |
| version                      | NUMBER(38,0)      | Version of the block format.                                          |
| vert\_seqno                  | NUMBER(38,0)      | Vertical sequence number of the block.                                |
| vert\_seqno\_incr            | NUMBER(38,0)      | Vertical sequence number increment.                                   |
| want\_merge                  | BOOLEAN           | Indicates if the block wants to merge shardchains.                    |
| want\_split                  | BOOLEAN           | Indicates if the block wants to split the shardchain.                 |
| workchain                    | NUMBER(38,0)      | The workchain identifier of the block.                                |
| \_created\_at                | TIMESTAMP\_NTZ(9) | Timestamp of the entry creation.                                      |
| \_updated\_at                | TIMESTAMP\_NTZ(9) | Timestamp of the entry update.                                        |

### Related Docs

* [Ton Raw Blocks](/historical-data/supported-blockchains/other-ecosystems/ton/raw/blocks)