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

# Inputs

### Table Details

| Property            | Value                                                         |
| ------------------- | ------------------------------------------------------------- |
| Table Name          | `cardano.raw.inputs`                                          |
| Table Status        | Production-Ready                                              |
| Unique Key          | `input_id`                                                    |
| Clustering Key(s)   | `to_date("block_timestamp")`                                  |
| Search Optimization | `spent_utxo_id`, `transaction_hash`, `spent_transaction_hash` |

### Table Columns

| Column Name              | Data Type         | Description                                                                                                                          |
| ------------------------ | ----------------- | ------------------------------------------------------------------------------------------------------------------------------------ |
| address                  | VARCHAR(16777216) | The Cardano address that owned the UTXO being spent.                                                                                 |
| amount                   | VARIANT           | The value of the UTXO being spent, including ada and any native tokens.                                                              |
| spent\_transaction\_hash | VARCHAR(16777216) | The hash of the transaction that originally created the UTXO being spent.                                                            |
| spent\_output\_index     | NUMBER(38,0)      | The output index within the original transaction that created the UTXO being spent.                                                  |
| spent\_utxo\_id          | VARCHAR(16777216) | Unique identifier of the UTXO being consumed, formatted as transaction\_hash#output\_index.                                          |
| collateral               | BOOLEAN           | Whether this input is designated as collateral to cover fees if Plutus script validation fails.                                      |
| data\_hash               | VARCHAR(16777216) | The BLAKE2b-256 hash of the datum (script data) attached to the UTXO, used for Plutus script validation.                             |
| inline\_datum            | VARCHAR(16777216) | The datum stored directly in the UTXO (CIP-32), eliminating the need to provide it separately when spending.                         |
| reference                | BOOLEAN           | Whether this is a reference input (CIP-31) that is read by scripts without being consumed.                                           |
| reference\_script\_hash  | VARCHAR(16777216) | The hash of a Plutus script stored in the UTXO as a reference script (CIP-33), usable without including it in transaction witnesses. |
| input\_index             | NUMBER(38,0)      | The position of this input within the spending transaction.                                                                          |
| input\_id                | VARCHAR(16777216) | Unique identifier for this input record.                                                                                             |
| transaction\_hash        | VARCHAR(16777216) | The hash of the transaction that is spending this UTXO.                                                                              |
| transaction\_index       | NUMBER(38,0)      | The position of the spending transaction within its block.                                                                           |
| block\_height            | NUMBER(38,0)      | The block number (height) of the block containing the spending transaction.                                                          |
| block\_hash              | VARCHAR(16777216) | The hash of the block containing the spending transaction.                                                                           |
| block\_timestamp         | TIMESTAMP\_NTZ(9) | The time when the block containing the spending transaction was produced.                                                            |
| block\_epoch             | NUMBER(38,0)      | The epoch number of the block containing the spending transaction.                                                                   |
| block\_epoch\_slot       | NUMBER(38,0)      | The slot position within the epoch of the block containing the spending transaction.                                                 |
| \_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.                                                                        |