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

Unique Key:

| Column Name               | Data Type         | Description                                                    |
| ------------------------- | ----------------- | -------------------------------------------------------------- |
| consensus\_timestamp      | TIMESTAMP\_NTZ(9) | The consensus timestamp when the message was submitted         |
| topic\_id                 | VARCHAR           | Unique identifier for the topic                                |
| sequence\_number          | BIGINT            | Sequence number of the message within the topic                |
| payer\_account\_id        | VARCHAR           | Account ID of the account that paid for the message submission |
| message\_base64           | VARCHAR           | Message content encoded in base64                              |
| message                   | VARCHAR           | Decoded message content                                        |
| chunk\_info               | VARIANT           | Information about message chunks if the message was split      |
| running\_hash             | VARCHAR           | Running hash of all messages in the topic up to this message   |
| running\_hash\_version    | BIGINT            | Version of the running hash algorithm                          |
| message\_id               | VARCHAR           | Unique identifier for the message                              |
| consensus\_timestamp\_raw | DECIMAL(29,9)     | Raw consensus timestamp as decimal                             |
| block\_number             | BIGINT            | Block number containing this message                           |
| block\_hash               | VARCHAR           | Hash of the block containing this message                      |
| transaction\_hash         | VARCHAR           | Hash of the transaction that submitted this message            |
| transaction\_id           | VARCHAR           | Unique identifier for the transaction                          |
| transaction\_nonce        | BIGINT            | Nonce of the transaction                                       |
| transaction\_result       | VARCHAR           | Result of the transaction                                      |
| \_created\_at             | TIMESTAMP\_NTZ(9) | Timestamp when this record was created                         |
| \_updated\_at             | TIMESTAMP\_NTZ(9) | Timestamp when this record was last updated                    |