# Comments

The Comments table is a non-transactional table and contains all posts and comments and the related information resulting from activity related to posts on the blockchain (updates, votes, ...)

#### Columns

| Name                          | Description                                                                                                                                    |
| ----------------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------- |
| author                        | author of the post or comment                                                                                                                  |
| permlink                      | permlink of the post or comment                                                                                                                |
| category                      | first tag                                                                                                                                      |
| parent\_author                | parent post or comment author (comment only)                                                                                                   |
| parent\_permlink              | parent post or comment permlink (comment only)                                                                                                 |
| title                         | title (post only)                                                                                                                              |
| body                          | content of the post or comment                                                                                                                 |
| json\_metadata                | additional JSON information                                                                                                                    |
| last\_update                  | last update time                                                                                                                               |
| created                       | creation time                                                                                                                                  |
| active                        | the last time this post was "touched" by voting or reply                                                                                       |
| last\_payout                  | last payout time                                                                                                                               |
| depth                         | depth in the comments tree. 0=root post                                                                                                        |
| children                      | number of sub comments                                                                                                                         |
| net\_rshares                  | sum of rshares of all votes                                                                                                                    |
| abs\_rshares                  | sum of absolute rshares of all votes                                                                                                           |
| vote\_rshares                 | sum of all positive rshares from all votes                                                                                                     |
| cashout\_time                 | payout time for the post or comment                                                                                                            |
| max\_cashout\_time            |                                                                                                                                                |
| total\_vote\_weight           | total weight of voting rewards (used to calculate pro-rata share of curation payouts)                                                          |
| reward\_weight                | percentage of reward                                                                                                                           |
| total\_payout\_value          | total comment payout received over time, measured in HBD                                                                                       |
| curator\_payout\_value        | total curator payout received over time, measured in HBD                                                                                       |
| author\_rewards               | total author payout received over time, measured in VESTS                                                                                      |
| net\_votes                    | total of upvotes - downvotes                                                                                                                   |
| max\_accepted\_payout         | HBD value of the maximum payout this post will receive                                                                                         |
| percent\_hbd                  | percentage of HBD to pay, remaining amounts will be received as VESTS                                                                          |
| allow\_votes                  | allows a post to receive votes                                                                                                                 |
| allow\_curation\_rewards      | allows a post to generate curation rewards                                                                                                     |
| beneficiaries                 | JSON array of beneficiaries information (see [TxCommentsOptions](https://docs.hivesql.io/technical-informations/operations/txcommentsoptions)) |
| url                           | front-end relative URL                                                                                                                         |
| root\_title                   | title of the root post (comments only)                                                                                                         |
| pending\_payout\_value        | pending payout value (in HBD)                                                                                                                  |
| total\_pending\_payout\_value | pending payout value including comments (in HBD)                                                                                               |
| active\_votes                 | JSON array with votes information                                                                                                              |
| promoted                      | amout spent for the post promotion (in HBD)                                                                                                    |
| body\_language                | JSON information about post language (posts only)                                                                                              |
| body\_length                  | post or comment length (in charactersàà                                                                                                        |