# Rootly schema ERD

Table and field reference for the Fivetran Rootly connector.

## Table & Field Reference

### incident_type_slack_channel

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| incident_type_id | Unknown | PK, FK |
| name | Unknown |  |

### incident_type_slack_alias

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| incident_type_id | Unknown | PK, FK |
| name | Unknown |  |

### incident_type_notify_email

| Column | Type | Keys |
| --- | --- | --- |
| notify_email | Unknown | PK |
| incident_type_id | Unknown | PK, FK |

### incident_type

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Instant |  |
| description | Unknown |  |
| name | Unknown |  |
| position | Unknown |  |
| slug | Unknown |  |
| updated_at | Unknown |  |

### form_field_position

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| form_field_id | Unknown | FK |
| form | Unknown |  |
| position | Unknown |  |

### feedback

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| incident_id | Unknown | FK |
| anonymous | Unknown |  |
| created_at | Unknown |  |
| feedback | Unknown |  |
| rating | Unknown |  |
| rating_humanized | Unknown |  |
| updated_at | Unknown |  |

### form_field_selection_user

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

### form_field_selection_option

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| form_field_selection_id | Unknown | PK, FK |
| color | Unknown |  |
| created_at | Unknown |  |
| form_field_id | Unknown |  |
| id | Unknown |  |
| is_default | Unknown |  |
| position | Unknown |  |
| updated_at | Unknown |  |
| value | Unknown |  |

### form_field_selection

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| form_field_id | Unknown | FK |
| incident_id | Unknown | FK |
| custom_field_id | Unknown |  |
| description | Unknown |  |
| value | Unknown |  |

### form_field_shown

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| form_field_id | Unknown | PK, FK |
| shown | Unknown |  |

### form_field_required

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| form_field_id | Unknown | PK, FK |
| required | Unknown |  |

### form_field

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Instant |  |
| default_values | Json |  |
| description | Unknown |  |
| enabled | Unknown |  |
| input_kind | Unknown |  |
| kind | Unknown |  |
| name | Unknown |  |
| show_on_incident_details | Unknown |  |
| slug | Unknown |  |
| team_id | Unknown |  |
| updated_at | Instant |  |

### action_item_team

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

### action_item_administrating_team

| Column | Type | Keys |
| --- | --- | --- |
| action_item_id | Unknown | PK, FK |
| administrating_team_id | Unknown | PK, FK |

### action_item_notify_email

| Column | Type | Keys |
| --- | --- | --- |
| notify_email | Unknown | PK |
| action_item_id | Unknown | PK, FK |

### action_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| airtable_record_id | Unknown | FK |
| asana_task_id | Unknown | FK |
| assignee_id | Unknown | FK |
| freshservice_task_id | Unknown | FK |
| freshservice_ticket_id | Unknown | FK |
| github_issue_id | Unknown | FK |
| incident_id | Unknown | FK |
| jira_issue_id | Unknown | FK |
| linear_issue_id | Unknown | FK |
| shortcut_story_id | Unknown | FK |
| shortcut_task_id | Unknown | FK |
| trello_card_id | Unknown | FK |
| zendesk_ticket_id | Unknown | FK |
| assignee_accept_marketing | Unknown |  |
| assignee_accept_terms | Unknown |  |
| assignee_created_through_sso | Unknown |  |
| assignee_current_team_id | Unknown |  |
| assignee_incidents_backfilled_count | Unknown |  |
| assignee_incidents_count | Unknown |  |
| assignee_incidents_example_count | Unknown |  |
| assignee_incidents_normal_count | Unknown |  |
| assignee_incidents_scheduled_count | Unknown |  |
| assignee_incidents_test_count | Unknown |  |
| assignee_last_notification_email_sent_at | Unknown |  |
| assignee_last_seen_at | Unknown |  |
| assignee_onboarding_completed | Unknown |  |
| assignee_profile_photo_id | Unknown |  |
| assignee_scim_uid | Unknown |  |
| assignee_service_user | Unknown |  |
| assignee_session_token | Unknown |  |
| assignee_teams_count | Unknown |  |
| assignee_theme | Unknown |  |
| assignee_time_zone | Unknown |  |
| created_at | Unknown |  |
| deleted_at | Unknown |  |
| description | Unknown |  |
| due_date | Unknown |  |
| kind | Unknown |  |
| priority | Unknown |  |
| short_url | Unknown |  |
| status | Unknown |  |
| summary | Unknown |  |
| updated_at | Unknown |  |
| url | Unknown |  |

### workflow_group

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| expanded | Unknown |  |
| kind | Unknown |  |
| name | Unknown |  |
| position | Unknown |  |
| slug | Unknown |  |

### dashboard

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_id | Unknown | FK |
| auto_refresh | Unknown |  |
| color | Unknown |  |
| created_at | Unknown |  |
| description | Unknown |  |
| icon | Unknown |  |
| name | Unknown |  |
| owner | Unknown |  |
| period | Unknown |  |
| public | Unknown |  |
| range | Unknown |  |
| slug | Unknown |  |
| team_id | Unknown |  |
| updated_at | Unknown |  |

### playbook_severity

| Column | Type | Keys |
| --- | --- | --- |
| playbook_id | Unknown | PK, FK |
| severity_id | Unknown | PK, FK |

### playbook_environment

| Column | Type | Keys |
| --- | --- | --- |
| environment_id | Unknown | PK, FK |
| playbook_id | Unknown | PK, FK |

### playbook_functionality

| Column | Type | Keys |
| --- | --- | --- |
| functionality_id | Unknown | PK, FK |
| playbook_id | Unknown | PK, FK |

### playbook_service

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

### playbook_team

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

### playbook_incident_type

| Column | Type | Keys |
| --- | --- | --- |
| incident_type_id | Unknown | PK, FK |
| playbook_id | Unknown | PK, FK |

### playbook

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_id | Unknown | FK |
| created_at | Unknown |  |
| external_url | Unknown |  |
| summary | Unknown |  |
| title | Unknown |  |
| updated_at | Unknown |  |

### workflow_task_run_output

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| workflow_id | Unknown | PK, FK |
| workflow_run_id | Unknown | PK, FK |
| workflow_task_run_id | Unknown | PK, FK |
| event | Unknown |  |
| timestamps | Unknown |  |

### workflow_task_run

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| workflow_id | Unknown | PK, FK |
| workflow_run_id | Unknown | PK, FK |
| canceled_at | Unknown |  |
| completed_at | Unknown |  |
| created_at | Unknown |  |
| failed_at | Unknown |  |
| position | Unknown |  |
| skip_on_failure | Unknown |  |
| started_at | Unknown |  |
| status | Unknown |  |
| triggered_by | Unknown |  |
| updated_at | Unknown |  |

### workflow_run

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| workflow_id | Unknown | PK, FK |
| action_item_id | Unknown | FK |
| incident_id | Unknown | FK |
| post_mortem_id | Unknown | FK |
| user_id | Unknown | FK |
| alert_id | Unknown |  |
| canceled_at | Unknown |  |
| completed_at | Unknown |  |
| created_at | Unknown |  |
| failed_at | Unknown |  |
| kind | Unknown |  |
| pulse_id | Unknown |  |
| queued_at | Unknown |  |
| started_at | Unknown |  |
| status | Unknown |  |
| status_message | Unknown |  |
| triggered_by | Unknown |  |
| updated_at | Unknown |  |

### workflow_environment

| Column | Type | Keys |
| --- | --- | --- |
| environment_id | Unknown | PK, FK |
| workflow_id | Unknown | PK, FK |

### workflow_severity

| Column | Type | Keys |
| --- | --- | --- |
| severity_id | Unknown | PK, FK |
| workflow_id | Unknown | PK, FK |

### workflow_incident_type

| Column | Type | Keys |
| --- | --- | --- |
| incident_type_id | Unknown | PK, FK |
| workflow_id | Unknown | PK, FK |

### workflow_role

| Column | Type | Keys |
| --- | --- | --- |
| role_id | Unknown | PK, FK |
| workflow_id | Unknown | PK, FK |

### workflow_service

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

### workflow_functionality

| Column | Type | Keys |
| --- | --- | --- |
| functionality_id | Unknown | PK, FK |
| workflow_id | Unknown | PK, FK |

### workflow

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| workflow_group_id | Unknown | FK |
| command | Unknown |  |
| command_feedback_enabled | Unknown |  |
| created_at | Instant |  |
| description | Unknown |  |
| enabled | Unknown |  |
| expanded | Unknown |  |
| incident_condition | Unknown |  |
| incident_condition_acknowledged_at | Unknown |  |
| incident_condition_detected_at | Unknown |  |
| incident_condition_environment | Unknown |  |
| incident_condition_functionality | Unknown |  |
| incident_condition_group | Unknown |  |
| incident_condition_incident_roles | Unknown |  |
| incident_condition_incident_type | Unknown |  |
| incident_condition_kind | Unknown |  |
| incident_condition_mitigated_at | Unknown |  |
| incident_condition_resolved_at | Unknown |  |
| incident_condition_service | Unknown |  |
| incident_condition_severity | Unknown |  |
| incident_condition_started_at | Unknown |  |
| incident_condition_status | Unknown |  |
| incident_condition_summary | Unknown |  |
| incident_condition_visibility | Unknown |  |
| incident_conditional_inactivity | Unknown |  |
| incident_inactivity_duration | Unknown |  |
| name | Unknown |  |
| position | Unknown |  |
| repeat_every_duration | Unknown |  |
| slug | Unknown |  |
| trigger_type | Unknown |  |
| updated_at | Instant |  |
| wait | Unknown |  |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Instant |  |
| email | Unknown |  |
| full_name | Unknown |  |
| full_name_with_team | Unknown |  |
| name | Unknown |  |
| phone | Unknown |  |
| phone_2 | Unknown |  |
| slack_id | Unknown |  |
| updated_at | Unknown |  |

### playbook_task

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| playbook_id | Unknown | FK |
| created_at | Unknown |  |
| description | Unknown |  |
| position | Unknown |  |
| task | Unknown |  |
| updated_at | Unknown |  |

### form_field_option

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| form_field_id | Unknown | FK |
| color | Unknown |  |
| created_at | Unknown |  |
| is_default | Unknown |  |
| position | Unknown |  |
| updated_at | Instant |  |
| value | Unknown |  |

### role

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| allow_multi_user_assignment | Unknown |  |
| created_at | Instant |  |
| description | Unknown |  |
| enabled | Unknown |  |
| name | Unknown |  |
| optional | Unknown |  |
| position | Unknown |  |
| slug | Unknown |  |
| summary | Unknown |  |
| updated_at | Instant |  |

### incident_role

| Column | Type | Keys |
| --- | --- | --- |
| incident_role_assignment_id | Unknown | PK, FK |
| id | Unknown | FK |
| users | Unknown | FK |
| updated_at | Instant |  |

### cause

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Instant |  |
| description | Unknown |  |
| name | Unknown |  |
| position | Unknown |  |
| slug | Unknown |  |
| updated_at | Instant |  |

### functionality_slack_channel

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| functionality_id | Unknown | PK, FK |
| name | Unknown |  |

### functionality_slack_alias

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| functionality_id | Unknown | PK, FK |
| name | Unknown |  |

### functionality_notify_email

| Column | Type | Keys |
| --- | --- | --- |
| notify_email | Unknown | PK |
| functionality_id | Unknown | PK, FK |

### functionality_owner_user

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

### functionality_owner_team

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

### functionality_service_id

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

### functionality_environment

| Column | Type | Keys |
| --- | --- | --- |
| environment_id | Unknown | PK, FK |
| functionality_id | Unknown | PK, FK |

### functionality

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Instant |  |
| description | Unknown |  |
| name | Unknown |  |
| opsgenie_id | Unknown |  |
| pagerduty_id | Unknown |  |
| position | Unknown |  |
| public_description | Unknown |  |
| show_uptime | Unknown |  |
| show_uptime_last_days | Unknown |  |
| slug | Unknown |  |
| status | Unknown |  |
| updated_at | Unknown |  |

### secret

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| hashicorp_vault_mount | Unknown |  |
| hashicorp_vault_path | Unknown |  |
| hashicorp_vault_version | Unknown |  |
| name | Unknown |  |
| secret | Unknown |  |
| updated_at | Unknown |  |

### retrospective_process

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| description | Unknown |  |
| is_default | Unknown |  |
| matching_criteria | Json |  |
| name | Unknown |  |
| updated_at | Instant |  |

### audit

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_id | Unknown | FK |
| created_at | Instant |  |
| event | Unknown |  |
| item_id | Unknown |  |
| item_type | Unknown |  |
| object | Unknown |  |
| object_changes | Unknown |  |
| updated_at | Instant |  |

### dashboard_panel_dataset_operation_rule

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| dashboard_panel_dataset_index | Unknown | PK, FK |
| dashboard_panel_id | Unknown | PK, FK |
| condition | Unknown |  |
| key | Unknown |  |
| operation | Unknown |  |
| value | Unknown |  |

### dashboard_panel_dataset

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| dashboard_panel_id | Unknown | PK, FK |
| aggregate_cumulative | Unknown |  |
| aggregate_key | Unknown |  |
| aggregate_operation | Unknown |  |
| collection | Unknown |  |
| group_by | Unknown |  |
| name | Unknown |  |

### dashboard_panel

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| dashboard_id | Unknown | FK |
| created_at | Unknown |  |
| data | Json |  |
| name | Unknown |  |
| params_display | Unknown |  |
| params_legend | Json |  |
| position_h | Unknown |  |
| position_w | Unknown |  |
| position_x | Unknown |  |
| position_y | Unknown |  |
| updated_at | Unknown |  |

### event

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| incident_id | Unknown | FK |
| created_at | Unknown |  |
| event | Unknown |  |
| event_raw | Unknown |  |
| kind | Unknown |  |
| occurred_at | Unknown |  |
| source | Unknown |  |
| starred_at | Unknown |  |
| updated_at | Unknown |  |
| user_display_name | Unknown |  |
| visibility | Unknown |  |

### severity_slack_channel

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| severity_id | Unknown | PK, FK |
| name | Unknown |  |

### severity_slack_alias

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| severity_id | Unknown | PK, FK |
| name | Unknown |  |

### severity_notify_email

| Column | Type | Keys |
| --- | --- | --- |
| notify_email | Unknown | PK |
| severity_id | Unknown | PK, FK |

### severity

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Instant |  |
| description | Unknown |  |
| name | Unknown |  |
| position | Unknown |  |
| severity | Unknown |  |
| slug | Unknown |  |
| updated_at | Unknown |  |

### post_mortem

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| incident_id | Unknown | FK |
| cancelled_at | Unknown |  |
| content | Unknown |  |
| created_at | Instant |  |
| mitigated_at | Unknown |  |
| published_at | Unknown |  |
| resolved_at | Unknown |  |
| short_url | Unknown |  |
| show_action_items | Unknown |  |
| show_alerts_attached | Unknown |  |
| show_functionalities_impacted | Unknown |  |
| show_groups_impacted | Unknown |  |
| show_services_impacted | Unknown |  |
| show_timeline | Unknown |  |
| show_timeline_action_items | Unknown |  |
| show_timeline_genius | Unknown |  |
| show_timeline_order | Unknown |  |
| show_timeline_starred_only | Unknown |  |
| show_timeline_tasks | Unknown |  |
| show_timeline_trail | Unknown |  |
| started_at | Unknown |  |
| status | Unknown |  |
| title | Unknown |  |
| updated_at | Unknown |  |
| url | Unknown |  |

### retrospective

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| incident_role_id | Unknown | FK |
| retrospective_process_id | Unknown | FK |
| canceled_at | Unknown |  |
| created_at | Unknown |  |
| description | Unknown |  |
| due_after_days | Unknown |  |
| position | Unknown |  |
| skippable | Unknown |  |
| slug | Unknown |  |
| title | Unknown |  |
| updated_at | Instant |  |

### team_slack_channel

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| team_id | Unknown | PK, FK |
| name | Unknown |  |

### team_slack_alias

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| team_id | Unknown | PK, FK |
| name | Unknown |  |

### team_notify_email

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

### team

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Instant |  |
| description | Unknown |  |
| name | Unknown |  |
| opsgenie_id | Unknown |  |
| pagerduty_id | Unknown |  |
| position | Unknown |  |
| slug | Unknown |  |
| updated_at | Unknown |  |

### post_mortem_template

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| content | Unknown |  |
| created_at | Unknown |  |
| format | Unknown |  |
| is_default | Unknown |  |
| name | Unknown |  |
| updated_at | Unknown |  |

### environment_slack_channel

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| environment_id | Unknown | PK, FK |
| name | Unknown |  |

### environment_slack_alias

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| environment_id | Unknown | PK, FK |
| name | Unknown |  |

### environment_notify_email

| Column | Type | Keys |
| --- | --- | --- |
| notify_email | Unknown | PK |
| environment_id | Unknown | PK, FK |

### environment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Instant |  |
| description | Unknown |  |
| name | Unknown |  |
| position | Unknown |  |
| slug | Unknown |  |
| updated_at | Unknown |  |

### service_slack_channel

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| service_id | Unknown | PK, FK |
| name | Unknown |  |

### service_slack_alias

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| service_id | Unknown | PK, FK |
| name | Unknown |  |

### service_owner_user

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

### service_owner_team

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

### service_dependent_id

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

### service_environment

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

### service_notify_email

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

### service

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| backstage_id | Unknown |  |
| created_at | Instant |  |
| description | Unknown |  |
| github_repository_branch | Unknown |  |
| github_repository_name | Unknown |  |
| gitlab_repository_branch | Unknown |  |
| gitlab_repository_name | Unknown |  |
| name | Unknown |  |
| opsgenie_id | Unknown |  |
| pagerduty_id | Unknown |  |
| position | Unknown |  |
| public_description | Unknown |  |
| show_uptime | Unknown |  |
| show_uptime_last_days | Unknown |  |
| slug | Unknown |  |
| status | Unknown |  |
| updated_at | Unknown |  |

### incident_role_assignment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| incident_id | Unknown | PK, FK |

### incident_environment

| Column | Type | Keys |
| --- | --- | --- |
| environment_id | Unknown | PK, FK |
| incident_id | Unknown | PK, FK |

### incident_type_data

| Column | Type | Keys |
| --- | --- | --- |
| incident_id | Unknown | PK, FK |
| incident_type_id | Unknown | PK, FK |

### incident_service

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

### incident_cause

| Column | Type | Keys |
| --- | --- | --- |
| cause_id | Unknown | PK, FK |
| incident_id | Unknown | PK, FK |

### incident_functionality

| Column | Type | Keys |
| --- | --- | --- |
| functionality_id | Unknown | PK, FK |
| incident_id | Unknown | PK, FK |

### incident_team

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

### incident_event

| Column | Type | Keys |
| --- | --- | --- |
| event_id | Unknown | PK, FK |
| incident_id | Unknown | PK, FK |

### incident_action_item

| Column | Type | Keys |
| --- | --- | --- |
| action_item_id | Unknown | PK, FK |
| incident_id | Unknown | PK, FK |

### incident_feedback

| Column | Type | Keys |
| --- | --- | --- |
| feedback_id | Unknown | PK, FK |
| incident_id | Unknown | PK, FK |

### incident_post_mortem

| Column | Type | Keys |
| --- | --- | --- |
| incident_id | Unknown | PK, FK |
| post_mortem_id | Unknown | PK, FK |

### incident

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| cancelled_by | Unknown | FK |
| mitigated_by | Unknown | FK |
| parent_incident_id | Unknown | FK |
| resolved_by | Unknown | FK |
| severity_id | Unknown | FK |
| started_by_id | Unknown | FK |
| user_id | Unknown | FK |
| acknowledged_at | Unknown |  |
| airtable_base_key | Unknown |  |
| airtable_record_id | Unknown |  |
| airtable_record_url | Unknown |  |
| airtable_table_name | Unknown |  |
| asana_task_id | Unknown |  |
| asana_task_url | Unknown |  |
| cancellation_message | Unknown |  |
| cancelled_at | Unknown |  |
| confluence_page_id | Unknown |  |
| confluence_page_url | Unknown |  |
| created_at | Unknown |  |
| datadog_notebook_id | Unknown |  |
| datadog_notebook_url | Unknown |  |
| detected_at | Unknown |  |
| duplicate_incident_id | Unknown |  |
| freshservice_task_id | Unknown |  |
| freshservice_task_url | Unknown |  |
| freshservice_ticket_id | Unknown |  |
| freshservice_ticket_url | Unknown |  |
| github_issue_id | Unknown |  |
| github_issue_url | Unknown |  |
| google_drive_id | Unknown |  |
| google_drive_url | Unknown |  |
| google_meeting_id | Unknown |  |
| google_meeting_url | Unknown |  |
| jira_issue_id | Unknown |  |
| jira_issue_key | Unknown |  |
| jira_issue_url | Unknown |  |
| kind | Unknown |  |
| labels | Json |  |
| linear_issue_id | Unknown |  |
| linear_issue_url | Unknown |  |
| mattermost_channel_id | Unknown |  |
| mattermost_channel_name | Unknown |  |
| mattermost_channel_url | Unknown |  |
| mitigated_at | Unknown |  |
| mitigation_message | Unknown |  |
| opsgenie_alert_id | Unknown |  |
| opsgenie_alert_url | Unknown |  |
| opsgenie_incident_id | Unknown |  |
| opsgenie_incident_url | Unknown |  |
| pagerduty_incident_id | Unknown |  |
| pagerduty_incident_url | Unknown |  |
| private | Unknown |  |
| public_title | Unknown |  |
| quip_page_id | Unknown |  |
| quip_page_url | Unknown |  |
| resolution_message | Unknown |  |
| resolved_at | Unknown |  |
| scheduled_for | Unknown |  |
| scheduled_until | Unknown |  |
| sequential_id | Unknown |  |
| service_now_incident_id | Unknown |  |
| service_now_incident_key | Unknown |  |
| service_now_incident_url | Unknown |  |
| short_url | Unknown |  |
| shortcut_story_id | Unknown |  |
| shortcut_story_url | Unknown |  |
| shortcut_task_id | Unknown |  |
| shortcut_task_url | Unknown |  |
| slack_channel_id | Unknown |  |
| slack_channel_name | Unknown |  |
| slack_channel_short_url | Unknown |  |
| slack_channel_url | Unknown |  |
| slug | Unknown |  |
| source | Unknown |  |
| started_at | Unknown |  |
| status | Unknown |  |
| summary | Unknown |  |
| title | Unknown |  |
| trello_card_id | Unknown |  |
| trello_card_url | Unknown |  |
| updated_at | Instant |  |
| url | Unknown |  |
| victor_ops_incident_id | Unknown |  |
| victor_ops_incident_url | Unknown |  |
| zendesk_ticket_id | Unknown |  |
| zendesk_ticket_url | Unknown |  |
| zoom_meeting_id | Unknown |  |
| zoom_meeting_join_url | Unknown |  |
| zoom_meeting_start_url | Unknown |  |

## Relationships

- incident_type_slack_channel(incident_type_id) → incident_type(id)
- incident_type_slack_alias(incident_type_id) → incident_type(id)
- incident_type_notify_email(incident_type_id) → incident_type(id)
- form_field_position(form_field_id) → form_field(id)
- feedback(incident_id) → incident(id)
- form_field_selection_user(form_field_selection_id) → form_field_selection(id)
- form_field_selection_option(form_field_selection_id) → form_field_selection(id)
- form_field_selection(incident_id) → incident(id)
- form_field_selection(form_field_id) → form_field(id)
- form_field_shown(form_field_id) → form_field(id)
- form_field_required(form_field_id) → form_field(id)
- action_item_team(team_id) → team(id)
- action_item_team(action_item_id) → action_item(id)
- action_item_administrating_team(administrating_team_id) → team(id)
- action_item_administrating_team(action_item_id) → action_item(id)
- action_item_notify_email(action_item_id) → action_item(id)
- action_item(assignee_id) → users(id)
- action_item(freshservice_ticket_id) → incident(freshservice_ticket_id)
- action_item(shortcut_story_id) → incident(shortcut_story_id)
- action_item(github_issue_id) → incident(github_issue_id)
- action_item(trello_card_id) → incident(trello_card_id)
- action_item(jira_issue_id) → incident(jira_issue_id)
- action_item(freshservice_task_id) → incident(freshservice_task_id)
- action_item(incident_id) → incident(id)
- action_item(linear_issue_id) → incident(linear_issue_id)
- action_item(asana_task_id) → incident(asana_task_id)
- action_item(zendesk_ticket_id) → incident(zendesk_ticket_id)
- action_item(airtable_record_id) → incident(airtable_record_id)
- action_item(shortcut_task_id) → incident(shortcut_task_id)
- dashboard(user_id) → users(id)
- playbook_severity(severity_id) → severity(id)
- playbook_severity(playbook_id) → playbook(id)
- playbook_environment(environment_id) → environment(id)
- playbook_environment(playbook_id) → playbook(id)
- playbook_functionality(functionality_id) → functionality(id)
- playbook_functionality(playbook_id) → playbook(id)
- playbook_service(service_id) → service(id)
- playbook_service(playbook_id) → playbook(id)
- playbook_team(team_id) → team(id)
- playbook_team(playbook_id) → playbook(id)
- playbook_incident_type(incident_type_id) → incident_type(id)
- playbook_incident_type(playbook_id) → playbook(id)
- playbook(user_id) → users(id)
- workflow_task_run_output(workflow_run_id) → workflow_task_run(workflow_run_id)
- workflow_task_run_output(workflow_task_run_id) → workflow_task_run(id)
- workflow_task_run_output(workflow_id) → workflow_task_run(workflow_id)
- workflow_task_run(workflow_run_id) → workflow_run(id)
- workflow_task_run(workflow_id) → workflow_run(workflow_id)
- workflow_run(user_id) → users(id)
- workflow_run(action_item_id) → action_item(id)
- workflow_run(post_mortem_id) → post_mortem(id)
- workflow_run(incident_id) → incident(id)
- workflow_run(workflow_id) → workflow(id)
- workflow_environment(environment_id) → environment(id)
- workflow_environment(workflow_id) → workflow(id)
- workflow_severity(severity_id) → severity(id)
- workflow_severity(workflow_id) → workflow(id)
- workflow_incident_type(incident_type_id) → incident_type(id)
- workflow_incident_type(workflow_id) → workflow(id)
- workflow_role(role_id) → role(id)
- workflow_role(workflow_id) → workflow(id)
- workflow_service(service_id) → service(id)
- workflow_service(workflow_id) → workflow(id)
- workflow_functionality(functionality_id) → functionality(id)
- workflow_functionality(workflow_id) → workflow(id)
- workflow(workflow_group_id) → workflow_group(id)
- playbook_task(playbook_id) → playbook(id)
- form_field_option(form_field_id) → form_field(id)
- incident_role(incident_role_assignment_id) → incident_role_assignment(id)
- incident_role(id) → role(id)
- incident_role(users) → users(id)
- functionality_slack_channel(functionality_id) → functionality(id)
- functionality_slack_alias(functionality_id) → functionality(id)
- functionality_notify_email(functionality_id) → functionality(id)
- functionality_owner_user(user_id) → users(id)
- functionality_owner_user(functionality_id) → functionality(id)
- functionality_owner_team(team_id) → team(id)
- functionality_owner_team(functionality_id) → functionality(id)
- functionality_service_id(service_id) → service(id)
- functionality_service_id(functionality_id) → functionality(id)
- functionality_environment(environment_id) → environment(id)
- functionality_environment(functionality_id) → functionality(id)
- audit(user_id) → users(id)
- dashboard_panel_dataset_operation_rule(dashboard_panel_dataset_index) → dashboard_panel_dataset(index)
- dashboard_panel_dataset_operation_rule(dashboard_panel_id) → dashboard_panel_dataset(dashboard_panel_id)
- dashboard_panel_dataset(dashboard_panel_id) → dashboard_panel(id)
- dashboard_panel(dashboard_id) → dashboard(id)
- event(incident_id) → incident(id)
- severity_slack_channel(severity_id) → severity(id)
- severity_slack_alias(severity_id) → severity(id)
- severity_notify_email(severity_id) → severity(id)
- post_mortem(incident_id) → incident(id)
- retrospective(retrospective_process_id) → retrospective_process(id)
- retrospective(incident_role_id) → role(id)
- team_slack_channel(team_id) → team(id)
- team_slack_alias(team_id) → team(id)
- team_notify_email(team_id) → team(id)
- environment_slack_channel(environment_id) → environment(id)
- environment_slack_alias(environment_id) → environment(id)
- environment_notify_email(environment_id) → environment(id)
- service_slack_channel(service_id) → service(id)
- service_slack_alias(service_id) → service(id)
- service_owner_user(user_id) → users(id)
- service_owner_user(service_id) → service(id)
- service_owner_team(team_id) → team(id)
- service_owner_team(service_id) → service(id)
- service_dependent_id(dependent_service_id) → service(id)
- service_dependent_id(service_id) → service(id)
- service_environment(environment_id) → environment(id)
- service_environment(service_id) → service(id)
- service_notify_email(service_id) → service(id)
- incident_role_assignment(incident_id) → incident(id)
- incident_environment(environment_id) → environment(id)
- incident_environment(incident_id) → incident(id)
- incident_type_data(incident_type_id) → incident_type(id)
- incident_type_data(incident_id) → incident(id)
- incident_service(service_id) → service(id)
- incident_service(incident_id) → incident(id)
- incident_cause(cause_id) → cause(id)
- incident_cause(incident_id) → incident(id)
- incident_functionality(functionality_id) → functionality(id)
- incident_functionality(incident_id) → incident(id)
- incident_team(team_id) → team(id)
- incident_team(incident_id) → incident(id)
- incident_event(event_id) → event(id)
- incident_event(incident_id) → incident(id)
- incident_action_item(action_item_id) → action_item(id)
- incident_action_item(incident_id) → incident(id)
- incident_feedback(feedback_id) → feedback(id)
- incident_feedback(incident_id) → incident(id)
- incident_post_mortem(post_mortem_id) → post_mortem(id)
- incident_post_mortem(incident_id) → incident(id)
- incident(user_id) → users(id)
- incident(cancelled_by) → users(id)
- incident(parent_incident_id) → incident(id)
- incident(mitigated_by) → users(id)
- incident(started_by_id) → users(id)
- incident(resolved_by) → users(id)
- incident(severity_id) → severity(id)