> ## 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.

# Transactions

All transactions, starting from genesis.

### Table Details

| Property            | Value                        |
| ------------------- | ---------------------------- |
| Table Name          | `cardano.raw.transactions`   |
| Table Status        | Production-Ready             |
| Unique Key          | `hash`                       |
| Clustering Key(s)   | `to_date("block_timestamp")` |
| Search Optimization | `hash`                       |

### Table Columns

| Column Name                  | Data Type         | Description                                                                                                                   |
| ---------------------------- | ----------------- | ----------------------------------------------------------------------------------------------------------------------------- |
| 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.                                                                 |