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
Copy link
Contents