osTicket v1.10 (stable) and Maintenance Release v1.9.15 are now available! Go get it now
Help understanding tables for direct query
I am a bit new to OSTicket, but I absolutely love it and I am thankful for those who work on it. I ask for pardon in advance if my questions have been answered elsewhere. Is there a place where I can find the schema? What tables there are and what each field represents? I ask because I have some difficulty understanding what is considered a newly created, an opened status and a closed ticket for purposes of direct mysql query. Thanks!