Page 1 of 1

ERD Datamodel (Data Model, Relationsship Diagram)

Posted: 08 Mar 2010, 14:16
by mantistestor
Hi
I was looking for a ERD of Mantis 1.2. and found nothing.

I tried some Database-Design Tools:
* MySQL Workbench
* Datanamic Solution BV - DeZign for Databases
* Quest Software - Toad Data Modeler
* fabFORCE DBDesigner 4

The MySQL Workbench and DeZign comes with the feature for importing a SQL Database without using a server (DB)-connection.
The database-structure of Mantis works not with foreign-keys. The automatic relationsship-checker of DeZign an MySQL Workbench fails for generating the ERD.

I desgined as best-guess a relationsship-diagramm. Sure there are failures on it. It would be nice if someone can verify the diagramm or posting a better one.

greets
mantistestor

EDIT: attachement

Re: ERD Datamodel (Data Model, Relationsship Diagram)

Posted: 08 Mar 2010, 16:52
by atrol
Did you forget to provide a link to the diagram?

Re: ERD Datamodel (Data Model, Relationsship Diagram)

Posted: 11 Mar 2010, 16:22
by mantistestor
sorry, i can not upload jpg, png
"Could not upload attachment to ..."

Re: ERD Datamodel (Data Model, Relationsship Diagram)

Posted: 16 Mar 2010, 20:44
by atrol
mantistestor sent his ERD to me
Until attachments are working in forum, temporarely available at this place
http://www.atrol.de/mantisbt/MantisERD1.2.03a.png
Image