Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

looking for the Physical data model for the JIRA installation

i am looking to create a physical model specifically for the tables we use within our JIRA application (project, epic, story, task, bug, version, commitment, label,link, subtask, insprintbug, release, sprint) so I can identify the keys from the story to the bug, the subtask to the project etc. Is there something I can get from the JIRA app, maybe as an administrator logged in? 

1 answer

0 votes

Not from Jira, see https://developer.atlassian.com/server/jira/platform/database-schema/

Be aware that reading a Jira database is the single worst possible way to get at Jira data.  The database is not a real database, it is a data store, and is the precise opposite of anything you would want to design reporting on.

You will be using long and torturous joins to get answers to even the most simple of questions.  "Show me an issue" requires 30 joins even before it has any history or custom fields.

I very strongly recommend doing whatever you are doing another way.

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you