> ## 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          | `litecoin.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                                                                                            |
| ------------------------ | ----------------- | ------------------------------------------------------------------------------------------------------ |
| 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.                                              |
| \_created\_at            | TIMESTAMP\_NTZ(9) | Timestamp when this record was created in the database.                                                |
| \_updated\_at            | TIMESTAMP\_NTZ(9) | Timestamp when this record was last updated in the database.                                           |