> ## 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: `transaction_hash`, `log_index`

| Column Name        | Data Type         | Description                                                                                          |
| ------------------ | ----------------- | ---------------------------------------------------------------------------------------------------- |
| transaction\_hash  | VARCHAR           | Unique identifier of the transaction that this log belongs to.                                       |
| transaction\_index | BIGINT            | The position of this transaction in the block that it belongs to. The first transaction has index 0. |
| log\_index         | BIGINT            | The position of this log in the block that it belongs to. The first log has index 0.                 |
| from\_address      | VARCHAR           | The address of the sending party of this transaction.                                                |
| to\_address        | VARCHAR           | The address of the receiving party of this transaction, typically a contract address for logs.       |
| address            | VARCHAR           | The address of the contract that emitted this log.                                                   |
| data               | VARCHAR           | Unindexed data containing further information of the event, encoded in hex.                          |
| topic0             | VARCHAR           | The keccak256 hash of a flattened event signature string.                                            |
| topic1             | VARCHAR           | First indexed topic of the event.                                                                    |
| topic2             | VARCHAR           | Second indexed topic of the event.                                                                   |
| topic3             | VARCHAR           | Third indexed topic of the event.                                                                    |
| block\_timestamp   | TIMESTAMP\_NTZ(9) | The time when the block that contains this log was included on the blockchain.                       |
| block\_number      | BIGINT            | The length of the chain, in blocks.                                                                  |
| block\_hash        | VARCHAR           | Unique identifier of the block that includes this log.                                               |
| \_created\_at      | TIMESTAMP\_NTZ(9) | Timestamp of the entry creation.                                                                     |
| \_updated\_at      | TIMESTAMP\_NTZ(9) | Timestamp of the entry update.                                                                       |