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
  2. State tables

Witnesses

The Witnesses table is a non-transactional table that contains a list of all witnesses and related information. The table content is updated every witness round (i.e. every 63 seconds as there are 21 witnesses producing a block every 3 seconds in each round)

Columns

Name

Description

name

Account name of the witness

votes_count

Number of votes the witness received

url

The URL of the witness presentation post

votes

Total amount of VEST from voters

total_missed

Number of blocks missed

last_aslot

This value indicates when the witness was last scheduled for block production

last_confirmed_block_num

Block number of the last block signed by the witness

signing_key

Current signing key use by the Witness. A value of STM1111111111111111111111111111111114T1Anm means the witness has been deactivated and will no more be scheduled for block production

account_creation_fee

Proposed cost for the creation of a new account

account_creation_fee_symbol

HIVE

maximum_block_size

Proposed maximum block size. The greater, the more information and transactions the blockchain can store in each block

hbd_interest_rate

Proposed interest rate to reward users holding HBD

hbd_exchange_rate_base

Proposed cost in HBD to buy 1 HIVE

hbd_exchange_rate_base_symbol

HBD

hbd_exchange_rate_quote

Proposed value for the ratio between HBD and HIVE for rewards

hbd_exchange_rate_quote_symbol

HIVE

last_hbd_exchange_update

Last time the witness updated its price feed

running_version

Current version of the witness node

hardfork_version_vote

Current version of the hardfork supported by the witness

hardfork_time_vote

Time of vote from the witness for the latest supported hardfork

PreviousTagsNextFull Text Search

Last updated 2 years ago