Whow to find the database - mapping?

[Josef Sigl]

Is there existing an document or is there an way to find easily the mapping, which data are located in which tables? That would be very helpful for database updates

Our JIRA Version is: 8.5.1

[Josef Sigl]

Hi Nic, the link you gave to me, ist perfect ... thats what I,m looked for. thanks a lot - kind regards 

[Nic Brough -Adaptavist-]

Yes, but you won't want to use it.

I want to ask "why"?  Why do you think you want to update a Jira database?  I ask because whatever you're trying to do, doing it with SQL is almost certainly going to be the worst possible way to do it.  

If we know what you're trying to achieve, we can probably suggest a nicer, more simple, more reliable, easier and friendlier way to do it than SQL.

-----

But to answer the question in full:

You should never be updating a Jira database as a matter of course. 

The only time you should write to a Jira database with SQL is when you've been told to by support when you're fixing a problem or working around a complicated problem, and it will be a one-off to fix something, never a regular thing.

The database is complex and messy, it is not intended to be understood by humans, and whatever you think you want to change, it is unlikely that you will get it right first time.  And when you get it wrong, it is incredibly easy to completely corrupt your data.  Even what sounds like a trivial change can render your Jira non-functional if you get it wrong.

If you do need to make updates to a Jira database, there is a process you must follow:

1. Stop Jira
2. Take a full backup of the database
3. Use the backup to restore into a dev/test system, and test that the backup is good
4. Issue your SQL commands
5. Restart Jira
6. Run a full, locking re-index
7. Test your changes haven't broken anything
8. Let the users back in

So, with all of that forewarned, see https://developer.atlassian.com/server/jira/platform/database-schema/

[Josef Sigl]

hy nic, 

I don't want to make big updates, I just want to execute select statements for various evaluations.
So I would like to know what can i find where.

[Nic Brough -Adaptavist-]

You said updates, so I worried.

Having a (read-only) look won't do any harm, but you still won't like doing it.  A simple "show me an issue" starts with 18 joins and can go into the hundreds for even a moderately complex issue.  And you could run into things that make zero sense, even with a good schema guide.

So, rather than "I want to look at the database", could you explain what you are looking for and why?

(And see the link I gave if you still want the schema)