> ## 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          | `utxo_id`                     |
| 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 DOGE in satoshis (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.                           |