HiveSQL
  • Introduction
  • Register your HiveSQL account
  • Support
  • Technical informations
    • Database Diagram
    • Operations
      • TxAccountClaims
      • TxAccountCreates
      • TxAccountRecoveryChanges
      • TxAccountRecoveryRequests
      • TxAccountRecoveryConfirms
      • TxAccountUpdates
      • TxAccountUpdates2
      • TxAccountWitnessProxies
      • TxAccountWitnessVotes
      • TxClaimRewardBalances
      • TxCollateralizedConverts
      • TxComments
      • TxCommentsOptions
      • TxConverts
      • TxCustoms
      • TxDeclineVotingRights
      • TxDelegateVestingShares
      • TxDeleteComments
      • TxEscrowApproves
      • TxEscrowDisputes
      • TxEscrowReleases
      • TxEscrowTransfers
      • TxFeeds
      • TxLimitOrdersCancels
      • TxLimitOrdersCreates
      • TxPows
      • TxProposalCreates
      • TxProposalRemoves
      • TxProposalUpdates
      • TxProposalVoteUpdates
      • TxRecurrentTransfers
      • TxTransfers
      • TxVotes
      • TxWithdraws
      • TxWithdrawVestingRoutes
      • TxWitnessSetProperties
      • TxWitnessUpdates
    • Virtual Operations
      • VOAccountCreateds
      • VOAuthorRewards
      • VOChangedRecoveryAccounts
      • VOClearNullAccountBalances
      • VOCollateralizedConvertImmediateConversions
      • VOCommentBenefactorRewards
      • VOCommentPayoutUpdates
      • VOCommentRewards
      • VOCommentsVotes
      • VOConsolidateTreasuryBalances
      • VOCurationRewards
      • VODelayedVotings
      • VODHFConversions
      • VODHFFundings
      • VOExpiredAccountNotifications
      • VOFailedRecurrentTransfers
      • VOFillCollateralizedConvertRequests
      • VOFillConvertRequests
      • VOFillOrders
      • VOFillRecurrentTransfers
      • VOFillTransferFromSavings
      • VOFillVestingWithdraws
      • VOHardforkHiveRestores
      • VOHardforkHives
      • VOHardforks
      • VOInterests
      • VOLimitOrderCancelleds
      • VOLiquidityRewards
      • VOPowRewards
      • VOProducerMisseds
      • VOProducerRewards
      • VOProposalFees
      • VOProposalPays
      • VOReturnVestingDelegations
      • VOShutdownWitnesses
      • VOSPSConverts
      • VOSPSFunds
      • VOTransferToVestingCompleteds
    • State tables
      • DynamicGlobalProperties
      • Accounts
      • Blacklists
      • BlacklistsFollows
      • Comments
      • Communities
      • CommunitiesRoles
      • CommunitiesSubscribers
      • Delegations
      • Followers
      • Mutes
      • MutesFollows
      • Proposals
      • ProposalsApprovals
      • RCDelegations
      • Reblogs
      • Tags
      • Witnesses
    • Full Text Search
    • Language detection
  • Tutorials
    • HiveSQL for Python developers
    • HiveSQL for PHP developers
    • HiveSQL for Ruby developers
    • HiveSQL for Microsoft Excel
  • HiveSQL Status
  • Resources
Powered by GitBook
On this page
  1. Technical informations

Virtual Operations

What are Virtual Operations?

Virtual operations are operations resulting from the activity on the blockchain but, unlike classic operations, they are not initiated by users.

Example:

  1. When a user publishes a post or comment, a comment operation is issued by the user or the front-end it uses. This operation will be stored in the blockchain and in the TxComments table in HiveSQL.

  2. If some users consider this post or comment worth it, they may upvote it. These upvotes are stored in the blockchain as vote operations and stored in the TxVotes table in HiveSQL.

  3. After 7 days, if the post or comment has received enough powerful upvotes, the user is awarded a payout for it and an author_reward virtual operation is recorded in the blockchain. The user did nothing to trigger it, the system did it automatically.

Table

Description

Creations of new accounts

Author rewards

Account Recovery changes

Zeroing of the @null account balance

Conversions from HIVE to HBD

Benefactor rewards

Posts and comments final payout computations

Comments rewards

Transfers from the old treasury account to the new one

Curation rewards

Power-ups who become effective for governance

Conversion of Ninja mined HIVE to DHF

DHF proposals payments

Notifications of governance expirations

Execution of conversion from HIVE to HBD

HBD to HIVE conversions

Internal Market orders filled

Execution of recuurent transfers

Execution of Transfers from savings

Execution of Powerdown

Post Hive hardfork airdrops

Hive hardfork airdrops

Blockchain hardforks

HBD interest payments

Limit order cancellations

Deprecated

Miner rewards

Producers rewards

Fees paid when creating proposals

Proposal payments

Execution of HP delegation removals

Deprecated

Conversions from HIVE to HBD for the DHF

DHF fundings

Transfers to vesting completion

PreviousTxWitnessUpdatesNextVOAccountCreateds

Last updated 2 years ago

VOAccountCreateds
VOAuthorRewards
VOChangedRecoveryAccounts
VOClearNullAccountBalances
VOCollateralizedConvertImmediateConversions
VOCommentBenefactorRewards
VOCommentPayoutUpdates
VOCommentRewards
VOConsolidateTreasuryBalances
VOCurationRewards
VODelayedVotings
VODHFConversions
VODHFFundings
VOExpiredAccountNotifications
VOFillCollateralizedConvertRequests
VOFillConvertRequests
VOFillOrders
VOFillRecurrentTransfers
VOFillTransferFromSavings
VOFillVestingWithdraws
VOHardforkHiveRestores
VOHardforkHives
VOHardforks
VOInterests
VOLimitOrderCancelleds
VOLiquidityRewards
VOPowRewards
VOProducerRewards
VOProposalFees
VOProposalPays
VOReturnVestingDelegations
VOShutdownWitnesses
VOSPSConverts
VOSPSFunds
VOTransferToVestingCompleteds