Why I see column in JIRA website but can not find the related field in SQL JIRA Database

[Stacey jie]

For example, I can see a column, like severity, or platform in my JIRA website. But when I login the related JIRA Database in SQL Server2008 Management Studio, I can not see a table column, like severity or platform in any table, like jiraissue, etc.

[Colin Goudie · Accepted solution]

Like with any software, you need to understand the architecture in order to understand the database.

JIRA is highly configurable so most of the data for issues will not be columns in the jiraissue table.

There are some hardcoded fields such as priority and environment that are in the jiraissue table but the rest would come from custom fields. For your particular columns, first find out what custom field type are being used for these items and then that can help find out how their storage is implemented.

[Azwandi Mohd Aris]

Also, check out this doc http://confluence.atlassian.com/display/JIRA041/Database+Schema

[Pablo Beltran]

The SQL for JIRA add-on resolves the JIRA legacy database model complexity by providing a simplified data base model for JIRA. Only meaningful JIRA data for users are brought to the model, the rest of the JIRA internals are ignored.

So neither you nor other users at your organization have to access to the JIRA legacy database anymore. SQL for JIRA will save you from such wasting of time (and security risks).