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?
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.
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