> ## 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        | `filecoin.raw.messages`                            |
| Table Status      | Beta 🌱                                            |
| Unique Key        | `tipset_timestamp`, `tipset_height`, `message_cid` |
| Clustering Key(s) | `to_date("tipset_timestamp")`                      |

### Table Columns

| Column Name                    | Data Type         | Description                                                                                                                                                                                |
| ------------------------------ | ----------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| tipset\_height                 | NUMBER(38,0)      | Filecoin tipset height (block height). A tipset is a set of blocks at the same height that form the canonical chain.                                                                       |
| tipset\_timestamp              | TIMESTAMP\_NTZ(9) | Timestamp (UTC) of the Filecoin tipset.                                                                                                                                                    |
| message\_cid                   | VARCHAR(16777216) | The CID of the message containing the transfer.                                                                                                                                            |
| message\_tipset\_index         | NUMBER(38,0)      | Position of this message within its tipset's ordered message list                                                                                                                          |
| replaced\_message\_cid         | VARCHAR(16777216) | CID of the message this transaction replaced (for fee-bumped or replaced pending messages)                                                                                                 |
| from\_address                  | VARCHAR(16777216) | Address that initiated or sent from in this event. For token transfers, the account whose balance decreased. For transactions, the transaction sender (msg.sender).                        |
| to\_address                    | VARCHAR(16777216) | Address that received in this event. For token transfers, the account whose balance increased. For transactions, the destination address (may be a smart contract).                        |
| method                         | NUMBER(38,0)      | Human-readable name of the Filecoin actor method called by this message (alias for method\_name)                                                                                           |
| nonce                          | NUMBER(38,0)      | Number of transactions sent from the sender's address prior to this one. Used to prevent replay attacks and ensure transaction ordering.                                                   |
| params                         | VARCHAR(16777216) | Raw parameters from the event                                                                                                                                                              |
| value                          | VARCHAR(16777216) | Amount of native currency (e.g. ETH, MATIC) transferred with this transaction or trace, in the chain's smallest unit (Wei for EVM chains). Zero for calls that don't move native currency. |
| version                        | NUMBER(38,0)      | The version of the block.                                                                                                                                                                  |
| duration                       | NUMBER(38,0)      | Duration of the storage deal in Filecoin epochs                                                                                                                                            |
| error                          | VARCHAR(16777216) | Human-readable error message if this trace or transaction reverted (e.g. `Out of gas`, `Reverted`, `Bad instruction`). Null for successful executions.                                     |
| receipt\_events\_root          | VARIANT           | CID of the AMT containing all actor events emitted during this message's execution                                                                                                         |
| receipt\_exit\_code            | NUMBER(38,0)      | Exit code from the message receipt (0 = success, non-zero = failure with specific error type)                                                                                              |
| receipt\_return                | VARCHAR(16777216) | Base64-encoded return value from the message receipt                                                                                                                                       |
| base\_fee                      | VARCHAR(16777216) | Base fee per gas for this block, in the chain's smallest fee denomination.                                                                                                                 |
| gas\_limit                     | VARCHAR(16777216) | Maximum gas units allocated for the block. Transactions in a block cannot collectively exceed this limit.                                                                                  |
| gas\_premium                   | VARCHAR(16777216) | Priority fee per gas unit to incentivize miners to include this message (attoFIL)                                                                                                          |
| gas\_fee\_cap                  | VARCHAR(16777216) | Maximum fee per gas unit the sender is willing to pay (attoFIL)                                                                                                                            |
| gas\_used                      | VARCHAR(16777216) | Actual number of gas units consumed by this transaction or trace.                                                                                                                          |
| gas\_total\_cost               | VARCHAR(16777216) | Total FIL cost of this message execution including base fee burn, miner tip, and overestimation burn (attoFIL)                                                                             |
| gas\_miner\_tip                | VARCHAR(16777216) | Tip paid to the block miner per gas unit (attoFIL)                                                                                                                                         |
| gas\_base\_fee\_burn           | VARCHAR(16777216) | Amount of FIL burned as base fee for this message execution                                                                                                                                |
| gas\_overestimation\_burn      | VARCHAR(16777216) | Amount of FIL burned due to gas limit overestimation                                                                                                                                       |
| gas\_refund                    | VARCHAR(16777216) | Amount of gas refunded to the sender after execution due to unused gas or refundable operations                                                                                            |
| miner\_penalty                 | VARCHAR(16777216) | FIL penalty charged to the miner for consensus faults or other violations (attoFIL)                                                                                                        |
| message\_cid\_raw              | VARIANT           | Raw bytes of the message CID                                                                                                                                                               |
| blocks                         | VARIANT           | Array of block headers included in this tipset                                                                                                                                             |
| block\_count                   | NUMBER(38,0)      | Number of blocks in this Filecoin tipset                                                                                                                                                   |
| event\_count                   | NUMBER(38,0)      | Number of events emitted by this transaction, block, or receipt.                                                                                                                           |
| event\_attribute\_count        | NUMBER(38,0)      | Number of key-value attributes attached to all events in this transaction.                                                                                                                 |
| trace\_count                   | NUMBER(38,0)      | Number of execution trace entries for this Filecoin message                                                                                                                                |
| \_created\_at                  | TIMESTAMP\_NTZ(9) | Timestamp of when the entry was created in the database.                                                                                                                                   |
| \_updated\_at                  | TIMESTAMP\_NTZ(9) | Timestamp of when the entry was last updated in the database.                                                                                                                              |
| native\_token\_transfer\_count | NUMBER(38,0)      | The total number of native token transfers. This includes transfers of gas paid to miners and gas burned (for Ethereum) and L1/L2 fees (for EVM L2s).                                      |
| deal\_proposal\_count          | NUMBER(38,0)      | Number of deal proposals included in this block                                                                                                                                            |
| sector\_event\_count           | NUMBER(38,0)      | Number of sector lifecycle events (prove, expire, fault, etc.) recorded in this block                                                                                                      |
