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
For JSM June Challenge #2, share how your non-technical teams like HR, legal, marketing, finance, and beyond started using Jira Service Management! Tell us: Did they ask to start using it or...
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