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 | a JSON array of objects with the following properties:
|
open_recurrent_transfers | Number of recurring transfers scheduled for execution |
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.
Last updated