Retrieving issue information from a database
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 ...
Get JIRA Development Cookbook - Third Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
