ㅇㅇ
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