Data Model For Mantis

[paulachinthpaul]

Hi All,

Can anyone provide the data model for mantis.


Thanks in Advance,
Paul

[vboctor]

Check the schema file:
mantisbt\admin\schema.php

Or you can export the schema from phpMyAdmin to get a SQL file with the tables structures / indices.

[Mophilly]

This request seems to pop up from time to time. I have made a simple ERD for version 1.1.5 available at http://www.mophilly.com/wiki/MantisBT_Data_Model.

I don't mean to mislead; I am not promising to keep this up to date. However, I will do so as our needs demand it. Also, there is a link on the page if you would like the source document used to create the image.

The model is roughly correct. I did not attempt to resolve all the relationships and dependencies nor annotate logical errors. Perhaps someday I will have the time when the muse visits. Until then, I hope you find this helpful.

Happy days,

- Mophilly

[mcraig88]

That's very cool. Thanks for doing that. It seems that those relationships are not actually enforced in the database though. I'm running 1.1.1, are they enforced in later revisions?

[Mophilly]

I don't really know. I am not involved as a developer, and reverse models are always a bit weak. I recently came across Aqua Data Studio which provides a pretty good modeling tool. Perhaps I can winnow some additional information if time allows.