Each block recorded in the blockchain is processed by the database injector and split among several tables.
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.