PagerDuty
Explore the interactive ERD
Table & Field Reference
business_service_subscriber
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
business_service_id | Unknown | PKFK |
account_id | Unknown | |
subscriber_type | Unknown |
maintenance_window_service
| Column | Type | Keys |
|---|---|---|
maintenance_window_id | Unknown | PKFK |
service_id | Unknown | PKFK |
maintenance_window_team
| Column | Type | Keys |
|---|---|---|
maintenance_window_id | Unknown | PKFK |
team_id | Unknown | PKFK |
maintenance_window
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_by_id | Unknown | FK |
description | Unknown | |
end_time | Unknown | |
html_url | Unknown | |
sequence_number | Unknown | |
start_time | Unknown | |
summary | Unknown |
escalation_policy_target
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
escalation_policy_rule_id | Unknown | PKFK |
html_url | Unknown | |
summary | Unknown | |
type | Unknown |
escalation_policy_rule
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
escalation_policy_id | Unknown | PKFK |
escalation_delay_in_minutes | Unknown |
escalation_policy_service
| Column | Type | Keys |
|---|---|---|
escalation_policy_id | Unknown | PKFK |
service_id | Unknown | PKFK |
escalation_policy_team
| Column | Type | Keys |
|---|---|---|
escalation_policy_id | Unknown | PKFK |
team_id | Unknown | PKFK |
escalation_policy
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
description | Unknown | |
html_url | Unknown | |
name | Unknown | |
num_loops | Unknown | |
on_call_handoff_notifications | Unknown | |
privilege | Unknown | |
summary | Unknown |
notification
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
user_id | Unknown | PKFK |
address | Unknown | |
started_at | Unknown | |
type | Unknown |
incident_custom_field_value
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
incident_id | Unknown | PKFK |
data_type | Unknown | |
description | Unknown | |
display_name | Unknown | |
enabled | Unknown | |
field_type | Unknown | |
name | Unknown | |
type | Unknown | |
value | String |
extension_schema_option
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
extension_schema_id | Unknown | FK |
label | Unknown | |
value | Unknown |
extension_schema_send_type
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
extension_schema_id | Unknown | FK |
send_type | Unknown |
extension_feature
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
extension_schema_id | Unknown | PKFK |
extension_schema
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
addon_id | Unknown | FK |
authorizable | Unknown | |
buttons | Json | |
config_snow_password_encrypted | Unknown | |
config_snow_password_label | Unknown | |
config_snow_password_type | Unknown | |
config_snow_user_label | Unknown | |
config_sync_options_defaults | Unknown | |
config_sync_options_help_tip | Unknown | |
config_sync_options_label | Unknown | |
config_sync_options_type | Unknown | |
config_target_label | Unknown | |
config_target_placeholder | Unknown | |
description | Unknown | |
guide_url | Unknown | |
html_url | Unknown | |
icon_url | Unknown | |
key | Unknown | |
label | Unknown | |
logo_url | Unknown | |
summary | Unknown | |
url | Unknown |
ruleset_routing_key
| Column | Type | Keys |
|---|---|---|
routing_key | Unknown | PK |
ruleset_id | Unknown | PKFK |
ruleset
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
creator_id | Unknown | FK |
team_id | Unknown | FK |
updater_id | Unknown | FK |
created_at | Unknown | |
creator_type | Unknown | |
name | Unknown | |
type | Unknown | |
updated_at | Unknown | |
updater_type | Unknown |
business_service
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
team_id | Unknown | FK |
description | Unknown | |
html_url | Unknown | |
name | Unknown | |
point_of_contact | Unknown | |
summary | Unknown | |
type | Unknown |
users_contact_method
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
users_id | Unknown | PKFK |
address | Unknown | |
html_url | Unknown | |
summary | Unknown | |
type | Unknown |
users_notification_rule
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
users_id | Unknown | PKFK |
html_url | Unknown | |
summary | Unknown | |
type | Unknown |
users_team
| Column | Type | Keys |
|---|---|---|
team_id | Unknown | PKFK |
users_id | Unknown | PKFK |
users
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
avatar_url | Unknown | |
billed | Unknown | |
color | Unknown | |
coordinated_incidents | Unknown | |
description | Unknown | |
email | Unknown | |
html_url | Unknown | |
invitation_sent | Unknown | |
job_title | Unknown | |
name | Unknown | |
role | Unknown | |
summary | Unknown | |
time_zone | Unknown | |
type | Unknown |
tags
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
html_url | Unknown | |
label | Unknown | |
summary | Unknown | |
type | Unknown |
license_valid_role
| Column | Type | Keys |
|---|---|---|
valid_role | Unknown | PK |
license_id | Unknown | PKFK |
license
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
allocations_available | Unknown | |
current_value | Unknown | |
description | Unknown | |
html_url | Unknown | |
name | Unknown | |
role_group | Unknown | |
summary | Unknown | |
type | Unknown |
incident_note
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
incident_id | Unknown | PKFK |
user_id | Unknown | FK |
channel | Json | |
content | Unknown | |
created_at | Unknown | |
updated_at | Unknown | |
user_type | Unknown |
template
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_by_id | Unknown | PKFK |
updated_by_id | Unknown | PKFK |
created_at | Unknown | |
created_by_type | Unknown | |
description | Unknown | |
name | Unknown | |
template_type | Unknown | |
updated_at | Unknown | |
updated_by_type | Unknown |
extension_object
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
extension_id | Unknown | PKFK |
html_url | Unknown | |
summary | Unknown | |
type | Unknown |
extension
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
extension_schema_id | Unknown | PKFK |
endpoint_url | Unknown | |
name | Unknown | |
summary | Unknown | |
type | Unknown |
addon
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
html_url | Unknown | |
name | Unknown | |
src | Unknown | |
summary | Unknown |
on_call
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
escalation_policy_id | Unknown | FK |
schedule_id | Unknown | FK |
user_id | Unknown | FK |
ends | Unknown | |
escalation_level | Unknown | |
start | Unknown |
vendor
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
alert_creation_default | Unknown | |
alert_creation_editable | Unknown | |
connectable | Unknown | |
description | Unknown | |
developer_name | Unknown | |
documentation_url | Unknown | |
emits_change_events | Unknown | |
generic_service_type | Unknown | |
html_url | Unknown | |
integration_guide_url | Unknown | |
is_pd_cef | Unknown | |
is_pd_change_event | Unknown | |
logo_url | Unknown | |
long_name | Unknown | |
name | Unknown | |
summary | Unknown | |
support_email | Unknown | |
support_portal | Unknown | |
thumbnail_url | Unknown | |
type | Unknown | |
website_url | Unknown |
analytics_metric_service
| Column | Type | Keys |
|---|---|---|
range_start | Unknown | PK |
aggregate_unit | Unknown | |
created_at_end | Unknown | |
created_at_start | Unknown | |
mean_assignment_count | Unknown | |
mean_engaged_seconds | Unknown | |
mean_engaged_user_count | Unknown | |
mean_seconds_to_engage | Unknown | |
mean_seconds_to_first_ack | Unknown | |
mean_seconds_to_mobilize | Unknown | |
mean_seconds_to_resolve | Unknown | |
mean_user_defined_engaged_seconds | Unknown | |
total_business_hour_interruptions | Unknown | |
total_down_time_minutes | Unknown | |
total_engaged_seconds | Unknown | |
total_escalation_count | Unknown | |
total_high_urgency_incidents | Unknown | |
total_incident_count | Unknown | |
total_incidents_acknowledged | Unknown | |
total_incidents_auto_resolved | Unknown | |
total_incidents_escalated | Unknown | |
total_incidents_manual_escalated | Unknown | |
total_incidents_reassigned | Unknown | |
total_incidents_timeout_escalated | Unknown | |
total_interruptions | Unknown | |
total_low_urgency_incidents | Unknown | |
total_major_incidents | Unknown | |
total_notifications | Unknown | |
total_off_hour_interruptions | Unknown | |
total_sleep_hour_interruptions | Unknown | |
total_snoozed_seconds | Unknown | |
total_user_defined_engaged_seconds | Unknown | |
up_time_pct | Unknown |
slack_dedicated_channel
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
incident_id | Unknown | PKFK |
slack_team_id | Unknown | FK |
deep_link | Unknown | |
link | Unknown | |
name | Unknown |
audit_record_actor
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
audit_record_id | Unknown | PKFK |
summary | Unknown | |
type | Unknown |
audit_record_field
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
audit_record_id | Unknown | FK |
name | Unknown | |
value | Unknown |
reference_removed
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
reference_id | Unknown | PKFK |
summary | Unknown | |
type | Unknown |
reference_added
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
reference_id | Unknown | PKFK |
summary | Unknown | |
type | Unknown |
reference
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
audit_record_id | Unknown | PKFK |
audit_record
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
action | Unknown | |
details_resource_id | Unknown | |
details_resource_summary | Unknown | |
details_resource_type | Unknown | |
execution_context_remote_address | Unknown | |
execution_context_request_id | Unknown | |
execution_time | Unknown | |
method_description | Unknown | |
method_truncated_token | Unknown | |
method_type | Unknown | |
root_resource_id | Unknown | |
root_resource_summary | Unknown | |
root_resource_type | Unknown |
change_event_service
| Column | Type | Keys |
|---|---|---|
change_event_id | Unknown | PKFK |
service_id | Unknown | PKFK |
type | Unknown |
change_event
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
custom_details_build_number | Unknown | |
custom_details_build_state | Unknown | |
custom_details_run_time | Unknown | |
integration_id | Unknown | |
integration_type | Unknown | |
source | Unknown | |
summary | Unknown | |
time_stamp | Unknown |
paused_incident_resolved_after_pause_alert
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
_fivetran_id | Unknown | PKFK |
service_id | Unknown | PKFK |
created_at | Unknown |
paused_incident_triggered_after_pause_alert
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
_fivetran_id | Unknown | PKFK |
service_id | Unknown | PKFK |
created_at | Unknown |
paused_incident_reporting_alert
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
since | Unknown | |
until | Unknown |
team
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
default_role | Unknown | |
description | Unknown | |
html_url | Unknown | |
name | Unknown | |
parent | Unknown | |
summary | Unknown | |
type | Unknown |
incident_workflow_team
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
incident_workflow_id | Unknown | FK |
type | Unknown |
action_input
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
incident_workflow_action_id | Unknown | PKFK |
name | Unknown | |
parameter_type | Unknown | |
value | Unknown |
action_output
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
incident_workflow_action_id | Unknown | PKFK |
name | Unknown | |
parameter_type | Unknown | |
value | Unknown |
incident_workflow_action
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
incident_workflow_step_id | Unknown | FK |
description | Unknown |
incident_workflow_step
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
incident_workflow_id | Unknown | FK |
description | Unknown | |
html_url | Unknown | |
name | Unknown | |
summary | Unknown | |
type | Unknown |
incident_workflow
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_at | Unknown | |
description | Unknown | |
html_url | Unknown | |
name | Unknown |
schedule_escalation_policy
| Column | Type | Keys |
|---|---|---|
escalation_policy_id | Unknown | PKFK |
schedule_id | Unknown | PKFK |
schedule_users
| Column | Type | Keys |
|---|---|---|
schedule_id | Unknown | PKFK |
user_id | Unknown | PKFK |
schedule
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
description | Unknown | |
html_url | Unknown | |
name | Unknown | |
summary | Unknown | |
time_zone | Unknown |
raw_incident_joined_user_id
| Column | Type | Keys |
|---|---|---|
joined_user_id | Unknown | PK |
raw_incident_id | Unknown | PKFK |
raw_incident_joined_user_name
| Column | Type | Keys |
|---|---|---|
joined_user_name | Unknown | PK |
raw_incident_id | Unknown | PKFK |
raw_incident_assigned_user_id
| Column | Type | Keys |
|---|---|---|
assigned_user_id | Unknown | PK |
raw_incident_id | Unknown | PKFK |
raw_incident_assigned_user_name
| Column | Type | Keys |
|---|---|---|
assigned_user_name | Unknown | PK |
raw_incident_id | Unknown | PKFK |
raw_incident_acknowledged_user_name
| Column | Type | Keys |
|---|---|---|
acknowledged_user_name | Unknown | PK |
raw_incident_id | Unknown | PKFK |
raw_incident_acknowledged_user_id
| Column | Type | Keys |
|---|---|---|
acknowledged_user_id | Unknown | PK |
raw_incident_id | Unknown | PKFK |
raw_incident
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
escalation_policy_id | Unknown | FK |
resolved_by_user_id | Unknown | FK |
service_id | Unknown | FK |
team_id | Unknown | FK |
acknowledgement_count | Unknown | |
active_user_count | Unknown | |
assignment_count | Unknown | |
auto_resolved | Unknown | |
business_hour_interruptions | Unknown | |
created_at | LocalDateTime | |
description | Unknown | |
engaged_seconds | Unknown | |
engaged_user_count | Unknown | |
escalation_count | Unknown | |
escalation_policy_name | Unknown | |
incident_number | Unknown | |
incident_type_id | Unknown | |
incident_type_name | Unknown | |
major | Unknown | |
major_incident | Unknown | |
manual_escalation_count | Unknown | |
off_hour_interruptions | Unknown | |
pd_advance_used | Unknown | |
priority_id | Unknown | |
priority_name | Unknown | |
priority_order | Unknown | |
reassignment_count | Unknown | |
resolved_at | LocalDateTime | |
resolved_by_user_name | Unknown | |
seconds_to_engage | Unknown | |
seconds_to_first_ack | Unknown | |
seconds_to_mobilize | Unknown | |
seconds_to_resolve | Unknown | |
service_name | Unknown | |
sleep_hour_interruptions | Unknown | |
snoozed_seconds | Unknown | |
status | Unknown | |
timeout_escalation_count | Unknown | |
total_interruptions | Unknown | |
total_notifications | Unknown | |
updated_at | LocalDateTime | |
urgency | Unknown | |
user_defined_effort_seconds | Unknown |
tag_entity
| Column | Type | Keys |
|---|---|---|
tags_id | Unknown | PKFK |
team_id | Unknown | PKFK |
type | Unknown |
users_notification_subscription
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
users_id | Unknown | PKFK |
account_id | Unknown | |
subscribable_id | Unknown | |
subscribable_name | Unknown | |
subscribable_type | Unknown | |
subscriber_type | Unknown |
user_delegation
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
users_id | Unknown | PKFK |
client_id | Unknown | |
created_at | Unknown | |
scope | Unknown | |
self | Unknown | |
status | Unknown | |
type | Unknown | |
updated_at | Unknown |
service_team
| Column | Type | Keys |
|---|---|---|
service_id | Unknown | PKFK |
team_id | Unknown | PKFK |
service_days_of_week
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
service_id | Unknown | FK |
days_of_week | Unknown |
service_integration
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
service_id | Unknown | PKFK |
html_url | Unknown | |
summary | Unknown |
service_scheduled_action
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
service_id | Unknown | FK |
at_name | Unknown | |
at_type | Unknown | |
to_urgency | Unknown | |
type | Unknown |
service
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
escalation_policy_id | Unknown | FK |
acknowledgement_timeout | Unknown | |
alert_creation | Unknown | |
alert_grouping | Unknown | |
alert_grouping_parameters_config_recommended_time_window | Unknown | |
alert_grouping_parameters_config_time_window | Unknown | |
alert_grouping_parameters_type | Unknown | |
auto_grouping | Unknown | |
auto_grouping_timeout | Unknown | |
auto_pause_notifications_parameters_enabled | Unknown | |
auto_pause_notifications_parameters_timeout | Unknown | |
auto_resolve_timeout | Unknown | |
created_at | Unknown | |
description | Unknown | |
html_url | Unknown | |
name | Unknown | |
response_play | Unknown | |
status | Unknown | |
summary | Unknown | |
support_hours_end_time | Unknown | |
support_hours_start_time | Unknown | |
support_hours_time_zone | Unknown | |
support_hours_type | Unknown | |
updated_at | Unknown |
event_orchestration
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_by_id | Unknown | FK |
team_id | Unknown | FK |
updated_by_id | Unknown | FK |
created_at | Unknown | |
created_by_type | Unknown | |
description | Unknown | |
name | Unknown | |
routes | Unknown | |
updated_at | Unknown | |
updated_by_type | Unknown | |
version | Unknown |
users_handoff_notification_rule
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
users_id | Unknown | PKFK |
contact_method_id | Unknown | |
contact_method_summary | Unknown | |
contact_method_type | Unknown | |
handoff_type | Unknown | |
notify_advance_in_minutes | Unknown |
incident_team
| Column | Type | Keys |
|---|---|---|
incident_id | Unknown | PKFK |
team_id | Unknown | PKFK |
incident
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
escalation_policy_id | Unknown | FK |
service_id | Unknown | FK |
acknowledgements | Json | |
alert_counts_all | Unknown | |
alert_counts_resolved | Unknown | |
alert_counts_triggered | Unknown | |
alert_grouping_active | Unknown | |
alert_grouping_ended_at | Unknown | |
alert_grouping_started_at | Unknown | |
alerts_grouping_type | Unknown | |
assigned_via | Unknown | |
assignments | Json | |
basic_alert_grouping_expires_at | Unknown | |
body_details | Json | |
conference_bridge_conference_number | Unknown | |
conference_bridge_conference_url | Unknown | |
created_at | Unknown | |
first_trigger_log_entry_html_url | Unknown | |
first_trigger_log_entry_id | Unknown | |
first_trigger_log_entry_summary | Unknown | |
html_url | Unknown | |
incident_key | Unknown | |
incident_number | Unknown | |
incident_type_name | Unknown | |
is_basic_alert_grouping | Unknown | |
last_status_change_at | Unknown | |
last_status_change_by_html_url | Unknown | |
last_status_change_by_id | Unknown | |
last_status_change_by_summary | Unknown | |
priority_account_id | Unknown | |
priority_color | Unknown | |
priority_created_at | Unknown | |
priority_description | Unknown | |
priority_html_url | Unknown | |
priority_id | Unknown | |
priority_name | Unknown | |
priority_order | Unknown | |
priority_schema_version | Unknown | |
priority_self | Unknown | |
priority_summary | Unknown | |
priority_type | Unknown | |
priority_updated_at | Unknown | |
status | Unknown | |
summary | Unknown | |
title | Unknown | |
urgency | Unknown |
log_entry_team
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
log_entries_id | Unknown | PKFK |
html_url | Unknown | |
summary | Unknown | |
type | Unknown |
log_entry_assignee
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
log_entries_id | Unknown | PKFK |
html_url | Unknown | |
summary | Unknown | |
type | Unknown |
log_entries
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
escalation_policy_id | Unknown | FK |
incident_id | Unknown | FK |
responder_id | Unknown | FK |
service_id | Unknown | FK |
user_id | Unknown | FK |
agent_html_url | Unknown | |
agent_id | Unknown | |
agent_summary | Unknown | |
agent_type | Unknown | |
channel_changeset_application_fields_id | Unknown | |
channel_changeset_application_fields_name | Unknown | |
channel_changeset_application_fields_namespace | Unknown | |
channel_changeset_application_fields_old_value | Unknown | |
channel_changeset_application_fields_value | Unknown | |
channel_changeset_customer_fields_id | Unknown | |
channel_changeset_customer_fields_name | Unknown | |
channel_changeset_customer_fields_namespace | Unknown | |
channel_changeset_customer_fields_old_value | Unknown | |
channel_changeset_customer_fields_value | Unknown | |
channel_notification_address | Unknown | |
channel_notification_conference_address | Unknown | |
channel_notification_status | Unknown | |
channel_notification_type | Unknown | |
channel_type | Unknown | |
contexts | Json | |
created_at | Unknown | |
event_details_description | Unknown | |
html_url | Unknown | |
summary | Unknown |