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

# Outputs

### Table Details

| Property            | Value                                          |
| ------------------- | ---------------------------------------------- |
| Table Name          | `litecoin.raw.outputs`                         |
| Table Status        | Production-Ready                               |
| Unique Key          | `block_timestamp`, `transaction_hash`, `index` |
| Clustering Key(s)   | `to_date("block_timestamp")`                   |
| Search Optimization | `utxo_id`, `transaction_hash`                  |

### Table Columns

| Column Name          | Data Type         | Description                                                                            |
| -------------------- | ----------------- | -------------------------------------------------------------------------------------- |
| value                | NUMBER(38,0)      | The amount of LTC in litoshi (smallest unit) for this output.                          |
| script\_asm          | VARCHAR(16777216) | The script in assembly format that defines the conditions for spending this output.    |
| script\_hex          | VARCHAR(16777216) | The script in hexadecimal format that defines the conditions for spending this output. |
| required\_signatures | NUMBER(38,0)      | Number of signatures required to spend this output.                                    |
| type                 | VARCHAR(16777216) | The type of script used in this output.                                                |
| addresses            | ARRAY             | Array of addresses that can spend this output.                                         |
| address0             | VARCHAR(16777216) | The first address in the addresses array that can spend this output.                   |
| index                | NUMBER(38,0)      | The position of this output within its transaction.                                    |
| utxo\_id             | VARCHAR(16777216) | Unique identifier for this output, composed of transaction\_hash and index.            |
| transaction\_hash    | VARCHAR(66)       | Unique hash of the transaction that contains this output.                              |
| block\_hash          | VARCHAR(66)       | Hash of the block containing this output's transaction.                                |
| block\_number        | NUMBER(38,0)      | Number of the block containing this output's transaction.                              |
| block\_timestamp     | TIMESTAMP\_NTZ(9) | Timestamp when the block containing this output 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.                           |
| value\_str           | VARCHAR(16777216) | The amount of LTC in litoshi (smallest unit) for this output, as a string.             |
| value\_float         | FLOAT             | The amount of LTC for this output, normalized to LTC (one litoshi = 1e-8 LTC).         |