Here is sample of basic process model for Pull Request.
Data Source: MSR14 Mining Challenge
Query String: SELECT pull_request_history.created_at, pull_request_history.pull_request_id, pull_request_history.action, pull_request_history.actor_id, pull_requests.pullreq_id FROM pull_request_history inner join pull_requests on pull_request_history.pull_request_id=pull_requests.id inner join projects on pull_requests.base_repo_id=projects.id where projects.id=78852
This process model doesn’t contain loop because the pull_request_history table doesn’t capture the review comments. However, this model show the lead time of pull request. In this model the light grey text represents median duration. The median duration for accepted pull request are much shorter than those that are not accepted.
Between Open -> Closed or Open -> Merged there are multiple comments and commits. In order to capture that, we will need to get data from pull_request_comments table.