Transactionnal data
Blocks
The Blocks table contains bare block information (timestamp, witness …)
Transactions
Each block can contains Transactions
Depending on each transaction type, the associated transaction’s data is stored in the related table (Tx…).
Virtual Operations
Virtual operations are operations resulting from the activity of the blockchain but, unlike transactions, they are not initiated by users.
More information about virtual operations tables (VO…) can be found here
Non-transactionnal data
DynamicGlobalProperties
This table contains the data returned by the get_dynamic_global_properties
API. This API call is used to get the state of the Hive blockchain and its global parameters.
Accounts
The Accounts table is a non-transactional table and contains a list of all accounts and related information resulting from activity of accounts on the blockchain
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, …)
Followers
The Followers table is a non-transactional table which enables to find who is following who.
Reblogs
The Reblogs table is a non-transactional table that enables you to find who reblogged which post or comment.
Witnesses
The Witnesses table is a non-transactional table which contains a list of all witnesses and related information.