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

# Logs

### Table Columns

Unique Key:

| Column Name               | Data Type         | Description                                                   |
| ------------------------- | ----------------- | ------------------------------------------------------------- |
| consensus\_timestamp      | TIMESTAMP\_NTZ(9) | The consensus timestamp when the log was generated            |
| transaction\_id           | VARCHAR           | Unique identifier for the transaction that generated this log |
| transaction\_nonce        | BIGINT            | Nonce of the transaction                                      |
| log\_index                | BIGINT            | Index of the log within the transaction                       |
| payer\_account\_id        | VARCHAR           | Account ID of the account that paid for the transaction       |
| address                   | VARCHAR           | Contract address that generated the log                       |
| contract\_id              | VARCHAR           | Contract ID that generated the log                            |
| data                      | VARCHAR           | Log data (hex encoded)                                        |
| topic0                    | VARCHAR           | First topic (event signature)                                 |
| topic1                    | VARCHAR           | Second topic (first indexed parameter)                        |
| topic2                    | VARCHAR           | Third topic (second indexed parameter)                        |
| topic3                    | VARCHAR           | Fourth topic (third indexed parameter)                        |
| bloom                     | VARCHAR           | Bloom filter for the log                                      |
| consensus\_timestamp\_raw | DECIMAL(29,9)     | Raw consensus timestamp as decimal                            |
| block\_number             | BIGINT            | Block number containing this log                              |
| block\_hash               | VARCHAR           | Hash of the block containing this log                         |
| transaction\_index        | BIGINT            | Index of the transaction within the block                     |
| transaction\_result       | VARCHAR           | Result of the transaction                                     |
| extra\_evm\_fields        | VARIANT           | Additional EVM-specific fields                                |
| \_created\_at             | TIMESTAMP\_NTZ(9) | Timestamp when this record was created                        |
| \_updated\_at             | TIMESTAMP\_NTZ(9) | Timestamp when this record was last updated                   |