> ## 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          | `bitcoin_cash.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)      | Value in sats (unnormalized). One sat = 1e-8 BCH.                       |
| script\_asm          | VARCHAR(16777216) | Symbolic representation of the script language op-codes.                |
| script\_hex          | VARCHAR(16777216) | Hexadecimal representation of the script language op-codes.             |
| required\_signatures | NUMBER(38,0)      | Required signatures.                                                    |
| type                 | VARCHAR(16777216) | The address type of the output.                                         |
| addresses            | ARRAY             | Addresses used in the transaction output.                               |
| address0             | VARCHAR(16777216) | Index 0 of the addresses.                                               |
| index                | NUMBER(38,0)      | The index of the output.                                                |
| utxo\_id             | VARCHAR(16777216) | UTXO ID generated from transaction hash and index.                      |
| transaction\_hash    | VARCHAR(66)       | Unique hash of the transaction containing the output.                   |
| block\_hash          | VARCHAR(66)       | Block hash of the transaction output.                                   |
| block\_number        | NUMBER(38,0)      | Block number or block height of the transaction output.                 |
| block\_timestamp     | TIMESTAMP\_NTZ(9) | Block timestamp of the transaction output.                              |
| \_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.           |
| value\_str           | VARCHAR(16777216) | String of the output value in sats (unnormalized). One sat = 1e-8 BCH.  |
| value\_float         | FLOAT             | The output value as a float in sats (unnormalized). One sat = 1e-8 BCH. |