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

[Elena Karimshikhova]

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?

[Radek Dostál]

Issue Type is not a custom field, it's used in jiraissue.issuetype; with char type id (not a number).

[Elena Karimshikhova]

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

[Radek Dostál]

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]

thanks, helped a lot