Statuspage
Explore the interactive ERD
Table & Field Reference
template_component
| Column | Type | Keys |
|---|---|---|
component_id | Unknown | PKFK |
template_id | Unknown | PKFK |
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 | PKFK |
page_id | Unknown | PKFK |
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 | PKFK |
page_access_user_id | Unknown | PKFK |
page_access_group_metric
| Column | Type | Keys |
|---|---|---|
metric_id | Unknown | PKFK |
page_access_group_id | Unknown | PKFK |
page_access_group_component
| Column | Type | Keys |
|---|---|---|
component_id | Unknown | PKFK |
page_access_group_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
page_access_user_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
incident_subscriber_id | Unknown | PKFK |
incident_subscriber
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
incident_id | Unknown | PKFK |
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 | PKFK |
user_id | Unknown | PKFK |
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 | PKFK |
page_access_user_id | Unknown | PKFK |
incident_component
| Column | Type | Keys |
|---|---|---|
component_id | Unknown | PKFK |
incident_id | Unknown | PKFK |
incident_update
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
incident_id | Unknown | PKFK |
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 | PKFK |
incident_id | Unknown | PKFK |
incident_update_id | Unknown | PKFK |
new_status | Unknown | |
old_status | Unknown |