> ## 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          | `celestia.raw.messages`                                |
| Table Status        | Production-Ready                                       |
| Unique Key          | `block_timestamp`, `transaction_hash`, `message_index` |
| Clustering Key(s)   | `to_date("block_timestamp")`                           |
| Search Optimization | `block_height`                                         |

### Table Columns

| Column Name        | Data Type         | Description                                           |
| ------------------ | ----------------- | ----------------------------------------------------- |
| type               | VARCHAR(16777216) | The type of the message.                              |
| action             | VARCHAR(16777216) | The operation performed by the message.               |
| module             | VARCHAR(16777216) | The module that processed the message.                |
| message\_index     | NUMBER(38,0)      | The index of the message within the transaction.      |
| sender             | VARCHAR(16777216) | The address that sent the message.                    |
| block\_height      | NUMBER(38,0)      | The sequential number of the block in the blockchain. |
| block\_timestamp   | TIMESTAMP\_NTZ(9) | The timestamp when the block was created.             |
| block\_hash        | VARCHAR(16777216) | The hash of the block.                                |
| transaction\_hash  | VARCHAR(16777216) | The hash of the transaction containing the message.   |
| transaction\_index | NUMBER(38,0)      | The index of the transaction within the block.        |
| \_created\_at      | TIMESTAMP\_NTZ(9) | The timestamp when the entry was created.             |
| \_updated\_at      | TIMESTAMP\_NTZ(9) | The timestamp when the entry was updated.             |

### Related Docs

* [COSMOS Raw Messages](/historical-data/supported-blockchains/cosmos-ecosystem/core-schemas/raw/messages)
