dosubot[bot] commented on issue #8365: URL: https://github.com/apache/incubator-devlake/issues/8365#issuecomment-2757578101
<!-- Answer --> The `ref_commits` table in Apache DevLake is populated by the `RefDiff` plugin. This plugin processes data and stores the output in the `commits_diffs`, `finished_commits_diffs`, and `ref_commits` tables <sup>[[1]](https://github.com/apache/incubator-devlake-website/blob/main/docs/Plugins/refdiff.md)</sup>. To ensure the `ref_commits` table is populated correctly, make sure that the `finished_commits_diffs` table is populated first, as the `ref_commits` table has foreign key dependencies on it. Specifically, the `new_commit_sha` and `old_commit_sha` fields in the `ref_commits` table reference the corresponding fields in the `finished_commits_diffs` table <sup>[[2]](https://github.com/apache/incubator-devlake-website/blob/main/versioned_docs/version-v0.18/Configuration/images/domain_layer_model_v0.18.ndm2)</sup>. <!-- Dosu Comment Footer --> *To continue talking to [Dosu](https://dosu.dev), mention @dosu.* --- <sup>Help Dosu learn! Give it feedback: [Great Response](https://app.dosu.dev/response-feedback/92b8f98f-9fe8-4b8f-86f4-4c4f6f868134?feedback_type=great_response) | [Irrelevant Answer](https://app.dosu.dev/response-feedback/92b8f98f-9fe8-4b8f-86f4-4c4f6f868134?feedback_type=irrelevant_answer) | [Incorrect Sources](https://app.dosu.dev/response-feedback/92b8f98f-9fe8-4b8f-86f4-4c4f6f868134?feedback_type=incorrect_sources) | [Too Verbose](https://app.dosu.dev/response-feedback/92b8f98f-9fe8-4b8f-86f4-4c4f6f868134?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/92b8f98f-9fe8-4b8f-86f4-4c4f6f868134?feedback_type=hallucination) | [Bug Report](https://app.dosu.dev/response-feedback/92b8f98f-9fe8-4b8f-86f4-4c4f6f868134?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/92b8f98f-9fe8-4b8f-86f4-4c4f6f868134?feedback_type=other)</sup> -- 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 For queries about this service, please contact Infrastructure at: us...@infra.apache.org
