Need database table names list. for workflow scheme,issue type scheme, screens schemes report.

Question

We are preparing list of all jira Projects in jira system.

I can get project name and project key from table "PROJECT".
simillarly i wanted to know table name for workflow scheme, issue type scheme, screen scheme.

Along with it, wanted to know table name for

plans--->Manage shared teams data.

Can someone help on this please

Florian Bonniec · Answer

Hi @Kishore D ,

You have to check nodeassociation table and workflowschemeentity table.

nodeassociation should store all mapping between schema (notification, permission etc) and projects.

select PKEY, PNAME, WORKFLOWSCHEME.NAME from NODEASSOCIATION
inner join WORKFLOWSCHEME on NODEASSOCIATION.SINK_NODE_ID = WORKFLOWSCHEME.ID
inner join PROJECT on NODEASSOCIATION.SOURCE_NODE_ID = PROJECT.ID
WHERE SINK_NODE_ENTITY = 'WorkflowScheme'

Regards

Kishore D_suzx08 · Answer

Hi @Florian Bonniec ,

I have tried to check all %WORKFLOWSCHEME% tables defined in the databse schema pdf you have shared. I see WORKFLOWSCHEME table is having list of workflowscheme names.
 i see total of 865 projects in my datacenter. and we able to open project and see WORKFLOWSCHEME associated to it.
But, problem in my case is , in database i dont find  workflowscheme names for all projects (865 projects).

Is there any other table name which consist of this names and i am checking in wrong table?

Can you help with table name where i can get updated workflowscheme names of projects.

Florian Bonniec · Answer

Hi @Kishore D

You have the Jira database scheme available below.

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

Table for apps are available in Plugin Data Storage in the system menu.

Regards