> ## Documentation Index
> Fetch the complete documentation index at: https://docs.dune.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Transactions

> Midnight blockchain transactions data

export const TableSample = ({tableName, tableSchema}) => <>
    <div className="hidden dark:block">
      <iframe src={`https://dune.com/embeds/3419983/5785629?table_schema_t6f0df=${tableSchema}&table_name_t6f0df=${tableName}&darkMode=true`} style={{
  width: '100%',
  height: '500px',
  border: 'none',
  marginTop: '10px'
}} />
    </div>
    <div className="dark:hidden">
      <iframe src={`https://dune.com/embeds/3419983/5785629?table_schema_t6f0df=${tableSchema}&table_name_t6f0df=${tableName}`} style={{
  width: '100%',
  height: '500px',
  border: 'none',
  marginTop: '10px'
}} />
    </div>
  </>;

# Table Description

This table contains transaction-level records on Midnight, including the parent block, transaction variant, hash, and protocol version.

## Column Descriptions

| Column Name           | Data Type | Description                                        |
| --------------------- | --------- | -------------------------------------------------- |
| **id**                | bigint    | Internal transaction identifier.                   |
| **block\_id**         | bigint    | Foreign key to `midnight.blocks.id`.               |
| **variant**           | varchar   | Transaction variant / type.                        |
| **hash**              | varchar   | Transaction hash.                                  |
| **protocol\_version** | bigint    | Protocol version for the transaction.              |
| **\_updated\_at**     | timestamp | Timestamp when this record was last updated.       |
| **\_ingested\_at**    | timestamp | Timestamp when this record was ingested into Dune. |

## Table Sample

<TableSample tableSchema="midnight" tableName="transactions" />