| hash | VARCHAR(16777216) | Unique identifier (BLAKE2b-256 hash) of the transaction. |
| transaction_index | NUMBER(38,0) | The position of this transaction within its block. |
| size | NUMBER(38,0) | The size of the transaction in bytes. |
| fees | NUMBER(38,0) | The transaction fee paid, in lovelace. |
| valid_contract | BOOLEAN | Whether all Plutus scripts in the transaction passed phase-2 validation. If false, only collateral is collected. |
| invalid_before | NUMBER(38,0) | The slot number before which the transaction cannot be included in a block (lower bound of the validity interval). |
| invalid_hereafter | NUMBER(38,0) | The slot number after which the transaction can no longer be included in a block (upper bound of the validity interval). |
| slot | NUMBER(38,0) | The absolute slot number in which the transaction was included. |
| block | VARCHAR(16777216) | The hash of the block containing this transaction. |
| block_height | NUMBER(38,0) | The block number (height) of the block containing this transaction. |
| block_hash | VARCHAR(16777216) | The hash of the block containing this transaction. |
| block_timestamp | TIMESTAMP_NTZ(9) | The time when the block containing this transaction was produced. |
| block_epoch | NUMBER(38,0) | The epoch number of the block containing this transaction. |
| block_epoch_slot | NUMBER(38,0) | The slot position within the epoch of the block containing this transaction. |
| input_count | NUMBER(38,0) | Number of transaction inputs (UTXOs being spent). |
| output_count | NUMBER(38,0) | Number of transaction outputs (new UTXOs being created). |
| utxo_count | NUMBER(38,0) | Total number of UTXOs involved in the transaction (inputs + outputs). |
| total_input_value | NUMBER(38,0) | Total value of all inputs in lovelace. |
| total_output_value | NUMBER(38,0) | Total value of all outputs in lovelace. |
| output_amount | VARIANT | Detailed breakdown of output amounts including ada and native tokens. |
| deposit | VARCHAR(16777216) | The net deposit change in lovelace for stake address registrations or pool registrations in this transaction. |
| asset_mint_or_burn_count | NUMBER(38,0) | Number of distinct native token policy IDs being minted or burned in this transaction. |
| delegation_count | NUMBER(38,0) | Number of stake delegation certificates in this transaction. |
| mir_cert_count | NUMBER(38,0) | Number of Move Instantaneous Rewards (MIR) certificates transferring ada from reserves or treasury. |
| pool_retire_count | NUMBER(38,0) | Number of pool retirement certificates scheduling stake pools for deregistration. |
| pool_update_count | NUMBER(38,0) | Number of pool registration or update certificates creating or modifying stake pools. |
| redeemer_count | NUMBER(38,0) | Number of redeemers providing arguments for Plutus script validation (covering spends, mints, certificates, and withdrawals). |
| stake_cert_count | NUMBER(38,0) | Number of stake-related certificates (registration, deregistration, or delegation of stake addresses). |
| withdrawal_count | NUMBER(38,0) | Number of reward withdrawals claiming accumulated staking rewards from stake addresses. |
| _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. |
