Table Details
| Property | Value |
|---|---|
| Table Name | x_layer.agents.erc8004_events |
| Table Status | Production-Ready |
| 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) | The name of the ERC-8004 event (e.g., AgentRegistered, AgentUpdated). |
| agent_id | VARCHAR(16777216) | The unique identifier of the agent in the ERC-8004 registry. |
| registry_type | VARCHAR(16777216) | The type of registry the agent is registered in (e.g., service, tool). |
| registry_address | VARCHAR(42) | The contract address of the agent registry. |
| registry_name | VARCHAR(16777216) | The display name of the agent registry. |
| is_official | BOOLEAN | Whether the registry is an officially recognized registry. |
| extra_fields | VARIANT | Additional event-specific fields stored as a semi-structured object. |
| transaction_hash | VARCHAR(66) | The hash of the transaction containing the event. |
| log_index | NUMBER(38,0) | The index of the event log within the transaction. |
| block_timestamp | TIMESTAMP_NTZ(9) | The timestamp of the block containing the event. |
| block_number | NUMBER(38,0) | The block number containing the event. |
| block_hash | VARCHAR(66) | The hash of the block containing the event. |
| transaction_from_address | VARCHAR(42) | The address that initiated the transaction. |
| transaction_to_address | VARCHAR(42) | The address the transaction was sent to. |
| unique_id | VARCHAR(32) | A unique identifier for this event record, derived from transaction_hash and log_index. |
| chain | VARCHAR(16777216) | The blockchain network identifier. |
| _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. |