# 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                        | <p>a JSON array of objects with the following properties:</p><ul><li>date and time that the additional HP recently powered up will be taken into account for governance</li><li>value of the additional HP that will be taken into account for governance after the delay</li></ul> |
| open\_recurrent\_transfers            | Number of recurring transfers scheduled for execution                                                                                                                                                                                                                               |

**Notes:**

{% hint style="info" %}
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.
{% endhint %}

Read [this post](https://peakd.com/hive-167922/@themarkymark/finding-out-how-does-hbd-interest-work-by-reviewing-code) by @themarkymark to learn what `hbd_seconds`and `hbd_seconds_last_update` are and how they are used to compute interests.