Skip to main content

Table Details

PropertyValue
Table Namecardano.raw.inputs
Table StatusProduction-Ready
Unique Keyinput_id
Clustering Key(s)to_date("block_timestamp")
Search Optimizationspent_utxo_id, transaction_hash, spent_transaction_hash

Table Columns

Column NameData TypeDescription
addressVARCHAR(16777216)The Cardano address that owned the UTXO being spent.
amountVARIANTThe value of the UTXO being spent, including ada and any native tokens.
spent_transaction_hashVARCHAR(16777216)The hash of the transaction that originally created the UTXO being spent.
spent_output_indexNUMBER(38,0)The output index within the original transaction that created the UTXO being spent.
spent_utxo_idVARCHAR(16777216)Unique identifier of the UTXO being consumed, formatted as transaction_hash#output_index.
collateralBOOLEANWhether this input is designated as collateral to cover fees if Plutus script validation fails.
data_hashVARCHAR(16777216)The BLAKE2b-256 hash of the datum (script data) attached to the UTXO, used for Plutus script validation.
inline_datumVARCHAR(16777216)The datum stored directly in the UTXO (CIP-32), eliminating the need to provide it separately when spending.
referenceBOOLEANWhether this is a reference input (CIP-31) that is read by scripts without being consumed.
reference_script_hashVARCHAR(16777216)The hash of a Plutus script stored in the UTXO as a reference script (CIP-33), usable without including it in transaction witnesses.
input_indexNUMBER(38,0)The position of this input within the spending transaction.
input_idVARCHAR(16777216)Unique identifier for this input record.
transaction_hashVARCHAR(16777216)The hash of the transaction that is spending this UTXO.
transaction_indexNUMBER(38,0)The position of the spending transaction within its block.
block_heightNUMBER(38,0)The block number (height) of the block containing the spending transaction.
block_hashVARCHAR(16777216)The hash of the block containing the spending transaction.
block_timestampTIMESTAMP_NTZ(9)The time when the block containing the spending transaction was produced.
block_epochNUMBER(38,0)The epoch number of the block containing the spending transaction.
block_epoch_slotNUMBER(38,0)The slot position within the epoch of the block containing the spending transaction.
_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.