Table Details
| Property | Value |
|---|---|
| Table Name | scroll.agents.erc8004_events |
| Table Status | Beta 🌱 |
| Unique Key | transaction_hash, log_index |
| Clustering Key(s) | block_timestamp::date, event_name |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| event_name | VARCHAR(16777216) | Name of the ERC-8004 registry event emitted (e.g. registration, update, or deregistration of an agent). |
| agent_id | VARCHAR(16777216) | Unique identifier of the agent registered in an ERC-8004 agent registry contract. |
| registry_type | VARCHAR(16777216) | Type of agent registry (e.g. service, tool). Determines the registration schema and event structure. |
| registry_address | VARCHAR(42) | Contract address of the registry that recorded this agent registration or event. |
| registry_name | VARCHAR(16777216) | Human-readable name of the registry contract, if known. |
| is_official | BOOLEAN | True if this agent or registry entry is verified as an official Allium-recognized entity. |
| extra_fields | VARIANT | JSON object containing additional fields from the onchain event that are not part of the standard schema (e.g. nonce, fee metadata, protocol-specific parameters). |
| transaction_hash | VARCHAR(66) | Hash of the transaction that produced this record. Uniquely identifies a transaction within the blockchain. |
| log_index | NUMBER(38,0) | Zero-based position of this event log within its transaction. The first log emitted by a transaction has index 0. |
| block_timestamp | TIMESTAMP_NTZ(9) | Timestamp (UTC) of the block that contains this record. |
| block_number | NUMBER(38,0) | Sequential number of the block that contains this record. Starts at 0 (genesis block) and increments by 1 for each new block. |
| block_hash | VARCHAR(66) | Cryptographic hash of the block header that contains this record. Uniquely identifies a block. |
| transaction_from_address | VARCHAR(42) | Address of the externally-owned account (EOA) that signed and submitted the transaction. This is the wallet that paid gas. |
| transaction_to_address | VARCHAR(42) | Address the transaction was sent to (the top-level to field of the transaction), typically the registry contract. |
| unique_id | VARCHAR(32) | Allium’s deterministic unique identifier for this row. Generated from the fields that uniquely identify the record (e.g. transaction hash + log index). Stable across full refreshes. |
| chain | VARCHAR(16777216) | Slug identifying the blockchain this record belongs to. |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was created in the database. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was last updated in the database. |
Related Docs
Overview: See ERC-8004 for schema context and sample queries.