how can i get a database diagram for jira

[Richard Sigrist]

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_]

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

[Tiago Comasseto]

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

Cheers

[Nic Brough _Adaptavist_]

He's already been pointed at that.