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.