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

# Enriched Inputs

### Table Details

| Property            | Value                                           |
| ------------------- | ----------------------------------------------- |
| Table Name          | `dogecoin.raw.enriched_inputs`                  |
| Table Status        | Production-Ready                                |
| Unique Key          | `block_timestamp::date`, `input_id`             |
| Clustering Key(s)   | `block_timestamp::date, index`                  |
| Search Optimization | `spent_utxo_id`, `transaction_hash`, `address0` |

### Table Columns

| Column Name              | Data Type         | Description                                                                                            |
| ------------------------ | ----------------- | ------------------------------------------------------------------------------------------------------ |
| spent\_transaction\_hash | VARCHAR(66)       | Hash of the transaction that created the output being spent by this input.                             |
| spent\_output\_index     | NUMBER(38,0)      | The index of the output being spent within its transaction.                                            |
| script\_asm              | VARCHAR(16777216) | The script in assembly format that unlocks the spent output.                                           |
| script\_hex              | VARCHAR(16777216) | The script in hexadecimal format that unlocks the spent output.                                        |
| sequence                 | NUMBER(38,0)      | The sequence number of this input, used for relative time-locks.                                       |
| coinbase                 | VARCHAR(16777216) | For coinbase transactions, contains the coinbase data. NULL for non-coinbase inputs.                   |
| index                    | NUMBER(38,0)      | The position of this input within its transaction.                                                     |
| input\_id                | VARCHAR(16777216) | Unique identifier for this input, composed of transaction\_hash and index.                             |
| spent\_utxo\_id          | VARCHAR(16777216) | Unique identifier for the spent output, composed of spent\_transaction\_hash and spent\_output\_index. |
| transaction\_hash        | VARCHAR(66)       | Unique hash of the transaction that contains this input.                                               |
| block\_hash              | VARCHAR(66)       | Hash of the block containing this input's transaction.                                                 |
| block\_number            | NUMBER(38,0)      | Number of the block containing this input's transaction.                                               |
| block\_timestamp         | TIMESTAMP\_NTZ(9) | Timestamp when the block containing this input was mined.                                              |
| addresses                | ARRAY             | Array of addresses associated with the spent output.                                                   |
| address0                 | VARIANT           | The first address from the addresses array.                                                            |
| value                    | NUMBER(38,0)      | The value of the spent output in satoshis.                                                             |
| \_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.                                          |