> ## 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 | `aleph_zero.raw.logs` |
| Table Status | Deprecated ◽ |
| Unique Key | `block_timestamp`, `transaction_hash`, `log_index` |
| Clustering Key(s) | `to_date("block_timestamp")` |
| Search Optimization | `transaction_hash`, `block_number`, `topic0`, `address` |

### Table Columns

| Column Name | Data Type | Description |
| - | - | - |
| transaction\_hash | VARCHAR(66) | Unique identifier of the transaction that this log belongs to. |
| transaction\_index | NUMBER(38,0) | The position of this transaction in the block that it belongs to. The first transaction has index 0. |
| log\_index | NUMBER(38,0) | The position of this log in the block that it belongs to. The first log has index 0. |
| from\_address | VARCHAR(42) | The address of the sending party of this transaction. |
| to\_address | VARCHAR(42) | The address of the receiving party of this transaction, typically a contract address for logs. |
| address | VARCHAR(42) | The address of the contract that emitted this log. |
| data | VARCHAR(16777216) | Unindexed data containing further information of the event, 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. |
| block\_timestamp | TIMESTAMP\_NTZ(9) | The time when the block that contains this log was included on the blockchain. |
| block\_number | NUMBER(38,0) | The length of the chain, in blocks. |
| block\_hash | VARCHAR(66) | 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. |

### Related Docs

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