Operations

All operation tables contain the following columns:

Column

Description

ID

This is an HiveSQL internal row identifier

tx_id

This is the ID of the transaction in the Transactions table

timestamp

This is the date and time of the block in which the operation was recorded

Additional columns are described on each table related page

Table

Description

TxAccountClaims

Claims of account creation tickets

TxAccountCreates

New account creations

TxAccountRecoveryChanges

Recovery Account changes

TxAccountRecoveryRequests

Account recovery requests

TxAccountRecoveryConfirms

Account recovery confirmations

TxAccountUpdates

Updates of account data

TxAccountUpdates2

Updates of account data (v2)

TxAccountWitnessProxies

Delegations of governance votes

TxAccountWitnessVotes

Votes/unvotes for witnesses

TxClaimRewardBalances

Claims for rewards

TxComments

Posts and comments

TxCommentsOptions

Posts and comments options

TxConverts

Requests for conversion from HBD to HIVE

TxCustoms

Custom JSON (non-consensus operations)

TxDeclineVotingRights

Requests to decline voting rights

TxDelegateVestingShares

Hive Power delegations

TxDeleteComments

Posts and comments deletions

TxEscrowApproves

Escrow approvals

TxEscrowDisputes

Escrow disputes

TxEscrowReleases

Escrow funds releases

TxEscrowTransfers

Escrow creations

TxFeeds

Witnesses price feed publications

TxLimitOrdersCreates

Internal market orders creations

TxLimitOrdersCancels

Internal market orders deletions

TxPows

Proof of Work (mining - deprecated)

TxProposalCreates

Proposals creations

TxProposalRemoves

Proposals removals

TxProposalUpdates

Proposal updates

TxProposalVoteUpdates

Proposal approvals and disapprovals

TxTransfers

Assets transfers

TxVotes

Posts and comments votes

TxWithdraws

Requests for Hive Power withdrawals (powerdown)

TxWithdrawVestingRoutes

Routes for powerdown definitions

TxWitnessSetProperties

Blockchain properties proposals by witnesses

TxWitnessUpdates

Witnesses information updates