The jiraissue table

The jiraissue table is used to store JIRA issues. Let's check the structure of this table.

The table structure

Run the following query:

desc jiraissue;

The output of this query is as follows:

Finding issues of a specific project

It's quite easy to find the list of issues of a specific project using the JIRA Issue Navigator, but as we are exploring the database schema and its various tables, let's fetch the issues of a specific project directly from the database:

SELECT p.id AS project_id, p.pname AS project_name, CONCAT("SSP-
",ji.issuenum)  AS issue_id, ji.reporter AS issue_reporter FROM project p 
LEFT OUTER JOIN jiraissue ji ON ji.project = p.id WHERE p.pkey = 'SSP' ORDER 
BY ji.issuenum;

The preceding query will display the list of issues of the project with the SSP key. You can replace the project key with your own and try the previous query. The project name and a few other fields are fetched from the project table.