Skip to main content

Table Details

PropertyValue
Table Namecardano.raw.outputs
Table StatusProduction-Ready
Unique Keyutxo_id
Clustering Key(s)to_date("block_timestamp")
Search Optimizationutxo_id, transaction_hash

Table Columns

Column NameData TypeDescription
addressVARCHAR(16777216)The Cardano address receiving the output value.
amountVARIANTThe value of this output, including ada and any native tokens.
collateralBOOLEANWhether this output is designated as collateral return (change returned from collateral if Plutus script validation fails).
data_hashVARCHAR(16777216)The BLAKE2b-256 hash of the datum (script data) attached to this output, used for Plutus script validation.
inline_datumVARCHAR(16777216)The datum stored directly in this output (CIP-32), eliminating the need to provide it separately when spending.
reference_script_hashVARCHAR(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_indexNUMBER(38,0)The position of this output within its transaction.
utxo_idVARCHAR(16777216)Unique identifier for this UTXO, formatted as transaction_hash#output_index.
transaction_hashVARCHAR(16777216)The hash of the transaction that created this output.
transaction_indexNUMBER(38,0)The position of the transaction within its block.
block_heightNUMBER(38,0)The block number (height) of the block containing this output’s transaction.
block_hashVARCHAR(16777216)The hash of the block containing this output’s transaction.
block_timestampTIMESTAMP_NTZ(9)The time when the block containing this output’s transaction was produced.
block_epochNUMBER(38,0)The epoch number of the block containing this output’s transaction.
block_epoch_slotNUMBER(38,0)The slot position within the epoch of the block containing this output’s transaction.
_extra_fieldsVARIANTAny additional fields that are not explicitly defined.
_created_atTIMESTAMP_NTZ(9)Timestamp of when the entry was created in the database.
_updated_atTIMESTAMP_NTZ(9)Timestamp of when the entry was last updated in the database.