I am trying to gain an overall understanding and location as to where everything is. I was given the list of tables here, but not all of these tables are currently used. I am having to select all from each table to get an idea as to what is stored. Would anyone happen to have an easy to read definition of each table?
Community Chosen Answer
Use a tool like MySQL Workbench to connect to the database with the reporting user. That will allow you to browse the tables and view their structure. The database doesn't use external keys, so it's not possible to create a schema with automated tools. In general, however, I have found it very easy to navigate and view the relationships between tables. For instance, the HD_TICKET table includes columns for HD_QUEUE_ID, HD_CATEGORY_ID and these correspond to the HD_QUEUE table's ID column and the HD_CATEGORY table's ID column respectively.