Information about an issue is scattered around in multiple tables in the JIRA database. However, a good starting point is the jiraissue
table, which is where the issue record is stored. It has foreign keys referencing other tables and, at the same time, the issue id is referenced in a few other tables.
The following diagram captures the important tables that the jiraissue
table has a parent relationship with. Depending on the JIRA version, there might be slight variations but this is probably a good starting point:
As you can see, critical information about an issue, such as the project, issue type, status, priority, resolution, security level, and workflow, is all stored in the respective tables but is referenced from the jiraissue
table, using a foreign key. The foreign key points to the id of the other tables in all cases, but there are no foreign key constraints enforced on any of these tables.
From JIRA 6.1, JIRA supports project renaming and...