When the rich history database is configured on a channel, three tables will be created in the database for the channel: history, state, and latest height. To create analytic reports, the history and state tables will be queried:
Rich history tables
Let's see each table and its columns.