allthecodes opened a new issue, #8458: URL: https://github.com/apache/incubator-devlake/issues/8458
### Search before asking - [x] I had searched in the [issues](https://github.com/apache/incubator-devlake/issues?q=is%3Aissue) and found no similar issues. ### What happened As per the documentation for the data model, issue_comments.issue_id is a foreign key of issues.id, however the after transformation, the issues_comments.issue_id is not the fully qualified id, eg: jira:jiraIssue:1:10000, but just the raw issue id - e.g: 10000. ### What do you expect to happen issue_comments.issue_id should match issues.id for it to be a foreign key. ### How to reproduce v1.0.2-beta8 - a new normal pipeline will reproduce the issue. ### Anything else _No response_ ### Version v1.0.2-beta8 ### Are you willing to submit PR? - [ ] Yes I am willing to submit a PR! ### Code of Conduct - [x] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: dev-unsubscr...@devlake.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org