koinping_v0.2.0/backend/infra/migrations/004_alert_event_dedup.sql

CREATE UNIQUE INDEX IF NOT EXISTS idx_alert_events_dedup
    ON alert_events (alert_rule_id, tx_hash)
    WHERE tx_hash IS NOT NULL;