I am looking to see if anyone as a model of the database for version v.1.9.x. I am trying to attach our 3rd party program to the ticket system but I need to make complex queries. I can not figure out how the form_entry_values table is integrated into the ost_ticket table.

I'm hoping to find a .mwb file for MySQL Workbench

8 days later

Any kind of commented layout would help. I'm writing a migration from trac (http://trac.edgewall.org), which isn't easy while T&E/guessing most of the fields and relations.

All tables are MyISAM so there is no enforced foreign keys.  You can create DB dump in MySQL Workbench and then import the file into EER.  But it will not help you much since there are no relationships.  I am attaching a mwb, so save you a few minutes. (rename from .pdf).For your particular question I'm attaching mwb for forms section

[ost.mwb.pdf](https://forum.osticket.com/assets/files/migrated/FileUpload/4b/b2cdf229491f235c48c64eb4b9020d.pdf)

[ost.mwb.pdf](https://forum.osticket.com/assets/files/migrated/FileUpload/c7/423c86f808a93327d0b80a9249d14e.pdf)

[ost_forms.mwb.pdf](https://forum.osticket.com/assets/files/migrated/FileUpload/d9/a739b38a24843e8d12cd65e92d9e79.pdf)

a month later
Write a Reply...