logo
ExamplesEditorPricingDocs
37.1kSign in

Status page & incident communication database schema

How a public status page is modelled: a component hierarchy with status history, incidents and severities, the timestamped public timeline, scheduled maintenance windows, email and webhook subscribers with delivery tracking, uptime samples, computed uptime and postmortems.

Status Page ER diagram

Status page & incident communication database schema n1 n1 n1 n1 n1 n1 n1 n1 n1 11 n1 n1 n1 n1 n1 n1 components idBIGINT parent_idBIGINT slugVARCHAR nameVARCHAR descriptionVARCHAR is_groupBOOLEAN display_orderSMALLINT current_statusVARCHAR status_changed_atTIMESTAMPTZ is_publicBOOLEAN show_uptimeBOOLEAN component_status_hi… idBIGINT component_idBIGINT statusVARCHAR started_atTIMESTAMPTZ ended_atTIMESTAMPTZ causeVARCHAR incident_idBIGINT incidents idBIGINT slugVARCHAR titleVARCHAR severityVARCHAR statusVARCHAR detected_byVARCHAR started_atTIMESTAMPTZ declared_atTIMESTAMPTZ resolved_atTIMESTAMPTZ is_publicBOOLEAN incident_components incident_idBIGINT component_idBIGINT impact_statusVARCHAR added_atTIMESTAMPTZ scheduled_maintenan… idBIGINT slugVARCHAR titleVARCHAR descriptionTEXT statusVARCHAR scheduled_start_atTIMESTAMPTZ scheduled_end_atTIMESTAMPTZ actual_start_atTIMESTAMPTZ actual_end_atTIMESTAMPTZ notify_hours_befo…SMALLINT auto_transitionBOOLEAN maintenance_compone… maintenance_idBIGINT component_idBIGINT expected_impactVARCHAR status_updates idBIGINT incident_idBIGINT maintenance_idBIGINT update_statusVARCHAR bodyTEXT posted_atTIMESTAMPTZ posted_byVARCHAR notify_subscribersBOOLEAN is_publicBOOLEAN postmortems idBIGINT incident_idBIGINT published_atTIMESTAMPTZ summaryTEXT root_causeTEXT resolutionTEXT action_itemsJSONB is_publicBOOLEAN subscribers idBIGINT channelVARCHAR addressVARCHAR verified_atTIMESTAMPTZ unsubscribe_tokenVARCHAR statusVARCHAR localeVARCHAR created_atTIMESTAMPTZ subscriber_componen… subscriber_idBIGINT component_idBIGINT created_atTIMESTAMPTZ notification_delive… idBIGINT status_update_idBIGINT subscriber_idBIGINT channelVARCHAR statusVARCHAR attempt_countSMALLINT last_attempt_atTIMESTAMPTZ delivered_atTIMESTAMPTZ provider_message_…VARCHAR error_detailVARCHAR uptime_samples idBIGINT component_idBIGINT checked_atTIMESTAMPTZ is_upBOOLEAN latency_msINTEGER http_statusSMALLINT regionVARCHAR error_detailVARCHAR uptime_daily component_idBIGINT dayDATE up_secondsINTEGER degraded_secondsINTEGER down_secondsINTEGER maintenance_secon…INTEGER uptime_pctNUMERIC sample_countINTEGER

Related database schemas

PostgreSQL
Developer tools

API gateway & rate limiting database schema

How an API platform is modelled: consumers and applications, hashed API keys with scopes and rotation, upstream services and routes, rate limit policies, durable usage counters, rolled-up aggregates, sampled request logs, plans, quotas and overage billing.

PostgreSQL
Developer tools

CI/CD build pipeline database schema

How a build system models its data: versioned pipeline definitions, immutable runs triggered by a commit, stages with approval gates, a job DAG stored as edges, runners and capabilities, attempts and retries, artifacts, caches and streamed logs.

PostgreSQL
Developer tools

Error tracking and monitoring database schema

How an error monitoring service models its data: projects and releases, raw events with stack frames and breadcrumbs, grouping into issues by fingerprint, resolve and regression detection, alert rules and event sampling.

PostgreSQL
Developer tools

Feature flag service database schema

How a feature management platform stores its data: flags and variations, per-environment settings, ordered targeting rules, reusable segments, percentage rollouts with deterministic bucketing, scheduled changes and a full audit trail.