Primary Key for FK in table jira.issuetype x and jira.customfieldoption

Question

Hello,

We are trying to build a table in MySQL from Jira.

Implemented table with fields:

cwd_user.display_name

cwd_user.email_address
jiraissue.SUMMARY
issuestatuslist.pname
worklog.worklogbody
worklog.timeworked
jiraissue.ASSIGNEE
worklog.issueid
projectlist.pkey
jiraissue.issuenum
app_user.user_key

Need to add type (Epic, task…) table jira.issuetype.pname и Customer from jira.customfieldoption.customvalue, we do not find the field by key to associate with the Implemented table.

Tell me in which cross table I can find the keys?

Elena Karimshikhova · Answer

thanks, helped a lot

Radek Dostál · Answer

What is it that you're doing though, what's the use case here? I don't see why you would need to replicate Jira's database scheme.

It depends what 'Customer' is, if it's a custom field then it will be customfield.id = customfieldvalue.customfield

But if it's not an out of box field, but a plugin/app (e.g. Jira Service Management), then it doesn't have to be in customfieldvalue at all, it could be storing it's values in entirely different tables, depending on the plugin, in which case you would either need to reverse-engineer how it works, or contact the vendor to tell you which tables are being used and how.

Elena Karimshikhova · Answer

Thank you, great, I found issuetype.

Maybe you know where Customer from jira.customfieldoption.customvalue which table bellow can be find key?

cwd_user.display_name

cwd_user.email_address
jiraissue.SUMMARY
issuestatuslist.pname
worklog.worklogbody
worklog.timeworked
jiraissue.ASSIGNEE
worklog.issueid
projectlist.pkey
jiraissue.issuenum
app_user.user_key