ㅇㅇ

Tables (10)

alert_channels

  • id — UUID — Primary key — NOT NULL
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • type — alert_channel_type — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • config — JSONB — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

alert_delivery_logs

  • id — UUID — Primary key — NOT NULL
  • subscription_id — UUID — Foreign key → alert_subscriptions.id — NOT NULL
  • incident_id — UUID — Foreign key → incidents.id
  • channel_type — alert_channel_type — NOT NULL
  • status — delivery_status — NOT NULL
  • error_message — TEXT
  • delivered_at — TIMESTAMPTZ — NOT NULL

alert_subscriptions

  • id — UUID — Primary key — NOT NULL
  • channel_id — UUID — Foreign key → alert_channels.id — NOT NULL
  • service_id — UUID — Foreign key → services.id — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

health_check_logs

  • id — UUID — Primary key — NOT NULL
  • service_id — UUID — Foreign key → services.id — NOT NULL
  • component_id — UUID — Foreign key → service_components.id
  • status — service_status — NOT NULL
  • response_ms — INTEGER
  • raw_response — JSONB
  • checked_at — TIMESTAMPTZ — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

incident_updates

  • id — UUID — Primary key — NOT NULL
  • incident_id — UUID — Foreign key → incidents.id — NOT NULL
  • body — TEXT — NOT NULL
  • status — incident_status — NOT NULL
  • published_at — TIMESTAMPTZ — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

incidents

  • id — UUID — Primary key — NOT NULL
  • service_id — UUID — Foreign key → services.id — NOT NULL
  • external_id — VARCHAR(255)
  • title — VARCHAR(500) — NOT NULL
  • status — incident_status — NOT NULL
  • impact — incident_impact — NOT NULL
  • started_at — TIMESTAMPTZ — NOT NULL
  • resolved_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

service_components

  • id — UUID — Primary key — NOT NULL
  • service_id — UUID — Foreign key → services.id — NOT NULL
  • name — VARCHAR(200) — NOT NULL
  • external_id — VARCHAR(255)
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

service_current_status

  • service_id — UUID — Foreign key → services.id — NOT NULL
  • status — service_status — NOT NULL
  • last_checked_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ — NOT NULL

services

  • id — UUID — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • slug — VARCHAR(100) — NOT NULL
  • category — service_category — NOT NULL
  • provider_type — provider_type — NOT NULL
  • status_api_url — VARCHAR(500) — NOT NULL
  • icon_url — VARCHAR(500)
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

users

  • id — UUID — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(100)
  • provider — auth_provider — NOT NULL
  • provider_id — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL