HiveSQL
Search…
CommunitiesRoles
Contains a real-time updated list of all accounts having a specific role or status within a community, whether administrators, moderators or even users who have been muted.
Attention: there is a trick with the last table given how communities work at the blockchain level: if a specific user is missing from the table, it is considered being a ”guest” because an account is only inserted in the table if it is explicitly assigned a role by an admin or moderator!

Columns

Name
Description
community
community account
account
account with a role within the community
role
account role within the community
title
text describing the account role
Last modified 4mo ago
Copy link