# PagerDuty schema ERD

Table and field reference for the Fivetran PagerDuty connector.

## Table & Field Reference

### business_service_subscriber

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| business_service_id | Unknown | PK, FK |
| account_id | Unknown |  |
| subscriber_type | Unknown |  |

### maintenance_window_service

| Column | Type | Keys |
| --- | --- | --- |
| maintenance_window_id | Unknown | PK, FK |
| service_id | Unknown | PK, FK |

### maintenance_window_team

| Column | Type | Keys |
| --- | --- | --- |
| maintenance_window_id | Unknown | PK, FK |
| team_id | Unknown | PK, FK |

### 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 | PK, FK |
| html_url | Unknown |  |
| summary | Unknown |  |
| type | Unknown |  |

### escalation_policy_rule

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| escalation_policy_id | Unknown | PK, FK |
| escalation_delay_in_minutes | Unknown |  |

### escalation_policy_service

| Column | Type | Keys |
| --- | --- | --- |
| escalation_policy_id | Unknown | PK, FK |
| service_id | Unknown | PK, FK |

### escalation_policy_team

| Column | Type | Keys |
| --- | --- | --- |
| escalation_policy_id | Unknown | PK, FK |
| team_id | Unknown | PK, FK |

### 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 | PK, FK |
| address | Unknown |  |
| started_at | Unknown |  |
| type | Unknown |  |

### incident_custom_field_value

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| incident_id | Unknown | PK, FK |
| 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 | PK, FK |

### 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 | PK, FK |

### 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 | PK, FK |
| address | Unknown |  |
| html_url | Unknown |  |
| summary | Unknown |  |
| type | Unknown |  |

### users_notification_rule

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| users_id | Unknown | PK, FK |
| html_url | Unknown |  |
| summary | Unknown |  |
| type | Unknown |  |

### users_team

| Column | Type | Keys |
| --- | --- | --- |
| team_id | Unknown | PK, FK |
| users_id | Unknown | PK, FK |

### 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 | PK, FK |

### 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 | PK, FK |
| 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 | PK, FK |
| updated_by_id | Unknown | PK, FK |
| created_at | Instant |  |
| 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 | PK, FK |
| html_url | Unknown |  |
| summary | Unknown |  |
| type | Unknown |  |

### extension

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| extension_schema_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| summary | Unknown |  |
| type | Unknown |  |

### reference_added

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| reference_id | Unknown | PK, FK |
| summary | Unknown |  |
| type | Unknown |  |

### reference

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| audit_record_id | Unknown | PK, FK |

### 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 | PK, FK |
| service_id | Unknown | PK, FK |
| 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 | PK, FK |
| service_id | Unknown | PK, FK |
| created_at | Unknown |  |

### paused_incident_triggered_after_pause_alert

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| _fivetran_id | Unknown | PK, FK |
| service_id | Unknown | PK, FK |
| 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 | PK, FK |
| name | Unknown |  |
| parameter_type | Unknown |  |
| value | Unknown |  |

### action_output

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| incident_workflow_action_id | Unknown | PK, FK |
| 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 | PK, FK |
| schedule_id | Unknown | PK, FK |

### schedule_users

| Column | Type | Keys |
| --- | --- | --- |
| schedule_id | Unknown | PK, FK |
| user_id | Unknown | PK, FK |

### 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 | PK, FK |

### raw_incident_joined_user_name

| Column | Type | Keys |
| --- | --- | --- |
| joined_user_name | Unknown | PK |
| raw_incident_id | Unknown | PK, FK |

### raw_incident_assigned_user_id

| Column | Type | Keys |
| --- | --- | --- |
| assigned_user_id | Unknown | PK |
| raw_incident_id | Unknown | PK, FK |

### raw_incident_assigned_user_name

| Column | Type | Keys |
| --- | --- | --- |
| assigned_user_name | Unknown | PK |
| raw_incident_id | Unknown | PK, FK |

### raw_incident_acknowledged_user_name

| Column | Type | Keys |
| --- | --- | --- |
| acknowledged_user_name | Unknown | PK |
| raw_incident_id | Unknown | PK, FK |

### raw_incident_acknowledged_user_id

| Column | Type | Keys |
| --- | --- | --- |
| acknowledged_user_id | Unknown | PK |
| raw_incident_id | Unknown | PK, FK |

### 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 | PK, FK |
| team_id | Unknown | PK, FK |
| type | Unknown |  |

### users_notification_subscription

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| users_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| team_id | Unknown | PK, FK |

### 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 | PK, FK |
| 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 | Instant |  |
| 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 | PK, FK |
| 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 | PK, FK |
| team_id | Unknown | PK, FK |

### 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 | PK, FK |
| html_url | Unknown |  |
| summary | Unknown |  |
| type | Unknown |  |

### log_entry_assignee

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| log_entries_id | Unknown | PK, FK |
| 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 |  |

## Relationships

- business_service_subscriber(business_service_id) → business_service(id)
- maintenance_window_service(service_id) → service(id)
- maintenance_window_service(maintenance_window_id) → maintenance_window(id)
- maintenance_window_team(team_id) → team(id)
- maintenance_window_team(maintenance_window_id) → maintenance_window(id)
- maintenance_window(created_by_id) → users(id)
- escalation_policy_target(escalation_policy_rule_id) → escalation_policy_rule(id)
- escalation_policy_rule(escalation_policy_id) → escalation_policy(id)
- escalation_policy_service(service_id) → service(id)
- escalation_policy_service(escalation_policy_id) → escalation_policy(id)
- escalation_policy_team(team_id) → team(id)
- escalation_policy_team(escalation_policy_id) → escalation_policy(id)
- notification(user_id) → users(id)
- incident_custom_field_value(incident_id) → incident(id)
- extension_schema_option(extension_schema_id) → extension_schema(id)
- extension_schema_send_type(extension_schema_id) → extension_schema(id)
- extension_feature(extension_schema_id) → extension_schema(id)
- extension_schema(addon_id) → addon(id)
- ruleset_routing_key(ruleset_id) → ruleset(id)
- ruleset(team_id) → team(id)
- ruleset(updater_id) → users(id)
- ruleset(creator_id) → users(id)
- business_service(team_id) → team(id)
- users_contact_method(users_id) → users(id)
- users_notification_rule(users_id) → users(id)
- users_team(team_id) → team(id)
- users_team(users_id) → users(id)
- license_valid_role(license_id) → license(id)
- incident_note(user_id) → users(id)
- incident_note(incident_id) → incident(id)
- template(updated_by_id) → users(id)
- template(created_by_id) → users(id)
- extension_object(extension_id) → extension(id)
- extension(extension_schema_id) → extension_schema(id)
- on_call(escalation_policy_id) → escalation_policy(id)
- on_call(schedule_id) → schedule(id)
- on_call(user_id) → users(id)
- slack_dedicated_channel(slack_team_id) → team(id)
- slack_dedicated_channel(incident_id) → incident(id)
- audit_record_actor(audit_record_id) → audit_record(id)
- audit_record_field(audit_record_id) → audit_record(id)
- reference_removed(reference_id) → reference(name)
- reference_added(reference_id) → reference(name)
- reference(audit_record_id) → audit_record(id)
- change_event_service(service_id) → service(id)
- change_event_service(change_event_id) → change_event(id)
- paused_incident_resolved_after_pause_alert(service_id) → service(id)
- paused_incident_resolved_after_pause_alert(_fivetran_id) → paused_incident_reporting_alert(_fivetran_id)
- paused_incident_triggered_after_pause_alert(service_id) → service(id)
- paused_incident_triggered_after_pause_alert(_fivetran_id) → paused_incident_reporting_alert(_fivetran_id)
- incident_workflow_team(incident_workflow_id) → incident_workflow(id)
- action_input(incident_workflow_action_id) → incident_workflow_action(id)
- action_output(incident_workflow_action_id) → incident_workflow_action(id)
- incident_workflow_action(incident_workflow_step_id) → incident_workflow_step(id)
- incident_workflow_step(incident_workflow_id) → incident_workflow(id)
- schedule_escalation_policy(escalation_policy_id) → escalation_policy(id)
- schedule_escalation_policy(schedule_id) → schedule(id)
- schedule_users(user_id) → users(id)
- schedule_users(schedule_id) → schedule(id)
- raw_incident_joined_user_id(raw_incident_id) → raw_incident(id)
- raw_incident_joined_user_name(raw_incident_id) → raw_incident(id)
- raw_incident_assigned_user_id(raw_incident_id) → raw_incident(id)
- raw_incident_assigned_user_name(raw_incident_id) → raw_incident(id)
- raw_incident_acknowledged_user_name(raw_incident_id) → raw_incident(id)
- raw_incident_acknowledged_user_id(raw_incident_id) → raw_incident(id)
- raw_incident(escalation_policy_id) → escalation_policy(id)
- raw_incident(resolved_by_user_id) → users(id)
- raw_incident(service_id) → service(id)
- raw_incident(team_id) → team(id)
- tag_entity(team_id) → team(id)
- tag_entity(tags_id) → tags(id)
- users_notification_subscription(users_id) → users(id)
- user_delegation(users_id) → users(id)
- service_team(team_id) → team(id)
- service_team(service_id) → service(id)
- service_days_of_week(service_id) → service(id)
- service_integration(service_id) → service(id)
- service_scheduled_action(service_id) → service(id)
- service(escalation_policy_id) → escalation_policy(id)
- event_orchestration(team_id) → team(id)
- event_orchestration(updated_by_id) → users(id)
- event_orchestration(created_by_id) → users(id)
- users_handoff_notification_rule(users_id) → users(id)
- incident_team(team_id) → team(id)
- incident_team(incident_id) → incident(id)
- incident(escalation_policy_id) → escalation_policy(id)
- incident(service_id) → service(id)
- log_entry_team(log_entries_id) → log_entries(id)
- log_entry_assignee(log_entries_id) → log_entries(id)
- log_entries(escalation_policy_id) → escalation_policy(id)
- log_entries(user_id) → users(id)
- log_entries(service_id) → service(id)
- log_entries(incident_id) → incident(id)
- log_entries(responder_id) → users(id)