Entity Relationship Diagram of Mantis 1.2.10

[ngch]

Hi there.

I've been working on an ER diagram for Mantis 1.2.10. I mostly guessed the relationships by studying data from an earlier version of Mantis server currently in use, and the MySQL database of a vanilla installation of 1.2.10.

I drew the whole thing from scratch in Dia, so the relationships were derived from guesswork and studying changes in the database while adding user, reporting issues, etc. . Previous results with MySQL Workbench did not turn out... useful, since it could not automatically determine the relationships for me.

I would like to know if my diagram is correct. So far it seems logically correct to me.

Thanks!

[atrol]

Nice work!

I had a very quick look at it. Seems OK to me at first sight.
Just wondering that there is no column type for column steps_to_reproduce of mantis_bug_text_table.

Please be aware that direct manipulating of the MantisBT database is not the recommended way to access the data.
Whenever possible use the PHP functions that come with MantisBT or the SOAP API.

For what purpose do you want to use the diagramm?
Which tool did you use to draw the diagramm?

[ngch]

Thanks for the help!

I have an installation of Mantis 1.1.0a2 that I wish to upgrade to 1.2.10. The current installation has accumulated plenty of custom php scripts for generating reports and other things, and they query the database directly. So I drew myself the diagram so that I can better figure out how to port those scripts to the new version, and as documentation for the next guy to work on it. I'll see how the scripts can make better use of the existing API.

I drew the diagram on GNOME Dia, which comes with objects for ER diagrams.

I've attached the Dia file with the fixes made. Hopefully others can find this useful too.

[atrol]

I drew the diagram on GNOME Dia, which comes with objects for ER diagrams.

I never used Dia until know. I installed it and was able to open your diagram. Great!
Is there any tool that you used to reengineer the database which generates the Dia format?

[kadenscott]

Nicely describe the diagram of Mantis 1.2.10. Thanks to both of you