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
Notes:
This table is not updated in real-time when an operation involving an account requires its state to be updated. 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.
Copy link
Contents