From https://osticket.com/
- osTicket is a widely used and trusted open source support ticketing system.
- Robust customer support portal system to help your business maintain happy customer relationships.
For more information visit https://osticket.com/
HTML report / online ER Diagram
The Database Diagram was created by loading the database structure from locally installed osTicket version 1-17-3. The target database was MariaDB with InnoDB default engine.
How to use the ER diagram/HTML report: click on a db table in the online ER Diagram. A new window opens – and in the window you can view the details of the table, including how indexes are defined and other details of the selected MariaDB table.
The database structure doesn’t include relationships and like in many other open source systems, database functions, table triggers and other database objects are not specified.
Details
Target database:
MariaDB
Diagram URL:
https://www.dbdiagrams.com/online-diagrams/osticket-1-17-3/
Luna Modeler project file:
https://www.dbdiagrams.com/online-diagrams/osticket.dmm
How to:
Open *.dmm project file in Luna Modeler
About Luna Modeler: a desktop data modeling tool for MariaDB, MySQL, PostgreSQL and SQLite. It allows you to create ER diagrams of existing databases, generate SQL or schema creation scripts and produce PDF or HTML reports. A feature-limited trial version is available for Windows, macOS and Linux. For more information about Luna Modeler please visit https://www.datensen.com
If you have suggestions or comments, send us a message to dbdiagrams(at)dbdiagrams.com.