# Statuspage schema ERD

Table and field reference for the Fivetran Statuspage connector.

## Table & Field Reference

### template_component

| Column | Type | Keys |
| --- | --- | --- |
| component_id | Unknown | PK, FK |
| template_id | Unknown | PK, FK |

### template

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| page_id | Unknown | FK |
| body | Unknown |  |
| group_id | Unknown |  |
| name | Unknown |  |
| should_send_notifications | Unknown |  |
| should_tweet | Unknown |  |
| title | Unknown |  |
| update_status | Unknown |  |

### metric_provider

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| page_id | Unknown | FK |
| created_at | Unknown |  |
| disabled | Unknown |  |
| last_revalidated_at | Unknown |  |
| metric_base_uri | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |

### component_uptime

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| page_id | Unknown | PK, FK |
| major_outage | Unknown |  |
| name | Unknown |  |
| partial_outage | Unknown |  |
| range_end | LocalDate |  |
| range_start | LocalDate |  |
| related_event_id | Unknown |  |
| uptime_percentage | Unknown |  |
| warnings | Json |  |

### page_access_user

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| page_access_group_id | Unknown | FK |
| page_id | Unknown | FK |
| created_at | Unknown |  |
| email | Unknown |  |
| external_login | Unknown |  |
| updated_at | Unknown |  |

### page_access_group_user

| Column | Type | Keys |
| --- | --- | --- |
| page_access_group_id | Unknown | PK, FK |
| page_access_user_id | Unknown | PK, FK |

### page_access_group_metric

| Column | Type | Keys |
| --- | --- | --- |
| metric_id | Unknown | PK, FK |
| page_access_group_id | Unknown | PK, FK |

### page_access_group_component

| Column | Type | Keys |
| --- | --- | --- |
| component_id | Unknown | PK, FK |
| page_access_group_id | Unknown | PK, FK |

### page_access_group

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| page_id | Unknown | FK |
| created_at | Unknown |  |
| external_identifier | Unknown |  |
| name | Unknown |  |
| updated_at | Unknown |  |

### subscriber_component

| Column | Type | Keys |
| --- | --- | --- |
| component_id | Unknown | PK |
| subscriber_id | Unknown | PK, FK |

### subscriber

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| page_access_user_id | Unknown | FK |
| page_id | Unknown | FK |
| created_at | Instant |  |
| email | Unknown |  |
| endpoint | Unknown |  |
| mode | Unknown |  |
| obfuscated_channel_name | Unknown |  |
| phone_country | Unknown |  |
| phone_number | Unknown |  |
| purge_at | Unknown |  |
| quarantined_at | Unknown |  |
| skip_confirmation_notification | Unknown |  |
| workspace_name | Unknown |  |

### component_group

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| page_id | Unknown | FK |
| created_at | Unknown |  |
| description | Unknown |  |
| name | Unknown |  |
| position | Unknown |  |
| updated_at | Unknown |  |

### page_access_user_metric

| Column | Type | Keys |
| --- | --- | --- |
| metric_id | Unknown | PK, FK |
| page_access_user_id | Unknown | PK, FK |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| email | Unknown |  |
| first_name | Unknown |  |
| last_name | Unknown |  |
| organization | Unknown |  |
| updated_at | Unknown |  |

### page_status_embed_config

| Column | Type | Keys |
| --- | --- | --- |
| page_id | Unknown | PK, FK |
| incident_background_color | Unknown |  |
| incident_text_color | Unknown |  |
| maintenance_background_color | Unknown |  |
| maintenance_text_color | Unknown |  |
| position | Unknown |  |

### component

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| component_group_id | Unknown | FK |
| page_id | Unknown | FK |
| automation_email | Unknown |  |
| created_at | Unknown |  |
| description | Unknown |  |
| is_group | Unknown |  |
| name | Unknown |  |
| only_show_if_degraded | Unknown |  |
| position | Unknown |  |
| showcase | Unknown |  |
| start_date | Unknown |  |
| status | Unknown |  |
| updated_at | Unknown |  |

### unsubscribed_component

| Column | Type | Keys |
| --- | --- | --- |
| component_id | Unknown | PK |
| unsubscribed_id | Unknown | PK, FK |

### unsubscribed

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| page_access_user_id | Unknown | FK |
| page_id | Unknown | FK |
| created_at | Unknown |  |
| email | Unknown |  |
| endpoint | Unknown |  |
| mode | Unknown |  |
| obfuscated_channel_name | Unknown |  |
| phone_country | Unknown |  |
| phone_number | Unknown |  |
| purge_at | Unknown |  |
| quarantined_at | Unknown |  |
| skip_confirmation_notification | Unknown |  |
| workspace_name | Unknown |  |

### metric

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| metrics_provider_id | Unknown | FK |
| page_id | Unknown | FK |
| backfill_percentage | Unknown |  |
| backfilled | Unknown |  |
| created_at | Unknown |  |
| decimal_places | Unknown |  |
| display | Unknown |  |
| last_fetched_at | Unknown |  |
| metric_identifier | Unknown |  |
| most_recent_data_at | Unknown |  |
| name | Unknown |  |
| reference_name | Unknown |  |
| suffix | Unknown |  |
| tooltip_description | Unknown |  |
| updated_at | Unknown |  |
| y_axis_hidden | Unknown |  |
| y_axis_max | Unknown |  |
| y_axis_min | Unknown |  |

### incident_postmortem

| Column | Type | Keys |
| --- | --- | --- |
| incident_id | Unknown | PK, FK |
| body | Unknown |  |
| body_draft | Unknown |  |
| body_draft_updated_at | Unknown |  |
| body_updated_at | Unknown |  |
| created_at | Unknown |  |
| custom_tweet | Unknown |  |
| incident_page_id | Unknown |  |
| notify_subscribers | Unknown |  |
| notify_twitter | Unknown |  |
| preview_key | Unknown |  |
| published_at | Unknown |  |
| updated_at | Unknown |  |

### incident_subscriber_component

| Column | Type | Keys |
| --- | --- | --- |
| component_id | Unknown | PK |
| incident_id | Unknown | PK, FK |
| incident_subscriber_id | Unknown | PK, FK |

### incident_subscriber

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| incident_id | Unknown | PK, FK |
| page_access_user_id | Unknown | FK |
| created_at | Unknown |  |
| email | Unknown |  |
| endpoint | Unknown |  |
| mode | Unknown |  |
| obfuscated_channel_name | Unknown |  |
| phone_country | Unknown |  |
| phone_number | Unknown |  |
| purge_at | Unknown |  |
| quarantined_at | Unknown |  |
| skip_confirmation_notification | Unknown |  |
| workspace_name | Unknown |  |

### user_permission

| Column | Type | Keys |
| --- | --- | --- |
| page_id | Unknown | PK, FK |
| user_id | Unknown | PK, FK |
| incident_manager | Unknown |  |
| maintenance_manager | Unknown |  |
| page_configuration | Unknown |  |

### page

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| activity_score | Unknown |  |
| allow_email_subscribers | Unknown |  |
| allow_incident_subscribers | Unknown |  |
| allow_page_subscribers | Unknown |  |
| allow_rss_atom_feeds | Unknown |  |
| allow_sms_subscribers | Unknown |  |
| allow_webhook_subscribers | Unknown |  |
| branding | Unknown |  |
| city | Unknown |  |
| country | Unknown |  |
| created_at | Unknown |  |
| css_blues | Unknown |  |
| css_body_background_color | Unknown |  |
| css_border_color | Unknown |  |
| css_font_color | Unknown |  |
| css_graph_color | Unknown |  |
| css_greens | Unknown |  |
| css_light_font_color | Unknown |  |
| css_link_color | Unknown |  |
| css_no_data | Unknown |  |
| css_oranges | Unknown |  |
| css_reds | Unknown |  |
| css_yellows | Unknown |  |
| domain | Unknown |  |
| email_logo_normal_url | Unknown |  |
| email_logo_original_url | Unknown |  |
| email_logo_retina_url | Unknown |  |
| email_logo_size | Unknown |  |
| email_logo_updated_at | Unknown |  |
| favicon_logo_size | Unknown |  |
| favicon_logo_updated_at | Unknown |  |
| favicon_logo_url | Unknown |  |
| headline | Unknown |  |
| hero_cover_normal_url | Unknown |  |
| hero_cover_original_url | Unknown |  |
| hero_cover_retina_url | Unknown |  |
| hero_cover_size | Unknown |  |
| hero_cover_updated_at | Unknown |  |
| hidden_from_search | Unknown |  |
| ip_restrictions | Unknown |  |
| name | Unknown |  |
| notifications_email_footer | Unknown |  |
| notifications_from_email | Unknown |  |
| page_description | Unknown |  |
| state | Unknown |  |
| subdomain | Unknown |  |
| support_url | Unknown |  |
| time_zone | Unknown |  |
| transactional_logo_normal_url | Unknown |  |
| transactional_logo_original_url | Unknown |  |
| transactional_logo_retina_url | Unknown |  |
| transactional_logo_size | Unknown |  |
| transactional_logo_updated_at | Unknown |  |
| twitter_logo_size | Unknown |  |
| twitter_logo_updated_at | Unknown |  |
| twitter_logo_url | Unknown |  |
| twitter_username | Unknown |  |
| updated_at | Unknown |  |
| url | Unknown |  |
| viewers_must_be_team_members | Unknown |  |

### page_access_user_component

| Column | Type | Keys |
| --- | --- | --- |
| component_id | Unknown | PK, FK |
| page_access_user_id | Unknown | PK, FK |

### incident_component

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

### incident_update

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| incident_id | Unknown | PK, FK |
| body | Unknown |  |
| created_at | Unknown |  |
| custom_tweet | Unknown |  |
| deliver_notifications | Unknown |  |
| display_at | Unknown |  |
| status | Unknown |  |
| tweet_id | Unknown |  |
| twitter_updated_at | Unknown |  |
| updated_at | Unknown |  |
| wants_twitter_update | Unknown |  |

### incident

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| page_id | Unknown | FK |
| auto_transition_deliver_notifications_at_end | Unknown |  |
| auto_transition_deliver_notifications_at_start | Unknown |  |
| auto_transition_to_maintenance_state | Unknown |  |
| auto_transition_to_operational_state | Unknown |  |
| created_at | Unknown |  |
| impact | Unknown |  |
| impact_override | Unknown |  |
| jira_issue_id | Unknown |  |
| monitoring_at | Unknown |  |
| name | Unknown |  |
| postmortem_body | Unknown |  |
| postmortem_body_last_updated_at | Unknown |  |
| postmortem_ignored | Unknown |  |
| postmortem_notified_subscribers | Unknown |  |
| postmortem_notified_twitter | Unknown |  |
| postmortem_published_at | Unknown |  |
| resolved_at | Unknown |  |
| scheduled_auto_completed | Unknown |  |
| scheduled_auto_in_progress | Unknown |  |
| scheduled_for | Unknown |  |
| scheduled_remind_prior | Unknown |  |
| scheduled_reminded_at | Unknown |  |
| scheduled_until | Unknown |  |
| shortlink | Unknown |  |
| status | Unknown |  |
| updated_at | Unknown |  |

### incident_affected_component

| Column | Type | Keys |
| --- | --- | --- |
| component_id | Unknown | PK, FK |
| incident_id | Unknown | PK, FK |
| incident_update_id | Unknown | PK, FK |
| new_status | Unknown |  |
| old_status | Unknown |  |

## Relationships

- template_component(component_id) → component(id)
- template_component(template_id) → template(id)
- template(page_id) → page(id)
- metric_provider(page_id) → page(id)
- component_uptime(id) → component(id)
- component_uptime(page_id) → page(id)
- page_access_user(page_id) → page(id)
- page_access_user(page_access_group_id) → page_access_group(id)
- page_access_group_user(page_access_user_id) → page_access_user(id)
- page_access_group_user(page_access_group_id) → page_access_group(id)
- page_access_group_metric(metric_id) → metric(id)
- page_access_group_metric(page_access_group_id) → page_access_group(id)
- page_access_group_component(component_id) → component(id)
- page_access_group_component(page_access_group_id) → page_access_group(id)
- page_access_group(page_id) → page(id)
- subscriber_component(subscriber_id) → subscriber(id)
- subscriber(page_access_user_id) → page_access_user(id)
- subscriber(page_id) → page(id)
- component_group(page_id) → page(id)
- page_access_user_metric(metric_id) → metric(id)
- page_access_user_metric(page_access_user_id) → page_access_user(id)
- page_status_embed_config(page_id) → page(id)
- component(component_group_id) → component_group(id)
- component(page_id) → page(id)
- unsubscribed_component(unsubscribed_id) → unsubscribed(id)
- unsubscribed(page_access_user_id) → page_access_user(id)
- unsubscribed(page_id) → page(id)
- metric(metrics_provider_id) → metric_provider(id)
- metric(page_id) → page(id)
- incident_postmortem(incident_id) → incident(id)
- incident_subscriber_component(incident_id) → incident_subscriber(incident_id)
- incident_subscriber_component(incident_subscriber_id) → incident_subscriber(id)
- incident_subscriber(page_access_user_id) → page_access_user(id)
- incident_subscriber(incident_id) → incident(id)
- user_permission(page_id) → page(id)
- user_permission(user_id) → users(id)
- page_access_user_component(component_id) → component(id)
- page_access_user_component(page_access_user_id) → page_access_user(id)
- incident_component(component_id) → component(id)
- incident_component(incident_id) → incident(id)
- incident_update(incident_id) → incident(id)
- incident(page_id) → page(id)
- incident_affected_component(component_id) → component(id)
- incident_affected_component(incident_update_id) → incident_update(id)
- incident_affected_component(incident_id) → incident_update(incident_id)