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