how can i get a database diagram for jira

Question

I have created several reports with Crystal Reports using an ODBC connection.  I have produced reports showing the progress/status of Issues and it all works very well.  I do not have a data base diagram to illustrate the connections between the tables.

At this time I am trying to use "links" to gather Issues that are linked to a specific Issue.  In addition, I am trying to gather the History within an Issue to scan for specific events.

I would like a data base schematic diagram to make design of reports easier.

Nic Brough -Adaptavist- · Answer

He's already been pointed at that.

Tiago Comasseto · Answer

Hi Richard, perhaps this can help you to start: https://developer.atlassian.com/display/JIRADEV/Database+Schema

Cheers

Nic Brough -Adaptavist- · Answer

You asked this yesterday, albeit as a comment on another question.  The answers there are still valid.

https://answers.atlassian.com/questions/11130/custom-reporting-and-retrieving-jira-data