HiveSQL
Search…
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àà
Last modified 4mo ago
Copy link