> ## 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 | `block_timestamp`, `transaction_hash`, `index` |
| 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. |