Sort:  

Thanks. Yes, there is a hive_state table stores the dynamic global properties. I will add with the next iteration.

fantastic. Where can I find a full list of tables or structure of the data?

Here is an ER diagram for the current database structure.

Full resolution

brilliant, thank you