Where to find Database Scheme including data types for Jira 6.3?

[Mark Gordon]

JIRA

Can you point me to a link/document that has the 6.3 database scheme layed out including the data types?

[Nic Brough -Adaptavist- · Accepted solution]

The closest you'll get is https://developer.atlassian.com/display/JIRADEV/Database+Schema

[Mark Gordon]

Nic,

Thanks. This will help. I am a SQL DBA. I noticed that on the field types, you have varchar. is there a reason you are not using nvarchar for unicode/international characters?

[Nic Brough -Adaptavist-]

You'd need to ask an Atlassian developer with knowledge of the back-end.

I do some dev work in plugins, but I never go to the database, I use the API (if you think you need to read a Jira database in your code, you're probably doing something wrong. And you never write)

[Mark Gordon]

Nic,

Thanks. No we are not doing updates to the JIRA db. I would like to see what it has in it - most likely not doing an reads from it. If we were, then it would be something incredilby custom.

[Tiago Comasseto]

Hi Mark, the information that we have available is in this doc. It also has instructions on how you can generate the database schema information in different formats.

I hope it helps.

Cheers