> ## 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          | `cardano.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                                                                                                                          |
| ----------------------- | ----------------- | ------------------------------------------------------------------------------------------------------------------------------------ |
| address                 | VARCHAR(16777216) | The Cardano address receiving the output value.                                                                                      |
| amount                  | VARIANT           | The value of this output, including ada and any native tokens.                                                                       |
| collateral              | BOOLEAN           | Whether this output is designated as collateral return (change returned from collateral if Plutus script validation fails).          |
| data\_hash              | VARCHAR(16777216) | The BLAKE2b-256 hash of the datum (script data) attached to this output, used for Plutus script validation.                          |
| inline\_datum           | VARCHAR(16777216) | The datum stored directly in this output (CIP-32), eliminating the need to provide it separately when spending.                      |
| reference\_script\_hash | VARCHAR(16777216) | The hash of a Plutus script stored in this output as a reference script (CIP-33), usable by other transactions without including it. |
| output\_index           | NUMBER(38,0)      | The position of this output within its transaction.                                                                                  |
| utxo\_id                | VARCHAR(16777216) | Unique identifier for this UTXO, formatted as transaction\_hash#output\_index.                                                       |
| transaction\_hash       | VARCHAR(16777216) | The hash of the transaction that created this output.                                                                                |
| transaction\_index      | NUMBER(38,0)      | The position of the transaction within its block.                                                                                    |
| block\_height           | NUMBER(38,0)      | The block number (height) of the block containing this output's transaction.                                                         |
| block\_hash             | VARCHAR(16777216) | The hash of the block containing this output's transaction.                                                                          |
| block\_timestamp        | TIMESTAMP\_NTZ(9) | The time when the block containing this output's transaction was produced.                                                           |
| block\_epoch            | NUMBER(38,0)      | The epoch number of the block containing this output's transaction.                                                                  |
| block\_epoch\_slot      | NUMBER(38,0)      | The slot position within the epoch of the block containing this output's transaction.                                                |
| \_extra\_fields         | VARIANT           | Any additional fields that are not explicitly defined.                                                                               |
| \_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.                                                                        |