You can look into mod/feedback/db/install.xml for the structure.
I am starting to get familiar with it in order to create a module that can satisfy the course evaluation requirements of the university that I work for.
Attached is a simple ERD that I drew based on the install.xml file