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

| Property | Value |
| - | - |
| Table Name | `worldchain.decoded.logs` |
| Table Status | Production-Ready |
| Unique Key | `block_timestamp`, `transaction_hash`, `log_index` |
| Clustering Key(s) | `to_date("block_timestamp"), "name"` |
| Search Optimization | `transaction_hash`, `address`, `topic0` |

### Table Columns

| Column Name | Data Type | Description |
| - | - | - |
| block\_number | NUMBER(38,0) | The length of the chain, in blocks. |
| block\_timestamp | TIMESTAMP\_NTZ(9) | The time when the block was included on the blockchain. |
| block\_hash | VARCHAR(66) | Unique identifier of the block that includes this log. |
| address | VARCHAR(42) | The address of the contract that emitted this log. |
| name | VARCHAR(16777216) | Decoded event log name. |
| params | VARIANT | Decoded parameters in JSON format. |
| data | VARCHAR(16777216) | Unindexed data with further event info, encoded in hex. |
| topic0 | VARCHAR(66) | The keccak256 hash of a flattened event signature string. |
| topic1 | VARCHAR(66) | First indexed topic of the event. |
| topic2 | VARCHAR(66) | Second indexed topic of the event. |
| topic3 | VARCHAR(66) | Third indexed topic of the event. |
| transaction\_from\_address | VARCHAR(42) | The address of the sending party of this transaction. |
| transaction\_to\_address | VARCHAR(42) | The address of the receiving party of this transaction. |
| transaction\_hash | VARCHAR(66) | Unique identifier of the transaction that contains this log. |
| transaction\_index | NUMBER(38,0) | The position of this transaction in the block. First transaction has index 0. |
| log\_index | NUMBER(38,0) | The position of this log in the block. First log has index 0. |
| signature | VARCHAR(16777216) | Event log signature. |
| params\_keys\_mapping | ARRAY | Mapping of parameter keys in decoding. |
| interface\_id | VARCHAR(16777216) | Interface ID. |
| \_created\_at | TIMESTAMP\_NTZ(9) | Timestamp of the entry creation. |
| \_updated\_at | TIMESTAMP\_NTZ(9) | Timestamp of the entry update. |

### Related Docs

* [EVM Decoded Logs](/historical-data/supported-blockchains/evm/core-schemas/decoded/logs)
