The jiradatabase schema shows the id, pkey and issuenum fields for the jiraissue table.
All three of them seem to be IDs of some sort but I want to understand what exactly do they represent and what are they used for. Especially the issuenum field as it is not connected to any other table and is also not unique in the jiraissue table.
id is the database-internal thing used to link the issue in the database. This is what you will find in other tables.
issuenum is what you see when you look at the issue; e.g., for issue KEY-4711, the issuenum will be 4711. Since you can have both issues KEY-4711 and OTHER-4711 in you jira, this won't be unique - but the combination project + issuenum will always be unique.
pkey is always null in my Jira; perhaps an old column used to link to project before the "project" column appeared?
id is the internal ID of the jira issue which is internally used in Jira database to refer to an issue. This is the unique ID for a jira issue and does not change.
issuenum is the numeric part of the Jira issue key which is visible to you on the UI. For example if the visible Issue key of one of your Jira issues is AL-17, then "issuenum" for this will be "17". This value can change if you perform operations like moving the issue to some different project.
pkey should no longer be in use in this table.
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events