HiveSQL
Search…
Accounts
The Accounts table is a non-transactional table and contains a list of all accounts and related information resulting from the activity of accounts on the blockchain.

Columns

Name
Description
id
blockchain internal identifier
name
account name
owner
owner authorities
active
active authorities
posting
posting authorities
memo_key
memo public key
json_metadata
account metatada (updated with active key)
posting_json_metadata
account metatada (updated with posting key)
proxy
account to which governance votes are proxied
last_owner_update
last time of owner authorities change
last_account_update
last time the account data have been updated
created
account creation time
mined
set to true if the account has been created through mining
recovery_account
recovery account
last_account_recovery
the last time the account has been recovered
post_count
total number of posts and comments published
voting_manabar_current_mana
current upvote mana
voting_manabar_last_update_time
last time the upvote mana has been updated
downvote_manabar_current_mana
current downvote mana
downvote_manabar_last_update_time
last time the downvote mana has been updated
voting_power
current voting power (integer value - must be divided by 100)
last_vote_time
last time account voted
balance
HIVE balance
balance_symbol
"HIVE"
savings_balance
HIVE savings balance
savings_balance_symbol
"HIVE'"
hbd_balance
HBD balance
hbd_balance_symbol
"HBD"
hbd_seconds
used to compute interest value
hbd_seconds_last_update
used to compute interest value
hbd_last_interest_payment
the last time interest has been paid
savings_hbd_balance
HBD saving balance
savings_hbd_balance_symbol
"HBD"
savings_hbd_seconds
used to compute interest value
savings_hbd_seconds_last_update
used to compute interest value
savings_hbd_last_interest_payment
the last time interest has been paid on savings
savings_withdraw_requests
number of pending savings withdrawal requests
reward_hbd_balance
claimable reward HBD balance
reward_hbd_balance_symbol
"HBD"
reward_hive_balance
claimable reward HIVE balance
reward_hive_balance_symbol
"HIVE"
reward_vesting_balance
claimable reward VESTS balance (HP)
reward_vesting_balance_symbol
"VESTS"
reward_vesting_hive
claimable reward VESTS balance converted into HIVE
reward_vesting_hive_symbol
"HIVE"
vesting_shares
amount of Hive Power
vesting_shares_symbol
VESTS
delegated_vesting_shares
amount of Hive Power delegated
delegated_vesting_shares_symbol
VESTS
received_vesting_shares
amount of Hive Power delegation received
received_vesting_shares_symbol
VESTS
vesting_withdraw_rate
amount HP to powered down by week
vesting_withdraw_rate_symbol
VESTS
next_vesting_withdrawal
next powerdown time
withdrawn
total amount powered down (in VESTS)
to_withdraw
current amount to power down (VESTS)
withdraw_routes
number of active withdrawal routes
curation_rewards
total curation reward (HP equivalent)
posting_rewards
total author reward (HP equivalent)
proxied_vsf_votes
use to compute the amount of HP proxied
witnesses_voted_for
an array of witnesses the account is voting for
last_post
last post or comment time
last_root_post
last post time
pending_claimed_accounts
number of account creation ticked collected
vesting_balance
amount of Hive Power delayed for voting
vesting_balance_symbol
VESTS
reputation
a big integer number that represents the reputation acquired over time.
reputation_ui
a human-readable value of the reputation
witness_votes
number of witnesses votes for
post_voting_power
Effective HP that are used for curation (vesting_shares - delegated_vesting_shares + received_vesting_shares)
post_voting_power_symbol
VESTS
pending_transfers
Pending transfers for escrow operations
governance_vote_expiration_ts
date and time that the account governance votes for witnesses and proposals will expire
delayed_votes_time
date and time that the additional HP recently powered up will be taken into account for governance
delayed_votes_val
value of the additional HP that will be taken into account for governance after the delay
open_recurrent_transfers
Number of recurring transfers scheduled for execution
Notes:
This table is not updated in real-time, i.e. each time an account is involved in an operation that may change its state. Therefore, there may be a slight difference in the information provided by the blockchain API.
Read this post by @themarkymark to learn what hbd_secondsand hbd_seconds_last_update are and how they are used to compute interests.
Last modified 3mo ago
Copy link