Actually, for those of us who landed on this page but have JIRA 8.0+, the licence is indeed in the "productlicense" table, as stated here (changed since 7.0.5 and above):
But I also have no clue yet what ID from the "productlicense" table is referencing, as it does not look like it references "propertyentry" table. The above link is not helpful about the ID column at the moment.
I had three rows and this is the ID to Application mapping that worked for me on my server:
10300 -> JIRA Core
10301 -> JIRA Service Desk
10302 -> JIRA Software
I have multiple projects that use variations of the same base workflow. The variations depend on the requirements of the project or issue type. The variations mostly come in the form of new statuses ...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events