pull_request_deployments

id

Primary key
Unique ID for the row.

deployment_id

Foreign key
The unique ID for the associated deployment.

environment

string
The environment the deployment was associated with.

merge_to_deploy

date
The time difference in seconds between the merged_at and the deployed_at of the deployment

merge_to_deploy_business_hours

number
The time difference in seconds between the merged_at and the deployed_at of the deployment during business hours (M-F 8am - 6pm). The timezone of the author of the pull request is used if available, otherwise the default timezone of the account is used.

open_to_deploy

date
The difference in seconds between the ready_for_review_at of the pull and the deployed_at of the deployment

open_to_deploy_business_hours

number
The time difference in seconds between the ready_for_review_at of the pull request and the deployed_at of the deployment during business hours (M-F 8am - 6pm). The timezone of the author of the pull request is used if available, otherwise the default timezone of the account is used.

pull_request_id

Foreign key
The unique ID for the associated pull_request.

service

string
The name of the service the deployment belongs to.

tz

string
The timezone used to calculate business hours.

source

string
The name of the system that the pull request originated from.