The latest version of the Programmer’s Guide in the Module SDK (7.5.2) has a section describing the tables, as well as the historical tables.
I don’t believe it describes the indexes, however. For the write queue, only the t_stamp column needs an index.
Regards,