referential integrity in Jira database?

Hi All,

There seems to be no referential integrity in Jira database. How could we achieve this?

Thanks and Regards,

Jenin C M

2 answers

0 vote

You don't really need it - the application handles it all internally. Adding referential integrity checks into the database would be pointless and could cause problems with the application.

Hi Nic,

Could you please brief me a bit more as how it handles it internally? Any examples will be very helpfull.

Thanks and Regards,

Jenin C M

I'm not sure what you're looking for here.

The application does things like "if you delete an issue, remove all the custom field, comments and history data for the issue".

I think it might be useful to know why you're asking about referential integrity?

There are lots of places where JIRA chooses not to make the DB data consistent. For example when you delete a filter, gadgets that were using the filter display "Filter not found", but the DB config for that gadget still refers to the deleted row in the searchrequests table. Or when you uninstall an add-on that provides a new custom field type, then reinstall the add-on, the data was never deleted.

But I do think that something like the Integrity Checker that scans for these cases and cleans up the JIRA data would be very useful in the long term

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

3,254 views 14 20
Join discussion

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot