# Database Diagram

<figure><img src="/files/-Mc_znJ04qzWZ9-68IBZ" alt=""><figcaption></figcaption></figure>

#### Blocks and Transactions

Each block recorded in the blockchain is processed by the database injector and split among several tables.&#x20;

The Blocks table contains bare block information (timestamp, witness, …).\
Each block can contain one or more transactions (stored in the Transactions table) which in turn can contain several operations

**Operations (Transactional - User-generated)**

The Blocks table contains bare block information (timestamp, witness …)

Each block can contain one or more Transactions which in turn can contain several operations. Depending on each operation type, the associated data is stored in the related table (Tx...).

**Virtual Operations (Transactional - System generated)**

Virtual operations are operations resulting from the activity on the blockchain but, unlike standard operations, they are not the result of actions initiated by users.

#### State tables (non-transactionnal)

The database also contains several tables that reflect the result of the operations recorded in the blockchain. For example, the "Accounts" table contains all the user accounts that have been created as well as their wallet balance, and other information relating to each account.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.hivesql.io/technical-informations/database-diagram.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.