SQL query assistance

[Adam Haysley]

I am trying to start create metric reports and the exports from JSM are limited to 1000 rows.  I have access to the sql server and would like to create a query that I can pull a custom field called responsible team in addition to items in the jiraissue table.  Where are the custom fields stored and what is the primary key?

[Ahmed Arslan]

@Adam Haysley There is a way to increase the export limit and you don't have to go the SQL way. But you can find the schema link here for DB: https://developer.atlassian.com/server/jira/platform/database-schema/