Table Description
Contains transaction-level data for the Cardano blockchain. Each row represents a single transaction and includes fee information, validity status, input/output counts, and references to collateral and script data.Column Descriptions
| Column | Description | Type |
|---|---|---|
| tx_hash | The hash uniquely identifying the transaction. | varchar |
| block_hash | The hash of the block containing this transaction. | varchar |
| block_number | The sequential number of the block containing this transaction. | bigint |
| slot | The absolute slot number of the block containing this transaction. | bigint |
| epoch | The epoch number in which the transaction was included. | integer |
| block_time | The timestamp of the block containing this transaction. | timestamp |
| tx_index | The index position of the transaction within the block. | integer |
| fee_lovelace | The fee paid for the transaction, in lovelace. | bigint |
| is_invalid | Whether the transaction failed phase-2 validation (script execution). | boolean |
| script_data_hash | The hash of the script-related data (datums and redeemers) included in the transaction. | varchar |
| total_collateral_lovelace | The total collateral provided for script execution, in lovelace. | bigint |
| treasury_donation_lovelace | The amount donated to the Cardano treasury, in lovelace. | bigint |
| inputs | JSON array of transaction inputs (UTXOs consumed). | varchar |
| outputs | JSON array of transaction outputs (UTXOs created). | varchar |
| reference_inputs | JSON array of reference inputs used for read-only access to UTXOs. | varchar |
| collateral_inputs | JSON array of collateral inputs used in case of script failure. | varchar |
| input_count | The number of inputs consumed by the transaction. | bigint |
| output_count | The number of outputs produced by the transaction. | bigint |
| _updated_at | The time when this record was last updated. | timestamp |
| _ingested_at | The time when this record was ingested into Dune. | timestamp |