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

### Table Columns

| Column Name            | Data Type         | Description                                                                        |
| ---------------------- | ----------------- | ---------------------------------------------------------------------------------- |
| contract\_address      | VARCHAR(16777216) | The address of the contract that sent or received this message.                    |
| entry\_point\_selector | VARCHAR(16777216) | The selector of the entry point function associated with this message.             |
| from\_address          | VARCHAR(16777216) | The address that sent this message.                                                |
| to\_address            | VARCHAR(16777216) | The address that received this message.                                            |
| message\_hash          | VARCHAR(16777216) | Unique hash identifier for this message.                                           |
| message\_index         | NUMBER(38,0)      | The position of this message within the transaction that sent it.                  |
| message\_source        | VARCHAR(16777216) | The source of the message (e.g., 'L1', 'L2').                                      |
| nonce                  | NUMBER(38,0)      | The nonce associated with this message for ordering and uniqueness.                |
| payload                | VARIANT           | The data payload of the message.                                                   |
| type                   | VARCHAR(16777216) | The type of message (e.g., 'L1\_TO\_L2', 'L2\_TO\_L1').                            |
| execution\_status      | VARCHAR(16777216) | The execution status of the message (e.g., 'SUCCEEDED', 'REVERTED').               |
| finality\_status       | VARCHAR(16777216) | The finality status of the message (e.g., 'ACCEPTED\_ON\_L1', 'ACCEPTED\_ON\_L2'). |
| version                | NUMBER(38,0)      | The version of the message format.                                                 |
| block\_number          | NUMBER(38,0)      | The block number where this message was processed.                                 |
| block\_timestamp       | TIMESTAMP\_NTZ(9) | The timestamp of the block where this message was processed.                       |
| block\_hash            | VARCHAR(16777216) | The hash of the block where this message was processed.                            |
| transaction\_hash      | VARCHAR(16777216) | The hash of the transaction that sent this message.                                |
| transaction\_index     | NUMBER(38,0)      | The index of the transaction within its block.                                     |
| unique\_id             | VARCHAR(16777216) | Unique identifier for this message                                                 |
| \_created\_at          | TIMESTAMP\_NTZ(9) | Timestamp when the record was created.                                             |
| \_updated\_at          | TIMESTAMP\_NTZ(9) | Timestamp when the record was last updated.                                        |