Logs
The basegoerli.logs table provides indexed views of all emitted logs.
Columns
| Name | Type | Description |
|---|---|---|
| address | text |
The address of the smart contract that emitted the log. |
| block_number | integer |
The block number the parent transaction was included in. |
| data | text |
The data of the log (bytes data as a hex string). |
| log_index | integer |
The index of the log in the block. |
| timestamp | timestamp |
The log's timestamp (in ISO-8601 format). |
| topic_0 | text |
The first log topic. |
| topic_1 | text |
The second log topic. |
| topic_2 | text |
The third log topic. |
| topic_3 | text |
The fourth log topic. |
| transaction_hash | text |
The parent transaction's hash. |
| transaction_position | integer |
The position of the parent transaction in the block. |
| __confirmed | boolean |
Flag indicating whether the log has been confirmed. |
Indexes
| Index |
|---|
| transaction_hash, log_index |
| __confirmed WHERE __confirmed = false |
| address, topic_0, block_number, log_index |
| address, block_number, log_index |
| block_number, log_index |
| topic_0, block_number, log_index |
Got questions? Join our Discord
Discord is the primary home of the Transpose developer community. Join us to ask questions, share your work, and get help.