Jira Tables

[Steve Purdy]

I need to write a query against the back end database to return a list of projects, and issue types that they have assigned to them for use  

[Payne]

In general most folks here will advise against interacting directly with the database, but the occasional select query may be useful. You can find a schema at the following URL.

https://developer.atlassian.com/server/jira/platform/database-schema/