> ## 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.

# Messages 🌱

### Table Details

| Property          | Value                      |
| ----------------- | -------------------------- |
| Table Name        | `ton_testnet.raw.messages` |
| Table Status      | Beta 🌱                    |
| Unique Key        | `utime`, `hash`            |
| Clustering Key(s) | `to_date("utime")`         |

### Table Columns

| Column Name        | Data Type         | Description                                                                |
| ------------------ | ----------------- | -------------------------------------------------------------------------- |
| workchain          | NUMBER(38,0)      | The workchain identifier where the message was sent.                       |
| shard              | VARCHAR(16777216) | The shard identifier where the message was sent.                           |
| seqno              | NUMBER(38,0)      | The sequence number of the message.                                        |
| bounce             | BOOLEAN           | Indicates if the message should be bounced back to the sender if it fails. |
| bounced            | BOOLEAN           | Indicates if the message was bounced back to the sender.                   |
| utime              | TIMESTAMP\_NTZ(9) | The Unix timestamp when the message was created.                           |
| created\_lt        | NUMBER(38,0)      | Logical time when the message was created.                                 |
| fwd\_fee           | NUMBER(38,0)      | The forward fee associated with the message.                               |
| hash               | VARCHAR(16777216) | The hash of the message.                                                   |
| ihr\_disabled      | BOOLEAN           | Indicates if the Instant Hypercube Routing (IHR) is disabled.              |
| ihr\_fee           | NUMBER(38,0)      | The fee associated with the IHR.                                           |
| import\_fee        | NUMBER(38,0)      | The import fee associated with the message.                                |
| init\_state        | VARIANT           | The initial state of the message.                                          |
| masterchain\_seqno | NUMBER(38,0)      | The sequence number of the masterchain block.                              |
| message\_content   | VARIANT           | The content of the message.                                                |
| message\_index     | NUMBER(38,0)      | The index of the message within the block.                                 |
| opcode             | VARCHAR(16777216) | The operation code associated with the message.                            |
| source             | VARCHAR(16777216) | The source address of the message.                                         |
| transaction\_hash  | VARCHAR(16777216) | The hash of the associated transaction.                                    |
| value              | NUMBER(38,0)      | The value transferred by the message.                                      |
| destination        | VARCHAR(16777216) | The destination address of the message.                                    |
| \_created\_at      | TIMESTAMP\_NTZ(9) | Timestamp of the entry creation.                                           |
| \_updated\_at      | TIMESTAMP\_NTZ(9) | Timestamp of the entry update.                                             |

### Related Docs

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