Startrekzky opened a new issue, #5475: URL: https://github.com/apache/incubator-devlake/issues/5475
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/incubator-devlake/issues?q=is%3Aissue) and found no similar feature requirement. ### Use case DevLake v0.18 only has a `cicd_deployment_commits` table, indicating the entity `deployment_commits`, and using the field `cicd_deployment_id` as the unique identifier of a `deployment`. Also, based on the current design: - `incidents` are associated with `deployments` in table project_issue_metrics - `pull_requests` are associated with `deployment_commits` in table project_pr_metrics This brought some confusion to the users. ### Description The purposes of adding an independent `deployments` table are to: - To clarify the difference between `deployments` and `deployment_commits` - To standardize the relationship between `deployments` (whether to use `deployments` or `deployment_commits` and when) and other entities such as `incidents` and `pull_requests`. ### Related issues _No response_ ### Are you willing to submit a 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
