JIRAISSUE table column descriptions

[Nagappan Murugappan]

Hello

I would like to know where can i find description of JIRA table columns, for example there is a column called RESOLUTION in JIRAISSUE table, i could find values like 10000 or 10001 etc, but if i want to know description for these values where can i find them. 

Version i am referring to is (server version)

• v8.13.1

thank you

[Hana Kučerová · Accepted solution]

Hi @Nagappan Murugappan ,

resolutions are in resolution table:

select id, pname, description from resolution

[Nagappan Murugappan]

Thanks a lot Hana.

[Nic Brough -Adaptavist-]

Stop reading the database, it's the worst possible way to look at Jira data.

[Nagappan Murugappan]

Hi Nic

Thanks for your feedback, its not for looking at the data, but based on resolution and resolution dates, we do create certain customized reports.