# Opsgenie schema ERD

Table and field reference for the Fivetran Opsgenie connector.

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

### incident_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| incident_id | Unknown | PK, FK |
| tags | Unknown |  |

### incident_service

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

### alert_responder

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| alert_id | Unknown | PK, FK |
| type | Unknown |  |
| type_id | Unknown |  |

### alert_action

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| alert_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| integration_id | Unknown | FK |
| action | Unknown |  |
| is_success | Unknown |  |
| processed_at | Unknown |  |
| status | Unknown |  |
| success | Unknown |  |

### maintenance_rule

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| maintenance_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| service_incident_id | Unknown | PK, FK |
| expected_value | Unknown |  |
| field | Unknown |  |
| not_ | Unknown |  |
| operation | Unknown |  |

### service_incident_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| service_id | Unknown | PK, FK |
| service_incident_id | Unknown | PK, FK |
| tags | Unknown |  |

### service_incident

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

### role_disallow_right

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| role_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| user_notification_rule_id | Unknown | PK, FK |
| notification_time | Unknown |  |

### user_notification_rule_step

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_id | Unknown | PK, FK |
| user_notification_rule_id | Unknown | PK, FK |
| 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 | PK, FK |
| user_notification_rule_id | Unknown | PK, FK |
| name | Unknown |  |
| type | Unknown |  |

### user_notification_rule

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| user_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| integration_action_info_acknowledge_type | Unknown | PK, FK |
| integration_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| integration_id | Unknown | PK, FK |
| type | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| integration_id | Unknown | PK, FK |
| type | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| integration_id | Unknown | PK, FK |
| type | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| ignored | Json |  |
| version | Unknown |  |

### team_role

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

### team_member

| Column | Type | Keys |
| --- | --- | --- |
| team_id | Unknown | PK, FK |
| user_id | Unknown | PK, FK |
| role | Unknown |  |

### team

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| description | Unknown |  |
| name | Unknown |  |

## Relationships

- team_log(team_id) → team(id)
- incident_responder(id) → team(id)
- incident_responder(incident_id) → incident(id)
- incident_tag(incident_id) → incident(id)
- incident_service(service_id) → service(id)
- incident_service(incident_id) → incident(id)
- alert_tag(alert_id) → alert(id)
- alert_responder(alert_id) → alert(id)
- alert_action(alert_id) → alert(id)
- incident_template(incident_id) → incident(id)
- forwarding_rule(from_user_id) → users(id)
- forwarding_rule(to_user_id) → users(id)
- service(team_id) → team(id)
- schedule_participant(id) → team(id)
- schedule_participant(schedule_id) → schedule_rotation(schedule_id)
- schedule_participant(schedule_rotation_id) → schedule_rotation(id)
- schedule_rotation(schedule_id) → schedule(id)
- schedule(team_id) → team(id)
- incident_request(incident_id) → incident(id)
- incident_request(integration_id) → integration(id)
- maintenance_rule(id) → policy(id)
- maintenance_rule(maintenance_id) → maintenance(id)
- policy_condition(policy_id) → policy(id)
- service_condition(service_incident_id) → service_incident(id)
- service_condition(service_id) → service_incident(service_id)
- service_incident_tag(service_incident_id) → service_incident(id)
- service_incident_tag(service_id) → service_incident(service_id)
- service_incident(service_id) → service(id)
- incident_note(incident_id) → incident(id)
- user_tag(user_id) → users(id)
- users(role_id) → role(id)
- incident_timeline(incident_id) → incident(id)
- heartbeat(team_id) → team(id)
- role_grant_right(role_id) → role(id)
- role_disallow_right(role_id) → role(id)
- routing_condition(team_routing_rule_id) → team_routing_rule(id)
- routing_restriction(team_routing_rule_id) → team_routing_rule(id)
- team_routing_rule(notify_id) → schedule(id)
- team_routing_rule(team_id) → team(id)
- user_notification_rule_time(user_notification_rule_id) → user_notification_rule(id)
- user_notification_rule_time(user_id) → user_notification_rule(user_id)
- user_notification_rule_step(user_notification_rule_id) → user_notification_rule(id)
- user_notification_rule_step(user_id) → user_notification_rule(user_id)
- user_notification_rule_schedule(user_notification_rule_id) → user_notification_rule(id)
- user_notification_rule_schedule(user_id) → user_notification_rule(user_id)
- user_notification_rule(user_id) → users(id)
- escalation_rule(escalation_id) → escalation(id)
- escalation(team_id) → team(id)
- incident_log(incident_id) → incident(id)
- user_contact(id) → users(id)
- user_contact(user_id) → users(id)
- integration_read_only(integration_id) → integration(id)
- integration_action_info_acknowledge_condition(integration_id) → integration_action_info_acknowledge(integration_id)
- integration_action_info_acknowledge_condition(integration_action_info_acknowledge_type) → integration_action_info_acknowledge(type)
- integration_action_info_acknowledge_condition(integration_action_info_acknowledge_index) → integration_action_info_acknowledge(index)
- integration_action_info_acknowledge(integration_id) → integration_action(integration_id)
- integration_action_info_addnote_condition(integration_id) → integration_action_info_addnote(integration_id)
- integration_action_info_addnote_condition(type) → integration_action_info_addnote(type)
- integration_action_info_addnote_condition(integration_action_info_addnote_index) → integration_action_info_addnote(index)
- integration_action_info_addnote(integration_id) → integration_action(integration_id)
- integration_action_info_close_condition(integration_id) → integration_action_info_close(integration_id)
- integration_action_info_close_condition(type) → integration_action_info_close(type)
- integration_action_info_close_condition(integration_action_info_close_index) → integration_action_info_close(index)
- integration_action_info_close(integration_id) → integration_action(integration_id)
- integration_action_create_condition(integration_id) → integration_action_create(integration_id)
- integration_action_create_condition(type) → integration_action_create(type)
- integration_action_create_condition(integration_action_create_index) → integration_action_create(index)
- integration_action_create(integration_id) → integration_action(integration_id)
- integration_action(integration_id) → integration(id)
- team_role(role_id) → role(id)
- team_role(team_id) → team(id)
- team_member(user_id) → users(id)
- team_member(team_id) → team(id)