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 HBD

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)

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àà