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

# Registrations

### Table Details

| Property            | Value                                                           |
| ------------------- | --------------------------------------------------------------- |
| Table Name          | `ethereum.ens.registrations`                                    |
| Table Status        | Production-Ready                                                |
| Unique Key          | `registration_timestamp::date`, `transaction_hash`, `log_index` |
| Clustering Key(s)   | `registration_timestamp::date`                                  |
| Search Optimization | `owner_address`, `token_id`, `name`                             |

### Table Columns

| Column Name             | Data Type          | Description                                                                                                                                             |
| ----------------------- | ------------------ | ------------------------------------------------------------------------------------------------------------------------------------------------------- |
| name                    | VARCHAR(134217728) | Market display name.                                                                                                                                    |
| token\_id               | VARCHAR(134217728) | Identifier for non-fungible tokens (ERC-721) or semi-fungible tokens (ERC-1155). Each unique token\_id within a collection represents a distinct asset. |
| registration\_timestamp | TIMESTAMP\_NTZ(9)  | Timestamp (UTC) when the ENS name was registered onchain.                                                                                               |
| expiry\_timestamp       | TIMESTAMP\_NTZ(9)  | Timestamp (UTC) when the ENS name registration expires. After expiry the name can be registered by anyone.                                              |
| owner\_address          | VARCHAR(42)        | Address of the token or position owner. In NFT contexts, the wallet that holds the token; in staking contexts, the account that initiated the stake.    |
| eth\_cost               | VARCHAR(134217728) | Cost of the ENS registration or renewal in ETH.                                                                                                         |
| usd\_cost               | FLOAT              | USD value of the ENS registration or renewal cost at the time of the transaction.                                                                       |
| 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\_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.                                                          |
| \_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.                                                                                           |