Opsgenie

Explore the interactive ERD

Table & Field Reference

team_log

Column	Type	Keys
`_fivetran_id`	String	PK
`team_id`	Unknown	FK
`created_date`	Unknown
`log`	Unknown
`owner`	Unknown

incident_responder

Column	Type	Keys
`id`	Unknown	PKFK
`incident_id`	Unknown	PKFK
`type`	Unknown

incident_tag

Column	Type	Keys
`index`	Unknown	PK
`incident_id`	Unknown	PKFK
`tags`	Unknown

incident_service

Column	Type	Keys
`index`	Unknown	PK
`incident_id`	Unknown	PKFK
`service_id`	Unknown	FK

incident

Column	Type	Keys
`id`	Unknown	PK
`created_at`	Unknown
`impact_detect_date`	Unknown
`impact_end_date`	Unknown
`impact_start_date`	Unknown
`message`	Unknown
`priority`	Unknown
`region`	Unknown
`server_name`	Unknown
`status`	Unknown
`tiny_id`	Unknown
`updated_at`	Unknown

alert_tag

Column	Type	Keys
`index`	Unknown	PK
`alert_id`	Unknown	PKFK
`tag_name`	Unknown

alert_responder

Column	Type	Keys
`index`	Unknown	PK
`alert_id`	Unknown	PKFK
`type`	Unknown
`type_id`	Unknown

alert_action

Column	Type	Keys
`index`	Unknown	PK
`alert_id`	Unknown	PKFK
`action`	Unknown

alert

Column	Type	Keys
`id`	Unknown	PK
`acknowledged`	Unknown
`alias`	Unknown
`count`	Unknown
`created_at`	Unknown
`description`	Unknown
`details_region`	Unknown
`details_server_name`	Unknown
`entity`	Unknown
`integration_id`	Unknown
`integration_name`	Unknown
`integration_type`	Unknown
`is_seen`	Unknown
`last_occurred_at`	Unknown
`message`	Unknown
`owner`	Unknown
`priority`	Unknown
`report_ack_time`	Unknown
`report_acknowledged_by`	Unknown
`report_close_time`	Unknown
`report_closed_by`	Unknown
`snoozed`	Unknown
`snoozed_until`	Unknown
`source`	Unknown
`status`	Unknown
`tiny_id`	Unknown
`updated_at`	Instant

incident_template

Column	Type	Keys
`incident_id`	Unknown	PKFK
`description`	Unknown
`details`	Json
`impacted_service`	Json
`message`	Unknown
`name`	Unknown
`priority`	Unknown
`stake_holder_description`	Unknown
`stake_holder_enabled`	Unknown
`stake_holder_message`	Unknown
`tags`	Json

forwarding_rule

Column	Type	Keys
`id`	Unknown	PK
`from_user_id`	Unknown	FK
`to_user_id`	Unknown	FK
`alias`	Unknown
`end_date`	Unknown
`start_date`	Unknown

account

Column	Type	Keys
`_fivetran_id`	String	PK
`is_yearly`	Unknown
`max_user_count`	Unknown
`name`	Unknown
`plan_name`	Unknown
`user_count`	Unknown

service

Column	Type	Keys
`id`	Unknown	PK
`team_id`	Unknown	FK
`description`	Unknown
`is_external`	Unknown
`name`	Unknown
`tags`	Json

schedule_participant

Column	Type	Keys
`_fivetran_id`	String	PK
`id`	Unknown	FK
`schedule_id`	Unknown	FK
`schedule_rotation_id`	Unknown	FK
`type`	Unknown

schedule_rotation

Column	Type	Keys
`id`	Unknown	PK
`schedule_id`	Unknown	PKFK
`end_date`	Unknown
`length`	Unknown
`name`	Unknown
`start_date`	Unknown
`type`	Unknown

schedule

Column	Type	Keys
`id`	Unknown	PK
`team_id`	Unknown	FK
`description`	Unknown
`enabled`	Unknown
`name`	Unknown
`timezone`	Unknown

incident_request

Column	Type	Keys
`incident_id`	Unknown	PKFK
`integration_id`	Unknown	FK
`action`	Unknown
`is_success`	Unknown
`processed_at`	Unknown
`status`	Unknown
`success`	Unknown

maintenance_rule

Column	Type	Keys
`id`	Unknown	PKFK
`maintenance_id`	Unknown	PKFK
`state`	Unknown
`type`	Unknown

maintenance

Column	Type	Keys
`id`	Unknown	PK
`description`	Unknown
`end_date`	Unknown
`start_date`	Unknown
`status`	Unknown
`type`	Unknown

policy_condition

Column	Type	Keys
`field_`	Unknown	PK
`policy_id`	Unknown	PKFK
`expected_value`	Unknown
`not_`	Unknown
`operation`	Unknown
`orders`	Unknown

policy

Column	Type	Keys
`id`	Unknown	PK
`delay_action_duration`	Unknown
`delay_action_option`	Unknown
`delay_action_until_hour`	Unknown
`delay_action_until_minute`	Unknown
`enabled`	Unknown
`filter_type`	Unknown
`name`	Unknown
`policy_description`	Unknown
`suppress`	Unknown
`time_restriction_end_hour`	Unknown
`time_restriction_end_min`	Unknown
`time_restriction_start_hour`	Unknown
`time_restriction_start_min`	Unknown
`time_restriction_type`	Unknown
`type`	Unknown

service_condition

Column	Type	Keys
`index`	Unknown	PK
`service_id`	Unknown	PKFK
`service_incident_id`	Unknown	PKFK
`expected_value`	Unknown
`field`	Unknown
`not_`	Unknown
`operation`	Unknown

service_incident_tag

Column	Type	Keys
`index`	Unknown	PK
`service_id`	Unknown	PKFK
`service_incident_id`	Unknown	PKFK
`tags`	Unknown

service_incident

Column	Type	Keys
`id`	Unknown	PK
`service_id`	Unknown	PKFK
`condition_match_type`	Unknown
`incident_description`	Unknown
`incident_details`	Json
`incident_message`	Unknown
`incident_priority`	Unknown
`orders`	Unknown
`stakeholder_description`	Unknown
`stakeholder_enabled`	Unknown
`stakeholder_message`	Unknown

incident_note

Column	Type	Keys
`_fivetran_id`	String	PK
`incident_id`	Unknown	FK
`created_at`	Unknown
`note`	Unknown
`offsets`	Unknown
`owner`	Unknown

user_tag

Column	Type	Keys
`index`	Unknown	PK
`user_id`	Unknown	PKFK
`tags`	Unknown

users

Column	Type	Keys
`id`	Unknown	PK
`role_id`	Unknown	FK
`blocked`	Unknown
`city`	Unknown
`country`	Unknown
`created_at`	Unknown
`full_name`	Unknown
`line`	Unknown
`locale`	Unknown
`skype_username`	Unknown
`state`	Unknown
`time_zone`	Unknown
`username`	Unknown
`verified`	Unknown
`zip_code`	Unknown
`details_`

incident_timeline

Column	Type	Keys
`id`	Unknown	PK
`incident_id`	Unknown	FK
`actor_name`	Unknown
`actor_type`	Unknown
`description_name`	Unknown
`description_type`	Unknown
`edit_time`	Unknown
`event_time`	Unknown
`groups`	Unknown
`hidden`	Unknown
`last_editname`	Unknown
`last_edittype`	Unknown
`type`	Unknown

heartbeat

Column	Type	Keys
`_fivetran_id`	String	PK
`team_id`	Unknown	FK
`alert_message`	Unknown
`alert_priority`	Unknown
`alert_tag`	Json
`description`	Unknown
`enabled`	Unknown
`interval`	Unknown
`interval_unit`	Unknown
`name`	Unknown

role_grant_right

Column	Type	Keys
`index`	Unknown	PK
`role_id`	Unknown	PKFK
`granted_right`	Unknown

role_disallow_right

Column	Type	Keys
`index`	Unknown	PK
`role_id`	Unknown	PKFK
`disallow_right`	Unknown

role

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

routing_condition

Column	Type	Keys
`index`	Unknown	PK
`team_routing_rule_id`	Unknown	PKFK
`expected_value`	Unknown
`field`	Unknown
`key`	Unknown
`not_`	Unknown
`operation`	Unknown
`order_`	Unknown

routing_restriction

Column	Type	Keys
`index`	Unknown	PK
`team_routing_rule_id`	Unknown	PKFK
`end_day`	Unknown
`end_hour`	Unknown
`end_min`	Unknown
`start_day`	Unknown
`start_hour`	Unknown
`start_min`	Unknown

team_routing_rule

Column	Type	Keys
`id`	Unknown	PK
`notify_id`	Unknown	FK
`team_id`	Unknown	FK
`criteria_type`	Unknown
`is_default`	Unknown
`name`	Unknown
`notify_name`	Unknown
`notify_type`	Unknown
`order_`	Unknown
`time_restriction_type`	Unknown
`timezone`	Unknown

user_notification_rule_time

Column	Type	Keys
`index`	Unknown	PK
`user_id`	Unknown	PKFK
`user_notification_rule_id`	Unknown	PKFK
`notification_time`	Unknown

user_notification_rule_step

Column	Type	Keys
`id`	Unknown	PK
`user_id`	Unknown	PKFK
`user_notification_rule_id`	Unknown	PKFK
`contact_method`	Unknown
`contact_to`	Unknown
`enabled`	Unknown
`parent_name`	Unknown
`send_time`	Unknown
`send_time_unit`	Unknown

user_notification_rule_schedule

Column	Type	Keys
`id`	Unknown	PK
`user_id`	Unknown	PKFK
`user_notification_rule_id`	Unknown	PKFK
`name`	Unknown
`type`	Unknown

user_notification_rule

Column	Type	Keys
`id`	Unknown	PK
`user_id`	Unknown	PKFK
`action_type`	Unknown
`criteria_type`	Unknown
`enabled`	Unknown
`name`	Unknown
`orders`	Unknown
`repeat_enabled`	Unknown
`restriction_end_hour`	Unknown
`restriction_end_min`	Unknown
`restriction_start_hour`	Unknown
`restriction_start_min`	Unknown
`restriction_type`	Unknown

escalation_rule

Column	Type	Keys
`index`	Unknown	PK
`escalation_id`	Unknown	PKFK
`condition`	Unknown
`delay_time`	Unknown
`delay_time_unit`	Unknown
`notify_type`	Unknown
`recipient_id`	Unknown
`recipient_name`	Unknown
`recipient_type`	Unknown

escalation

Column	Type	Keys
`id`	Unknown	PK
`team_id`	Unknown	FK
`close_alert_after_all`	Unknown
`count`	Unknown
`description`	Unknown
`name`	Unknown
`reset_recipient_states`	Unknown
`wait_interval`	Unknown

incident_log

Column	Type	Keys
`_fivetran_id`	String	PK
`incident_id`	Unknown	FK
`created_at`	Unknown
`log`	Unknown
`offsets`	Unknown
`owner`	Unknown
`type`	Unknown

user_contact

Column	Type	Keys
`id`	Unknown	PKFK
`user_id`	Unknown	PKFK
`apply_order`	Unknown
`contact_method`	Unknown
`disabled_reason`	Unknown
`enabled`	Unknown
`to_`	Unknown

integration_read_only

Column	Type	Keys
`index`	Unknown	PK
`integration_id`	Unknown	PKFK
`read_only`	Unknown

integration

Column	Type	Keys
`id`	Unknown	PK
`advanced`	Unknown
`alert_action`	Json
`alert_filter`	Json
`allow_configuration_access`	Unknown
`allow_delete_access`	Unknown
`allow_read_access`	Unknown
`allow_write_access`	Unknown
`custom_priority`	Unknown
`enabled`	Unknown
`extra_property`	Json
`ignore_extra_property_from_payload`	Unknown
`ignore_recipient_from_payload`	Unknown
`ignore_responder_from_payload`	Unknown
`ignore_tag_from_payload`	Unknown
`ignore_team_from_payload`	Unknown
`is_advanced`	Unknown
`is_default_integration`	Unknown
`is_global`	Unknown
`name`	Unknown
`priority`	Unknown
`recipient`	Json
`responder`	Json
`send_alert_action`	Unknown
`suppress_notification`	Unknown
`tags`	Json
`type`	Unknown

integration_action_info_acknowledge_condition

Column	Type	Keys
`index`	Unknown	PK
`integration_action_info_acknowledge_index`	Unknown	PKFK
`integration_action_info_acknowledge_type`	Unknown	PKFK
`integration_id`	Unknown	PKFK
`expected_value`	Unknown
`field`	Unknown
`is_not`	Unknown
`operation`	Unknown

integration_action_info_acknowledge

Column	Type	Keys
`index`	Unknown	PK
`type`	Unknown	PK
`integration_id`	Unknown	PKFK
`alias`	Unknown
`condition_match_type`	Unknown
`id`	Unknown
`name`	Unknown
`note`	Unknown
`orders`	Unknown
`users`	Unknown

integration_action_info_addnote_condition

Column	Type	Keys
`index`	Unknown	PK
`integration_action_info_addnote_index`	Unknown	PKFK
`integration_id`	Unknown	PKFK
`type`	Unknown	PKFK
`expected_value`	Unknown
`field`	Unknown
`is_not`	Unknown
`operation`	Unknown

integration_action_info_addnote

Column	Type	Keys
`index`	Unknown	PK
`type`	Unknown	PK
`integration_id`	Unknown	PKFK
`alias`	Unknown
`condition_match_type`	Unknown
`id`	Unknown
`name`	Unknown
`note`	Unknown
`orders`	Unknown
`users`	Unknown

integration_action_info_close_condition

Column	Type	Keys
`index`	Unknown	PK
`integration_action_info_close_index`	Unknown	PKFK
`integration_id`	Unknown	PKFK
`type`	Unknown	PKFK
`expected_value`	Unknown
`field`	Unknown
`is_not`	Unknown
`operation`	Unknown

integration_action_info_close

Column	Type	Keys
`index`	Unknown	PK
`type`	Unknown	PK
`integration_id`	Unknown	PKFK
`alias`	Unknown
`condition_match_type`	Unknown
`id`	Unknown
`name`	Unknown
`note`	Unknown
`orders`	Unknown
`users`	Unknown

integration_action_create_condition

Column	Type	Keys
`index`	Unknown	PK
`integration_action_create_index`	Unknown	PKFK
`integration_id`	Unknown	PKFK
`type`	Unknown	PKFK
`expected_value`	Unknown
`field`	Unknown
`is_not`	Unknown
`operation`	Unknown

integration_action_create

Column	Type	Keys
`index`	Unknown	PK
`type`	Unknown	PK
`integration_id`	Unknown	PKFK
`alert_action`	Json
`alias`	Unknown
`append_attachment`	Unknown
`condition_match_type`	Unknown
`custom_priority`	Unknown
`description`	Unknown
`entity`	Unknown
`extra_property`	Json
`id`	Unknown
`ignore_alert_action_payload`	Unknown
`ignore_extra_property_payload`	Unknown
`ignore_recipient_payload`	Unknown
`ignore_responder_payload`	Unknown
`ignore_tag_payload`	Unknown
`ignore_team_payload`	Unknown
`message`	Unknown
`name`	Unknown
`note`	Unknown
`orders`	Unknown
`priority`	Unknown
`recipient`	Json
`responder`	Json
`source`	Unknown
`tags`	Json
`users`	Unknown

integration_action

Column	Type	Keys
`integration_id`	Unknown	PKFK
`ignored`	Json
`version`	Unknown

team_role

Column	Type	Keys
`role_id`	Unknown	PKFK
`team_id`	Unknown	PKFK
`name`	Unknown

team_member

Column	Type	Keys
`team_id`	Unknown	PKFK
`user_id`	Unknown	PKFK
`role`	Unknown

team

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