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:
![](/api/v2/epubs/9781789804164/files/assets/8ef5bf92-7cbc-4b48-870c-23f3f806e63f.png)
Let's see each table and its columns.