FireHydrant

Explore the interactive ERD

Table & Field Reference

incident_type_template_tag_list

Column	Type	Keys
`index`	Unknown	PK
`incident_type_id`	Unknown	PKFK
`tag_list`	Unknown

incident_type_template_runbook

Column	Type	Keys
`incident_type_id`	Unknown	PKFK
`runbook_id`	Unknown	PKFK

incident_type_template_team

Column	Type	Keys
`incident_type_id`	Unknown	PKFK
`team_id`	Unknown	PKFK

incident_type_template_impact

Column	Type	Keys
`condition_id`	Unknown	PK
`id`	Unknown	PK
`incident_type_id`	Unknown	PKFK
`condition_name`	Unknown
`name`	Unknown
`type`	Unknown

incident_type_template_value_service

Column	Type	Keys
`incident_type_id`	Unknown	PKFK
`service_id`	Unknown	PKFK

incident_type_template_value_functionality

Column	Type	Keys
`functionality_id`	Unknown	PKFK
`incident_type_id`	Unknown	PKFK

incident_type_template_value_environment

Column	Type	Keys
`environment_id`	Unknown	PKFK
`incident_type_id`	Unknown	PKFK

incident_type_template_value_team

Column	Type	Keys
`incident_type_id`	Unknown	PKFK
`team_id`	Unknown	PKFK

incident_type

Column	Type	Keys
`id`	Unknown	PK
`created_at`	Unknown
`name`	Unknown
`template_custom_fields`	Unknown
`template_customer_impact_summary`	Unknown
`template_description`	Unknown
`template_impacts`	Unknown
`template_priority`	Unknown
`template_private_incident`	Unknown
`template_severity`	Unknown
`template_summary`	Unknown
`template_value_runbook`	Json
`updated_at`	Unknown
`template_label_`

incident_tag

Column	Type	Keys
`_fivetran_id`	String	PK
`name`	Unknown

incident_impacted_infrastructure_functionality

Column	Type	Keys
`id`	Unknown	PK
`incident_id`	Unknown	FK
`infrastructure_id`	Unknown
`infrastructure_name`	Unknown
`type`	Unknown

severity_matrix_impact

Column	Type	Keys
`id`	Unknown	PK
`affects_id`	Unknown
`name`	Unknown
`position`	Unknown
`type`	Unknown

incident_impacted_infrastructure_service

Column	Type	Keys
`id`	Unknown	PK
`incident_id`	Unknown	FK
`infrastructure_id`	Unknown
`infrastructure_name`	Unknown
`type`	Unknown

integration_connections

Column	Type	Keys
`id`	Unknown	PKFK
`integration_id`	Unknown	PKFK

integration

Column	Type	Keys
`id`	Unknown	PK
`created_at`	Unknown
`deprecated`	Unknown
`description`	Unknown
`enabled`	Unknown
`installed`	Unknown
`logo_url`	Unknown
`name`	Unknown
`nat_ip`	Unknown
`setup_url`	Unknown
`slug`	Unknown

contributing_factor_conversation

Column	Type	Keys
`id`	Unknown	PK
`contributing_factor_id`	Unknown	PKFK
`channel_name`	Unknown
`comments_url`	Unknown
`field`	Unknown
`resource_class`	Unknown
`resource_id`	Unknown

contributing_factor

Column	Type	Keys
`id`	Unknown	PK
`retrospective_report_id`	Unknown	FK
`created_by_email`	Unknown
`created_by_id`	Unknown
`created_by_name`	Unknown
`created_by_source`	Unknown
`position`	Unknown
`summary`	Unknown

ticket_project_field_map_body_case

Column	Type	Keys
`index`	Unknown	PK
`ticket_project_field_map_body_index`	Unknown	PKFK
`ticket_project_id`	Unknown	PKFK
`external_value`	Unknown
`external_value_attribute`	Unknown
`external_value_presentation`	Unknown
`external_value_type`	Unknown
`logic_`

ticket_project_field_map_body

Column	Type	Keys
`index`	Unknown	PK
`ticket_project_id`	Unknown	PKFK
`else_external_value_attribute`	Unknown
`else_external_value_presentation`	Unknown
`else_external_value_type`	Unknown
`else_external_value_value`	Unknown
`external_field`	Unknown
`external_value`	Unknown
`external_value_attribute`	Unknown
`external_value_presentation`	Unknown
`external_value_type`	Unknown
`strategy`	Unknown
`user_data`	Json

ticket_project

Column	Type	Keys
`id`	Unknown	PK
`config_connection_id`	Unknown
`config_connection_type`	Unknown
`config_details`	Json
`config_id`	Unknown
`config_ticketing_project_id`	Unknown
`config_ticketing_project_name`	Unknown
`connection_slug`	Unknown
`field_map`	Unknown
`field_map_connection_id`	Unknown
`field_map_connection_type`	Unknown
`field_map_id`	Unknown
`field_map_ticketing_project_id`	Unknown
`name`	Unknown
`updated_at`	Unknown

incident_role

Column	Type	Keys
`id`	Unknown	PK
`created_at`	Unknown
`description`	Unknown
`discarded_at`	Unknown
`name`	Unknown
`summary`	Unknown
`updated_at`	Unknown

functionality_service

Column	Type	Keys
`functionality_id`	Unknown	PKFK
`service_id`	Unknown	PKFK

functionality_link

Column	Type	Keys
`id`	Unknown	PK
`functionality_id`	Unknown	PKFK
`href_url`	Unknown
`icon_url`	Unknown
`name`	Unknown

functionality_external_resource

Column	Type	Keys
`connection_id`	Unknown	PK
`functionality_id`	Unknown	PKFK
`connection_name`	Unknown
`connection_type`	Unknown
`created_at`	Unknown
`name`	Unknown
`remote_id`	Unknown
`remote_url`	Unknown
`updated_at`	Unknown

functionality_active_incident

Column	Type	Keys
`index`	Unknown	PK
`functionality_id`	Unknown	PKFK
`active_incident`	Unknown	FK

functionality

Column	Type	Keys
`id`	Unknown	PK
`team_owner_id`	Unknown	FK
`updated_by_id`	Unknown	FK
`alert_on_add`	Unknown
`auto_add_responding_team`	Unknown
`created_at`	Unknown
`description`	Unknown
`labels`	Json
`name`	Unknown
`owner`	Unknown
`slug`	Unknown
`updated_at`	Unknown
`updated_by_source`	Unknown

incident_task

Column	Type	Keys
`id`	Unknown	PK
`incident_id`	Unknown	PKFK
`assignee_email`	Unknown
`assignee_id`	Unknown
`assignee_name`	Unknown
`assignee_source`	Unknown
`created_at`	Unknown
`created_by_email`	Unknown
`created_by_id`	Unknown
`created_by_name`	Unknown
`created_by_source`	Unknown
`description`	Unknown
`state`	Unknown
`title`	Unknown
`updated_at`	Unknown

custom_field

Column	Type	Keys
`id`	Unknown	PK
`description`	Unknown
`display_name`	Unknown
`field_type`	Unknown
`permissible_value`	Unknown
`required`	Unknown
`slug`	Unknown

status_page

Column	Type	Keys
`id`	Unknown	PK
`incident_id`	Unknown	FK
`integration_id`	Unknown	FK
`external_id`	Unknown
`name`	Unknown
`url`	Unknown

team_owned_functionality

Column	Type	Keys
`team_id`	Unknown	PKFK
`team_owned_functionality_id`	Unknown	PKFK

team_owned_service

Column	Type	Keys
`team_id`	Unknown	PKFK
`team_owned_service_id`	Unknown	PKFK

team_functionalitity

Column	Type	Keys
`functionality_id`	Unknown	PKFK
`team_id`	Unknown	PKFK

team_owned_checklist_template_check

Column	Type	Keys
`id`	Unknown	PK
`team_id`	Unknown	PKFK
`team_owned_checklist_template_id`	Unknown	PKFK
`description`	Unknown
`name`	Unknown
`status`	Unknown

team_owned_checklist_template_owner

Column	Type	Keys
`id`	Unknown	PKFK
`team_id`	Unknown	PKFK
`team_owned_checklist_template_id`	Unknown	PKFK

team_owned_checklist_template_connected_service

Column	Type	Keys
`service_id`	Unknown	PKFK
`team_id`	Unknown	PKFK
`team_owned_checklist_template_id`	Unknown	PKFK

team_owned_checklist_template

Column	Type	Keys
`id`	Unknown	PK
`team_id`	Unknown	PKFK
`created_at`	Unknown
`description`	Unknown
`name`	Unknown
`updated_at`	Unknown

team_membership

Column	Type	Keys
`_fivetran_id`	String	PK
`default_incident_role_id`	Unknown	FK
`schedule_id`	Unknown	FK
`team_id`	Unknown	FK
`user_id`	Unknown	FK

team_owned_runbook

Column	Type	Keys
`runbook_id`	Unknown	PKFK
`team_id`	Unknown	PKFK

team_responding_service

Column	Type	Keys
`responding_service_id`	Unknown	PKFK
`team_id`	Unknown	PKFK

team_service

Column	Type	Keys
`service_id`	Unknown	PKFK
`team_id`	Unknown	PKFK

team

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

incident_impacted_infrastructure_environment

Column	Type	Keys
`id`	Unknown	PK
`incident_id`	Unknown	FK
`infrastructure_id`	Unknown
`infrastructure_name`	Unknown
`type`	Unknown

incident_milestone

Column	Type	Keys
`id`	Unknown	PK
`incident_id`	Unknown	PKFK
`created_at`	Unknown
`duration`	Unknown
`is_archived`	Unknown
`occurred_at`	Unknown
`type`	Unknown
`updated_at`	Unknown

incident_tag_list

Column	Type	Keys
`tag_list`	Unknown	PK
`incident_id`	Unknown	PKFK
`is_archived`	Unknown

incident_role_assignment

Column	Type	Keys
`id`	Unknown	PK
`incident_id`	Unknown	PKFK
`incident_role_id`	Unknown	FK
`user_id`	Unknown	FK
`created_at`	Unknown
`is_archived`	Unknown
`status`	Unknown
`updated_at`	Unknown

incident_conference_bridge

Column	Type	Keys
`id`	Unknown	PK
`incident_id`	Unknown	PKFK
`is_archived`	Unknown

incident_impact

Column	Type	Keys
`incident_id`	Unknown	PK
`impact_id`	Unknown	PKFK
`id`	Unknown	FK
`severity_matrix_condition_id`	Unknown	FK
`is_archived`	Unknown

incident_team_assignment

Column	Type	Keys
`id`	Unknown	PK
`incident_id`	Unknown	PKFK
`team_id`	Unknown	FK
`created_at`	Unknown
`is_archived`	Unknown
`status`	Unknown
`updated_at`	Unknown

incident_retro_export

Column	Type	Keys
`retro_export`	Unknown	PK
`incident_id`	Unknown	PKFK
`is_archived`	Unknown

incident_status_page

Column	Type	Keys
`incident_id`	Unknown	PKFK
`status_page_id`	Unknown	PKFK
`is_archived`	Unknown

incident_last_note_status_page

Column	Type	Keys
`incident_id`	Unknown	PKFK
`last_note_status_page_id`	Unknown	PKFK
`integration_id`	Unknown	FK
`is_archived`	Unknown

incident_conference_bridge_attachment

Column	Type	Keys
`attachment`	Unknown	PK
`incident_id`	Unknown	PKFK
`incident_conference_bridge_id`	Unknown	FK
`is_archived`	Unknown

incident_environment

Column	Type	Keys
`environment_id`	Unknown	PKFK
`incident_id`	Unknown	PKFK
`is_archived`	Unknown

incident_last_note_conversation

Column	Type	Keys
`last_note_conversation_id`	Unknown	PK
`incident_id`	Unknown	PKFK
`channel_name`	Unknown
`comments_url`	Unknown
`field`	Unknown
`is_archived`	Unknown
`resource_class`	Unknown
`resource_id`	Unknown

incident_conversation

Column	Type	Keys
`id`	Unknown	PK
`incident_id`	Unknown	PKFK
`channel_name`	Unknown
`comments_url`	Unknown
`field`	Unknown
`is_archived`	Unknown
`resource_class`	Unknown
`resource_id`	Unknown

incident_custom_field

Column	Type	Keys
`id`	Unknown	PK
`incident_id`	Unknown	PKFK
`description`	Unknown
`is_archived`	Unknown
`name`	Unknown
`value_array`	Unknown
`value_string`	Unknown
`value_type`	Unknown

incident_service

Column	Type	Keys
`incident_id`	Unknown	PKFK
`service_id`	Unknown	PKFK
`is_archived`	Unknown

incident_functionality

Column	Type	Keys
`functionality_id`	Unknown	PKFK
`incident_id`	Unknown	PKFK
`is_archived`	Unknown

incident_ticket

Column	Type	Keys
`incident_id`	Unknown	PKFK
`ticket_id`	Unknown	PKFK
`is_archived`	Unknown

incident_impact_conversation

Column	Type	Keys
`id`	Unknown	PK
`incident_id`	Unknown	PKFK
`incident_impact_id`	Unknown	PKFK
`channel_name`	Unknown
`comments_url`	Unknown
`field`	Unknown
`is_archived`	Unknown
`resource_class`	Unknown
`resource_id`	Unknown

incident

Column	Type	Keys
`id`	Unknown	PK
`created_by_id`	Unknown	FK
`severity_condition_id`	Unknown	FK
`ticket_created_by_id`	Unknown	FK
`ticket_id`	Unknown	FK
`active`	Unknown
`channel_id`	Unknown
`channel_name`	Unknown
`channel_reference`	Unknown
`channel_status`	Unknown
`context_object_description`	Unknown
`context_object_id`	Unknown
`context_object_tag`	Unknown
`context_object_type`	Unknown
`created_at`	Unknown
`created_by_source`	Unknown
`current_milestone`	Unknown
`customer_impact_summary`	Unknown
`customers_impacted`	Unknown
`description`	Unknown
`discarded_at`	Unknown
`incident_url`	Unknown
`is_archived`	Unknown
`last_note_body`	Unknown
`last_note_conversations`	Unknown
`last_note_created_at`	Unknown
`last_note_id`	Unknown
`last_update`	Unknown
`link_deletable`	Unknown
`link_display_text`	Unknown
`link_editable`	Unknown
`link_href_url`	Unknown
`link_icon_url`	Unknown
`link_id`	Unknown
`link_type`	Unknown
`monetary_impact`	Unknown
`monetary_impact_cents`	Unknown
`name`	Unknown
`number`	Unknown
`organization_id`	Unknown
`organization_name`	Unknown
`priority`	Unknown
`private_id`	Unknown
`private_status_page_url`	Unknown
`report_id`	Unknown
`restricted`	Unknown
`severity`	Unknown
`severity_color`	Unknown
`severity_condition`	Unknown
`severity_impact`	Unknown
`severity_impact_object_affects_id`	Unknown
`severity_impact_object_id`	Unknown
`severity_impact_object_name`	Unknown
`severity_impact_object_position`	Unknown
`severity_impact_object_type`	Unknown
`started_at`	Unknown
`summary`	Unknown
`ticket_created_by_source`	Unknown

incident_channel

Column	Type	Keys
`incident_id`	Unknown	PK
`id`	Unknown	PKFK
`icon_url`	Unknown
`is_archived`	Unknown
`name`	Unknown
`source`	Unknown
`source_id`	Unknown
`source_name`	Unknown
`status`	Unknown
`url`	Unknown

incident_change_event_attachment

Column	Type	Keys
`change_event_attachment`	Unknown	PK
`incident_id`	Unknown	PKFK
`related_change_on_incident_id`	Unknown	PKFK

incident_change_event_environment

Column	Type	Keys
`environment_id`	Unknown	PKFK
`incident_id`	Unknown	PKFK
`related_change_on_incident_id`	Unknown	PKFK

incident_event_related_change

Column	Type	Keys
`id`	Unknown	PK
`incident_id`	Unknown	PKFK
`related_change_on_incident_id`	Unknown	PKFK
`created_at`	Unknown
`description`	Unknown
`summary`	Unknown
`updated_at`	Unknown
`label_`

incident_change_event_identity

Column	Type	Keys
`id`	Unknown	PK
`incident_id`	Unknown	PKFK
`related_change_on_incident_id`	Unknown	PKFK
`change_id`	Unknown
`created_at`	Unknown
`type`	Unknown
`updated_at`	Unknown
`value`	Unknown

incident_change_event_author

Column	Type	Keys
`id`	Unknown	PK
`incident_id`	Unknown	PKFK
`related_change_on_incident_id`	Unknown	PKFK
`email`	Unknown
`name`	Unknown
`source`	Unknown

incident_change_event_service

Column	Type	Keys
`incident_id`	Unknown	PKFK
`related_change_on_incident_id`	Unknown	PKFK
`service_id`	Unknown	PKFK

related_change_on_incident

Column	Type	Keys
`id`	Unknown	PK
`incident_id`	Unknown	PKFK
`change_event_id`	Unknown
`created_at`	Unknown
`created_by_email`	Unknown
`created_by_id`	Unknown
`created_by_name`	Unknown
`created_by_source`	Unknown
`type`	Unknown
`updated_at`	Unknown
`why`	Unknown
`change_event_label_`

incident_alert_environment

Column	Type	Keys
`environment_id`	Unknown	PKFK
`incident_alert_id`	Unknown	PKFK

incident_alert_service

Column	Type	Keys
`incident_alert_id`	Unknown	PKFK
`service_id`	Unknown	PKFK

incident_alert

Column	Type	Keys
`id`	Unknown	PK
`alert_signal_rule_team_id`	Unknown	FK
`alert_team_id`	Unknown	FK
`incident_id`	Unknown	FK
`alert_description`	Unknown
`alert_duration_iso_8601`	Unknown
`alert_duration_ms`	Unknown
`alert_ends_at`	Unknown
`alert_id`	Unknown
`alert_integration_name`	Unknown
`alert_priority`	Unknown
`alert_remote_id`	Unknown
`alert_remote_url`	Unknown
`alert_signal_id`	Unknown
`alert_signal_rule`	Unknown
`alert_signal_rule_created_at`	Unknown
`alert_signal_rule_created_by`	Unknown
`alert_signal_rule_created_by_email`	Unknown
`alert_signal_rule_created_by_id`	Unknown
`alert_signal_rule_created_by_name`	Unknown
`alert_signal_rule_created_by_source`	Unknown
`alert_signal_rule_expression`	Unknown
`alert_signal_rule_id`	Unknown
`alert_signal_rule_name`	Unknown
`alert_signal_rule_target_id`	Unknown
`alert_signal_rule_target_name`	Unknown
`alert_signal_rule_target_type`	Unknown
`alert_signal_rule_updated_at`	Unknown
`alert_source_icon`	Unknown
`alert_starts_at`	Unknown
`alert_status`	Unknown
`alert_summary`	Unknown
`alert_team_name`	Unknown
`primarys`	Unknown
`label_`

incident_event_conversation

Column	Type	Keys
`id`	Unknown	PK
`incident_event_id`	Unknown	PKFK
`channel_name`	Unknown
`comments_url`	Unknown
`field`	Unknown
`resource_class`	Unknown
`resource_id`	Unknown

incident_event

Column	Type	Keys
`id`	Unknown	PK
`incident_id`	Unknown	FK
`author_email`	Unknown
`author_id`	Unknown
`author_name`	Unknown
`author_source`	Unknown
`context`	Unknown
`data_body`	Unknown
`data_body_replaced`	Unknown
`occurred_at`	Unknown
`type`	Unknown
`visibility`	Unknown
`vote_disliked`	Unknown
`vote_dislikes`	Unknown
`vote_liked`	Unknown
`vote_likes`	Unknown
`voted`	Unknown

runbook_step_action_element_option

Column	Type	Keys
`index`	Unknown	PK
`runbook_id`	Unknown	PKFK
`label`	Unknown
`value`	Unknown

runbook_step_action_supported_type

Column	Type	Keys
`index`	Unknown	PK
`runbook_id`	Unknown	PKFK
`supported_runbook_type`	Unknown

runbooks_attachment_rule_user_data_value

Column	Type	Keys
`type`	Unknown	PK
`runbook_id`	Unknown	PKFK
`label`	Unknown
`value`	Json

runbook

Column	Type	Keys
`id`	Unknown	PK
`step_action_integration_id`	Unknown	FK
`team_owner_id`	Unknown	FK
`attachment_rule_logic`	Json
`auto_attach_to_restricted_incidents`	Unknown
`created_at`	Unknown
`created_by_email`	Unknown
`created_by_id`	Unknown
`created_by_name`	Unknown
`created_by_source`	Unknown
`description`	Unknown
`is_editable`	Unknown
`name`	Unknown
`owner`	Unknown
`runbook_template_id`	Unknown
`step_action_automatable`	Unknown
`step_action_config_documentation_url`	Unknown
`step_action_config_element_id`	Unknown
`step_action_config_element_markdown_text`	Unknown
`step_action_config_element_plain_text`	Unknown
`step_action_config_element_text_area_default_value`	Unknown
`step_action_config_element_text_area_label`	Unknown
`step_action_config_element_text_area_placeholder`	Unknown
`step_action_config_element_type`	Unknown
`step_action_created_at`	Unknown
`step_action_default_logic`	Json
`step_action_default_rule_data`	Json
`step_action_description`	Unknown
`step_action_id`	Unknown
`step_action_name`	Unknown
`step_action_repeatable`	Unknown
`step_action_slug`	Unknown
`step_action_updated_at`	Unknown
`step_elements`	Json
`step_rule_logic`	Unknown
`step_vote_disliked`	Unknown
`step_vote_dislikes`	Unknown
`step_vote_liked`	Unknown
`step_vote_likes`	Unknown
`step_voted`	Unknown
`steps_action_config_elements_dynamic_select_async_url`	Unknown
`steps_action_config_elements_dynamic_select_clearable`	Unknown
`steps_action_config_elements_dynamic_select_default_value_label`	Unknown
`steps_action_config_elements_dynamic_select_default_value_value`	Unknown
`steps_action_config_elements_dynamic_select_is_multi`	Unknown
`steps_action_config_elements_dynamic_select_label`	Unknown
`steps_action_config_elements_dynamic_select_placeholder`	Unknown
`steps_action_config_elements_dynamic_select_required`	Unknown
`steps_action_config_elements_input_default_value`	Unknown
`steps_action_config_elements_input_label`	Unknown
`steps_action_config_elements_input_placeholder`	Unknown
`steps_action_config_elements_input_required`	Unknown
`steps_action_elements`	Json
`steps_action_id`	Unknown
`steps_automatic`	Unknown
`steps_delay_duration`	Unknown
`steps_id`	Unknown
`steps_name`	Unknown
`steps_repeat`	Unknown
`steps_repeat_duration`	Unknown
`steps_rule_user_data_label`	Unknown
`steps_rule_user_data_type`	Unknown
`steps_rule_user_data_value`	Unknown
`summary`	Unknown
`type`	Unknown
`updated_at`	Unknown
`updated_by_email`	Unknown
`updated_by_id`	Unknown
`updated_by_name`	Unknown
`updated_by_source`	Unknown
`vote_disliked`	Unknown
`vote_dislikes`	Unknown
`vote_liked`	Unknown
`vote_likes`	Unknown
`voted`	Unknown
`steps_config_`

entitlement_error

Column	Type	Keys
`index`	Unknown	PK
`entitlement_id`	Unknown	PKFK
`entitlement_tier`	Unknown	PKFK
`error`	Unknown

entitlement

Column	Type	Keys
`id`	Unknown	PK
`tier`	Unknown	PK
`available`	Unknown
`current_count`	Unknown
`exists`	Unknown
`maximum`	Unknown
`name`	Unknown

users

Column	Type	Keys
`id`	Unknown	PK
`created_at`	Unknown
`email`	Unknown
`name`	Unknown
`slack_linked`	Unknown
`slack_user_id`	Unknown
`updated_at`	Unknown

severity_matrix_condition

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

scheduled_maintenance_status_page

Column	Type	Keys
`scheduled_maintenance_id`	Unknown	PKFK
`status_page_id`	Unknown	PKFK
`integration_id`	Unknown	FK

scheduled_maintenance_impact

Column	Type	Keys
`id`	Unknown	PK
`scheduled_maintenance_id`	Unknown	PKFK
`condition_id`	Unknown	FK
`impact_id`	Unknown
`impact_name`	Unknown
`type`	Unknown

scheduled_maintenance

Column	Type	Keys
`id`	Unknown	PK
`incident_id`	Unknown	FK
`created_at`	Unknown
`description`	Unknown
`ends_at`	Unknown
`name`	Unknown
`starts_at`	Unknown
`summary`	Unknown
`updated_at`	Unknown
`label_`

incident_metric_bucket

Column	Type	Keys
`ends_at`	Unknown	PK
`starts_at`	Unknown	PK
`metrics_total_count`	Unknown
`metrics_total_mtta`	Unknown
`metrics_total_mttd`	Unknown
`metrics_total_mttm`	Unknown
`metrics_total_mttr`	Unknown
`metrics_total_total_time`	Unknown

integration_connection_detail_allowed_modal_field

Column	Type	Keys
`index`	Unknown	PK
`integration_connection_id`	Unknown	PKFK
`allowed_modal_field`	Unknown

integration_connection

Column	Type	Keys
`id`	Unknown	PK
`integration_id`	Unknown	FK
`authorized_by`	Unknown
`authorized_by_id`	Unknown
`configuration_url`	Unknown
`created_at`	Unknown
`default_authorized_actor_email`	Unknown
`default_authorized_actor_id`	Unknown
`default_authorized_actor_name`	Unknown
`default_authorized_actor_source`	Unknown
`detail_alerts_channel_name`	Unknown
`detail_allowed_modal_fields`	Unknown
`detail_default_workspace_id`	Unknown
`detail_default_workspace_name`	Unknown
`detail_follow_up_event_emojis`	Unknown
`detail_modal_fields`	Unknown
`detail_new_incident_view_type`	Unknown
`detail_starred_confirmation`	Unknown
`detail_starred_event_emojis`	Unknown
`detail_task_event_emojis`	Unknown
`detail_team_domain`	Unknown
`detail_thread_broadcast`	Unknown
`detail_tutorial_enabled`	Unknown
`display_name`	Unknown
`integration_slug`	Unknown
`updated_at`	Unknown

incident_impacted_infrastructure_customer

Column	Type	Keys
`id`	Unknown	PK
`incident_id`	Unknown	FK
`infrastructure_id`	Unknown
`infrastructure_name`	Unknown
`type`	Unknown

retrospective_report_field

Column	Type	Keys
`index`	Unknown	PK
`retrospective_report_id`	Unknown	PKFK
`help_text`	Unknown
`id`	Unknown
`is_required`	Unknown
`label`	Unknown
`permissible_values`	Json
`required_at_milestone_id`	Unknown
`retrospective_field_id`	Unknown
`schema`	Json
`type`	Unknown
`value`	Unknown

retrospective_report_section

Column	Type	Keys
`index`	Unknown	PK
`retrospective_report_id`	Unknown	PKFK
`elements`	Json
`slug`	Unknown

retrospective_report

Column	Type	Keys
`id`	Unknown	PK
`description`	Unknown
`exports`	Json
`is_hidden`	Unknown
`name`	Unknown
`retrospective_template_id`	Unknown

user_metric_bucket

Column	Type	Keys
`ends_at`	Unknown	PK
`starts_at`	Unknown	PK
`metrics_total_incident_count`	Unknown
`metrics_total_time_spent`	Unknown
`metrics_total_user_count`	Unknown

severity

Column	Type	Keys
`_fivetran_id`	String	PK
`color`	Unknown
`created_at`	Unknown
`description`	Unknown
`position`	Unknown
`slug`	Unknown
`system_record`	Unknown
`type`	Unknown
`updated_at`	Unknown

ticket_tag_list

Column	Type	Keys
`index`	Unknown	PK
`ticket_id`	Unknown	PKFK
`tag_list`	Unknown

ticket_assignee

Column	Type	Keys
`id`	Unknown	PK
`ticket_id`	Unknown	PKFK
`email`	Unknown
`name`	Unknown
`source`	Unknown

ticket_attachment

Column	Type	Keys
`id`	Unknown	PK
`ticket_id`	Unknown	PKFK
`deletable`	Unknown
`display_text`	Unknown
`editable`	Unknown
`href_url`	Unknown
`icon_url`	Unknown
`type`	Unknown

ticket

Column	Type	Keys
`id`	Unknown	PK
`incident_id`	Unknown	FK
`created_at`	Unknown
`created_by_email`	Unknown
`created_by_id`	Unknown
`created_by_name`	Unknown
`created_by_source`	Unknown
`description`	Unknown
`link_deletable`	Unknown
`link_display_text`	Unknown
`link_editable`	Unknown
`link_href_url`	Unknown
`link_icon_url`	Unknown
`link_id`	Unknown
`link_type`	Unknown
`priority_created_at`	Unknown
`priority_id`	Unknown
`priority_name`	Unknown
`priority_position`	Unknown
`priority_updated_at`	Unknown
`state`	Unknown
`summary`	Unknown
`tag_list`	Json
`task_id`	Unknown
`type`	Unknown
`updated_at`	Unknown

schedule

Column	Type	Keys
`id`	Unknown	PK
`integration_name`	Unknown	FK
`discarded`	Unknown
`name`	Unknown

environment_active_incident

Column	Type	Keys
`index`	Unknown	PK
`environment_id`	Unknown	PKFK
`active_incident`	Unknown	FK

environment_external_resource

Column	Type	Keys
`index`	Unknown	PK
`environment_id`	Unknown	PKFK
`connection_id`	Unknown
`connection_name`	Unknown
`connection_type`	Unknown
`created_at`	Unknown
`name`	Unknown
`remote_id`	Unknown
`remote_url`	Unknown
`updated_at`	Unknown

environment

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

service_active_incident

Column	Type	Keys
`index`	Unknown	PK
`service_id`	Unknown	PKFK
`active_incident`	Unknown

service_external_resource

Column	Type	Keys
`connection_id`	Unknown	PK
`service_id`	Unknown	PKFK
`connection_name`	Unknown
`connection_type`	Unknown
`created_at`	Unknown
`name`	Unknown
`remote_id`	Unknown
`remote_url`	Unknown
`updated_at`	Unknown

service_functionality

Column	Type	Keys
`functionality_id`	Unknown	PKFK
`service_id`	Unknown	FK

service_checklist_check

Column	Type	Keys
`id`	Unknown	PK
`service_checklist_id`	Unknown	PKFK
`service_id`	Unknown	PKFK
`description`	Unknown
`name`	Unknown
`status`	Unknown

service_checklist_owner

Column	Type	Keys
`service_checklist_id`	Unknown	PKFK
`service_id`	Unknown	PKFK
`team_id`	Unknown	PKFK

checklist_connected_service

Column	Type	Keys
`id`	Unknown	PKFK
`service_checklist_id`	Unknown	PKFK
`service_id`	Unknown	PKFK

service_checklist

Column	Type	Keys
`id`	Unknown	PK
`service_id`	Unknown	PKFK
`created_at`	Unknown
`description`	Unknown
`name`	Unknown
`updated_at`	Unknown

service_allowed_param

Column	Type	Keys
`index`	Unknown	PK
`service_id`	Unknown	PKFK
`allowed_param`	Unknown

service_link

Column	Type	Keys
`id`	Unknown	PK
`service_id`	Unknown	PKFK
`href_url`	Unknown
`icon_url`	Unknown
`name`	Unknown

service_last_import_error

Column	Type	Keys
`id`	Unknown	PK
`service_id`	Unknown	PKFK
`created_at`	Unknown
`data`	Json
`message`	Unknown
`resource_id`	Unknown
`resource_name`	Unknown
`resource_type`	Unknown

service

Column	Type	Keys
`id`	Unknown	PK
`team_owner_id`	Unknown	FK
`updated_by_id`	Unknown	FK
`alert_on_add`	Unknown
`auto_add_responding_team`	Unknown
`completed_checks`	Unknown
`created_at`	Unknown
`description`	Unknown
`label_lacework_service_owner`	Unknown
`label_lifecycle`	Unknown
`label_tags`	Unknown
`label_type`	Unknown
`last_import_remote_id`	Unknown
`last_import_state`	Unknown
`last_imported_at`	Unknown
`managed_by`	Unknown
`managed_by_setting_format`	Unknown
`managed_by_setting_target`	Json
`name`	Unknown
`service_checklist_updated_at`	Unknown
`service_tier`	Unknown
`slug`	Unknown
`updated_at`	Unknown
`updated_by_source`	Unknown