incident.io

Explore the interactive ERD

Table & Field Reference

incident_alert

Column	Type	Keys
`id`	Unknown	PK
`alert_id`	Unknown	FK
`alert_route_id`	Unknown	FK
`incident_id`	Unknown	FK
`incident_external_id`	Unknown
`incident_status_category`	Unknown

incident_type

Column	Type	Keys
`id`	Unknown	PK
`create_in_triage`	Unknown
`created_at`	Unknown
`description`	Unknown
`is_default`	Unknown
`name`	Unknown
`private_incidents_only`	Unknown
`updated_at`	Unknown

identity_utility_role

Column	Type	Keys
`identity_utility_name`	Unknown	PK
`index`	Unknown	PK
`identity_utility_role`	Unknown

alert_source_jira_option

Column	Type	Keys
`jira_project_id`	Unknown	PK
`alert_source_id`	Unknown	PKFK

alert_source_attribute

Column	Type	Keys
`alert_attribute_id`	Unknown	PKFK
`alert_source_id`	Unknown	PKFK

alert_source_expression

Column	Type	Keys
`index`	Unknown	PK
`alert_source_id`	Unknown	PKFK
`else_branch_result`	Json
`label`	Unknown
`operations`	Json
`reference`	Unknown
`return_array`	Unknown
`return_type`	Unknown
`root_reference`	Unknown

alert_source

Column	Type	Keys
`id`	Unknown	PK
`description_label`	Unknown
`description_literal`	Unknown
`description_reference`	Unknown
`email_address`	Unknown
`name`	Unknown
`secret_token`	Unknown
`source_type`	Unknown
`title_label`	Unknown
`title_literal`	Unknown
`title_reference`	Unknown

alert_source_attribute_binding_value

Column	Type	Keys
`index`	Unknown	PK
`alert_attribute_id`	Unknown	PKFK
`alert_source_id`	Unknown	PKFK
`label`	Unknown
`literal`	Unknown
`reference`	Unknown

action

Column	Type	Keys
`id`	Unknown	PK
`assignee_id`	Unknown	FK
`incident_id`	Unknown	FK
`completed_at`	Unknown
`created_at`	Unknown
`description`	Unknown
`follow_up`	Unknown
`status`	Unknown
`updated_at`	Unknown

catalog_resource

Column	Type	Keys
`_fivetran_id`	String	PK
`category`	Unknown
`description`	Unknown
`label`	Unknown
`type`	Unknown
`value_docstring`	Unknown

workflow_condition_param_binding

Column	Type	Keys
`index`	Unknown	PK
`workflow_condition_index`	Unknown	PKFK
`workflow_id`	Unknown	PKFK
`array_value`	Json
`value_lable`	Unknown
`value_literal`	Unknown
`value_reference`	Unknown

workflow_condition

Column	Type	Keys
`index`	Unknown	PK
`workflow_id`	Unknown	PKFK
`operation_label`	Unknown
`operation_value`	Unknown
`subject_label`	Unknown
`subject_reference`	Unknown

workflow_once_for

Column	Type	Keys
`key`	Unknown	PK
`workflow_id`	Unknown	PKFK
`is_array`	Unknown
`label`	Unknown
`type`	Unknown

workflow_step

Column	Type	Keys
`index`	Unknown	PK
`workflow_id`	Unknown	PKFK
`label`	Unknown
`name`	Unknown

workflow_expression_array_value

Column	Type	Keys
`index`	Unknown	PK
`workflow_expression_index`	Unknown	PKFK
`workflow_id`	Unknown	PKFK
`label`	Unknown
`literal`	Unknown
`reference`	Unknown

workflow_expression_operation_filter_condition_param_binding

Column	Type	Keys
`index`	Unknown	PK
`workflow_expression_index`	Unknown	PKFK
`workflow_expression_operation_filter_condition_group_index`	Unknown	PKFK
`workflow_expression_operation_index`	Unknown	PKFK
`workflow_id`	Unknown	PKFK
`array_value`	Json
`value_lable`	Unknown
`value_literal`	Unknown
`value_reference`	Unknown

workflow_expression_operation_filter_condition_group

Column	Type	Keys
`index`	Unknown	PK
`workflow_expression_index`	Unknown	PKFK
`workflow_expression_operation_index`	Unknown	PKFK
`workflow_id`	Unknown	PKFK
`operation_label`	Unknown
`operation_value`	Unknown
`subject_label`	Unknown
`subject_reference`	Unknown

workflow_expression_operation_branch_condition_param_binding

Column	Type	Keys
`index`	Unknown	PK
`workflow_expression_index`	Unknown	PKFK
`workflow_expression_operation_branch_condition_index`	Unknown	PKFK
`workflow_expression_operation_branch_index`	Unknown	PKFK
`workflow_expression_operation_index`	Unknown	PKFK
`workflow_id`	Unknown	PKFK
`array_value`	Json
`value_lable`	Unknown
`value_literal`	Unknown
`value_reference`	Unknown

workflow_expression_operation_branch_condition

Column	Type	Keys
`index`	Unknown	PK
`workflow_expression_index`	Unknown	PKFK
`workflow_expression_operation_branch_index`	Unknown	PKFK
`workflow_expression_operation_index`	Unknown	PKFK
`workflow_id`	Unknown	PKFK
`operation_label`	Unknown
`operation_value`	Unknown
`subject_label`	Unknown
`subject_reference`	Unknown

workflow_expression_operation_branch

Column	Type	Keys
`index`	Unknown	PK
`workflow_expression_index`	Unknown	PKFK
`workflow_expression_operation_index`	Unknown	PKFK
`workflow_id`	Unknown	PKFK
`array_value`	Json
`value_label`	Unknown
`value_literal`	Unknown
`value_reference`	Unknown

workflow_expression_operation

Column	Type	Keys
`index`	Unknown	PK
`workflow_expression_index`	Unknown	PKFK
`workflow_id`	Unknown	PKFK
`branch_return_array`	Unknown
`branch_return_type`	Unknown
`navigation_reference`	Unknown
`navigation_reference_label`	Unknown
`operation_type`	Unknown
`parse_return_array`	Unknown
`parse_return_type`	Unknown
`parse_source`	Unknown
`return_array`	Unknown
`return_type`	Unknown

workflow_expression

Column	Type	Keys
`index`	Unknown	PK
`workflow_id`	Unknown	PKFK
`label`	Unknown
`reference`	Unknown
`result_value_label`	Unknown
`result_value_literal`	Unknown
`result_value_reference`	Unknown
`returns_array`	Unknown
`returns_type`	Unknown
`root_reference`	Unknown

workflow

Column	Type	Keys
`id`	Unknown	PK
`continue_on_step_error`	Unknown
`delay_conditions_apply_over`	Unknown
`delay_for_seconds`	Unknown
`folder`	Unknown
`include_private_incident`	Unknown
`name`	Unknown
`runs_from`	Unknown
`runs_on_incident`	Unknown
`runs_on_incident_modes`	Json
`shortform`	Unknown
`state`	Unknown
`tigger_label`	Unknown
`tigger_name`	Unknown
`version`	Unknown

custom_field_option

Column	Type	Keys
`id`	Unknown	PK
`custom_field_id`	Unknown	FK
`sort_key`	Unknown
`value`	Unknown

users

Column	Type	Keys
`id`	Unknown	PK
`email`	Unknown
`name`	Unknown
`role`	Unknown
`slack_user_id`	Unknown

incident_status

Column	Type	Keys
`id`	Unknown	PK
`category`	Unknown
`created_at`	Unknown
`description`	Unknown
`name`	Unknown
`rank`	Unknown
`updated_at`	Unknown

catalog_type_required_integration

Column	Type	Keys
`required_intergration`	Unknown	PK
`catalog_type_id`	Unknown	PKFK

catalog_type_schema_attribute

Column	Type	Keys
`catalog_type_id`	Unknown	PK
`id`	Unknown	PK
`arrays`	Unknown
`mode`	Unknown
`name`	Unknown
`type`	Unknown
`version`	Unknown

catalog_type_annotation

Column	Type	Keys
`name`	Unknown	PK
`catalog_type_id`	Unknown	PKFK
`value`	Unknown

catalog_type

Column	Type	Keys
`id`	Unknown	PK
`color`	Unknown
`created_at`	Unknown
`description`	Unknown
`external_type`	Unknown
`icon`	Unknown
`is_editable`	Unknown
`name`	Unknown
`ranked`	Unknown
`semantic_type`	Unknown
`type_name`	Unknown
`updated_at`	Unknown

catalog_entry_aliases

Column	Type	Keys
`index`	Unknown	PK
`catalog_entry_id`	Unknown	PKFK
`aliases`	Unknown

catalog_entry

Column	Type	Keys
`id`	Unknown	PK
`catalog_type_id`	Unknown	FK
`archived_at`	Unknown
`created_at`	Unknown
`external_id`	Unknown
`name`	Unknown
`rank`	Unknown
`updated_at`	Unknown

catalog_entry_attribute_value

Column	Type	Keys
`_fivetran_id`	String	PK
`attribute_id`	Unknown	FK
`catalog_entry_id`	Unknown	FK
`label`	Unknown
`literal`	Unknown

incident_role

Column	Type	Keys
`id`	Unknown	PK
`created_at`	Unknown
`description`	Unknown
`instructions`	Unknown
`name`	Unknown
`role_type`	Unknown
`shortform`	Unknown
`updated_at`	Unknown

alert_attribute

Column	Type	Keys
`id`	Unknown	PK
`alert_id`	Unknown	PKFK
`is_array`	Unknown
`name`	Unknown
`type`	Unknown

alert

Column	Type	Keys
`id`	Unknown	PK
`alert_source_id`	Unknown	FK
`created_at`	Unknown
`deduplication_key`	Unknown
`description`	Unknown
`resolved_at`	Unknown
`source_url`	Unknown
`status`	Unknown
`title`	Unknown
`updated_at`	Unknown

alert_attribute_value

Column	Type	Keys
`index`	Unknown	PK
`alert_attribute_id`	Unknown	PKFK
`alert_id`	Unknown	PKFK
`catalog_entry_id`	Unknown	FK
`catalog_type_id`	Unknown	FK
`label`	Unknown
`literal`	Unknown

incident_update

Column	Type	Keys
`id`	Unknown	PK
`incident_id`	Unknown	FK
`new_incident_status_id`	Unknown	FK
`new_severity_id`	Unknown	FK
`updater_user_id`	Unknown	FK
`created_at`	Unknown
`message`	Unknown

escalation_path_current_responder

Column	Type	Keys
`escalation_path_id`	Unknown	PKFK
`id`	Unknown	PKFK

escalation_path_team_id

Column	Type	Keys
`index`	Unknown	PK
`escalation_path_id`	Unknown	PKFK
`team_id`	Unknown

escalation_path_working_hour_weekday_interval

Column	Type	Keys
`index`	Unknown	PK
`escalation_path_id`	Unknown	PKFK
`escalation_path_working_hour_id`	Unknown	PKFK
`end_time`	Unknown
`start_time`	Unknown
`weekday`	Unknown

escalation_path_working_hour

Column	Type	Keys
`id`	Unknown	PK
`escalation_path_id`	Unknown	PKFK
`name`	Unknown
`timezone`	Unknown

escalation_path_node_level_target

Column	Type	Keys
`index`	Unknown	PK
`escalation_path_id`	Unknown	PKFK
`escalation_path_node_id`	Unknown	PKFK
`id`	Unknown
`schedule_mode`	Unknown
`selected_rota_id`	Unknown
`type`	Unknown
`urgency`	Unknown

escalation_path_node_notify_channel_target

Column	Type	Keys
`index`	Unknown	PK
`escalation_path_id`	Unknown	PKFK
`escalation_path_node_id`	Unknown	PKFK
`id`	Unknown
`schedule_mode`	Unknown
`selected_rota_id`	Unknown
`type`	Unknown
`urgency`	Unknown

escalation_path_node_if_else_condition_param_binding

Column	Type	Keys
`index`	Unknown	PK
`escalation_path_id`	Unknown	PKFK
`escalation_path_node_id`	Unknown	PKFK
`escalation_path_node_if_else_condition_index`	Unknown	PKFK
`array_value`	Json
`value_label`	Unknown
`value_literal`	Unknown
`value_reference`	Unknown

escalation_path_node_if_else_condition

Column	Type	Keys
`index`	Unknown	PK
`escalation_path_id`	Unknown	PKFK
`escalation_path_node_id`	Unknown	PKFK
`operation_label`	Unknown
`operation_value`	Unknown
`subject_label`	Unknown
`subject_reference`	Unknown

escalation_path_node_if_else_then_path_node_level_target

Column	Type	Keys
`index`	Unknown	PK
`escalation_path_id`	Unknown	PKFK
`escalation_path_node_id`	Unknown	PKFK
`escalation_path_node_if_else_then_path_id`	Unknown	PKFK
`id`	Unknown
`schedule_mode`	Unknown
`selected_rota_id`	Unknown
`type`	Unknown
`urgency`	Unknown

escalation_path_node_if_else_then_path_node_notify_channel_target

Column	Type	Keys
`index`	Unknown	PK
`escalation_path_id`	Unknown	PKFK
`escalation_path_node_id`	Unknown	PKFK
`escalation_path_node_if_else_then_path_id`	Unknown	PKFK
`id`	Unknown
`schedule_mode`	Unknown
`selected_rota_id`	Unknown
`type`	Unknown
`urgency`	Unknown

escalation_path_node_if_else_then_path

Column	Type	Keys
`id`	Unknown	PK
`escalation_path_id`	Unknown	PKFK
`escalation_path_node_id`	Unknown	PKFK
`delay_delay_interval_condition`	Unknown
`delay_delay_seconds`	Unknown
`delay_delay_weekday_interval_config_id`	Unknown
`if_else_conditions`	Json
`if_else_else_path`	Json
`if_else_then_path`	Json
`level_ack_mode`	Unknown
`level_round_robin_config_enabled`	Unknown
`level_round_robin_config_rotate_after_seconds`	Unknown
`level_time_to_ack_interval_condition`	Unknown
`level_time_to_ack_seconds`	Unknown
`level_time_to_ack_weekday_interval_config_id`	Unknown
`notify_channel_time_to_ack_interval_condition`	Unknown
`notify_channel_time_to_ack_seconds`	Unknown
`notify_channel_time_to_ack_weekday_interval_config_id`	Unknown
`repeat_repeat_times`	Unknown
`repeat_to_node`	Unknown
`type`	Unknown

escalation_path_node_if_else_else_path_node_level_target

Column	Type	Keys
`index`	Unknown	PK
`escalation_path_id`	Unknown	PKFK
`escalation_path_node_id`	Unknown	PKFK
`escalation_path_node_if_else_else_path_node_id`	Unknown	PKFK
`id`	Unknown
`schedule_mode`	Unknown
`selected_rota_id`	Unknown
`type`	Unknown
`urgency`	Unknown

escalation_path_node_if_else_else_path_node_notify_channel_target

Column	Type	Keys
`index`	Unknown	PK
`escalation_path_id`	Unknown	PKFK
`escalation_path_node_id`	Unknown	PKFK
`escalation_path_node_if_else_else_path_node_id`	Unknown	PKFK
`id`	Unknown
`schedule_mode`	Unknown
`selected_rota_id`	Unknown
`type`	Unknown
`urgency`	Unknown

escalation_path_node_if_else_else_path_node

Column	Type	Keys
`id`	Unknown	PK
`escalation_path_id`	Unknown	PKFK
`escalation_path_node_id`	Unknown	PKFK
`delay_delay_interval_condition`	Unknown
`delay_delay_seconds`	Unknown
`delay_delay_weekday_interval_config_id`	Unknown
`if_else_conditions`	Json
`if_else_else_path`	Json
`if_else_then_path`	Json
`level_ack_mode`	Unknown
`level_round_robin_config_enabled`	Unknown
`level_round_robin_config_rotate_after_seconds`	Unknown
`level_time_to_ack_interval_condition`	Unknown
`level_time_to_ack_seconds`	Unknown
`level_time_to_ack_weekday_interval_config_id`	Unknown
`notify_channel_time_to_ack_interval_condition`	Unknown
`notify_channel_time_to_ack_seconds`	Unknown
`notify_channel_time_to_ack_weekday_interval_config_id`	Unknown
`repeat_repeat_times`	Unknown
`repeat_to_node`	Unknown
`type`	Unknown

escalation_path_node

Column	Type	Keys
`id`	Unknown	PK
`escalation_path_id`	Unknown	PKFK
`delay_interval_condition`	Unknown
`delay_seconds`	Unknown
`delay_weekday_interval_config_id`	Unknown
`level_ack_mode`	Unknown
`level_round_robin_config_enabled`	Unknown
`level_round_robin_config_rotate_after_seconds`	Unknown
`level_time_to_ack_interval_condition`	Unknown
`level_time_to_ack_seconds`	Unknown
`level_time_to_ack_weekday_interval_config_id`	Unknown
`notify_channel_time_to_ack_interval_condition`	Unknown
`notify_channel_time_to_ack_seconds`	Unknown
`notify_channel_time_to_ack_weekday_interval_config_id`	Unknown
`repeat_repeat_times`	Unknown
`repeat_to_node`	Unknown
`type`	Unknown

escalation_path

Column	Type	Keys
`id`	Unknown	PK
`name`	Unknown
`repeat_config_delay_repeat_on_activity`	Unknown
`repeat_config_repeat_after_seconds`	Unknown

incident_attachment

Column	Type	Keys
`id`	Unknown	PK
`incident_id`	Unknown	FK
`resource_external_id`	Unknown
`resource_permalink`	Unknown
`resource_title`	Unknown
`resource_type`	Unknown

severity

Column	Type	Keys
`id`	Unknown	PK
`created_at`	Unknown
`description`	Unknown
`name`	Unknown
`rank`	Unknown
`updated_at`	Unknown

custom_field

Column	Type	Keys
`id`	Unknown	PK
`catalog_type_id`	Unknown	FK
`created_at`	Unknown
`description`	Unknown
`field_type`	Unknown
`name`	Unknown
`updated_at`	Unknown

incident_timestamp

Column	Type	Keys
`id`	Unknown	PK
`name`	Unknown
`rank`	Unknown

follow_up_incident

Column	Type	Keys
`id`	Unknown	PK
`assignee_id`	Unknown	FK
`incident_id`	Unknown	FK
`completed_at`	Unknown
`created_at`	Unknown
`description`	Unknown
`priority_description`	Unknown
`priority_id`	Unknown
`priority_name`	Unknown
`priority_rank`	Unknown
`status`	Unknown
`title`	Unknown
`updated_at`	Unknown

escalation_event_channel

Column	Type	Keys
`index`	Unknown	PK
`escalation_event_id`	Unknown	PKFK
`escalation_id`	Unknown	PKFK
`microsoft_teams_channel_id`	Unknown
`microsoft_teams_team_id`	Unknown
`slack_channel_id`	Unknown
`slack_team_id`	Unknown

escalation_event_user

Column	Type	Keys
`escalation_event_id`	Unknown	PKFK
`escalation_id`	Unknown	PKFK
`id`	Unknown	PKFK

escalation_event

Column	Type	Keys
`id`	Unknown	PK
`escalation_id`	Unknown	PKFK
`event`	Unknown
`occurred_at`	Unknown
`urgency`	Unknown

escalation_related_alert

Column	Type	Keys
`related_alert_id`	Unknown	PK
`escalation_id`	Unknown	PKFK
`id`	Unknown	FK

escalation_related_incident

Column	Type	Keys
`related_incident_id`	Unknown	PK
`escalation_id`	Unknown	PKFK
`id`	Unknown	FK

escalation

Column	Type	Keys
`id`	Unknown	PK
`creator_alter_id`	Unknown	FK
`creator_user_id`	Unknown	FK
`creator_wrokflow_id`	Unknown	FK
`escalation_path_id`	Unknown	FK
`created_at`	Unknown
`creator_alert_id`	Unknown
`priority_name`	Unknown
`status`	Unknown
`title`	Unknown
`updated_at`	Unknown

alert_route

Column	Type	Keys
`id`	Unknown	PK
`enabled`	Unknown
`name`	Unknown

incident_role_assignment

Column	Type	Keys
`incident_id`	Unknown	PKFK
`incident_role_id`	Unknown	PKFK
`action_assignee_id`	Unknown	FK

incident_timestamp_value

Column	Type	Keys
`incident_id`	Unknown	PKFK
`incident_timestamp_id`	Unknown	PKFK
`value`	Unknown

incident_custom_field_entry_value

Column	Type	Keys
`_fivetran_id`	String	PK
`catalog_entry_id`	String	FK
`custom_field_id`	Unknown	FK
`incident_id`	Unknown	FK
`value_option_id`	Unknown	FK
`value_link`	String
`value_numeric`	String
`value_text`	String

incident

Column	Type	Keys
`id`	Unknown	PK
`creator_user_id`	Unknown	FK
`incident_status_id`	Unknown	FK
`incident_type_id`	Unknown	FK
`severity_id`	Unknown	FK
`call_url`	Unknown
`created_at`	Unknown
`external_issue_reference_issue_name`	Unknown
`external_issue_reference_issue_permalink`	Unknown
`external_issue_reference_provider`	Unknown
`mode`	Unknown
`name`	Unknown
`permalink`	Unknown
`postmortem_document_url`	Unknown
`reference`	Unknown
`slack_channel_id`	Unknown
`slack_channel_name`	Unknown
`slack_team_id`	Unknown
`summary`	Unknown
`updated_at`	Unknown
`visibility`	Unknown
`workload_minutes_late`	Unknown
`workload_minutes_sleeping`	Unknown
`workload_minutes_total`	Unknown
`workload_minutes_working`	Unknown