EMS_Platform/backend/db/migrations/000002_create_alarm_rules.up.sql

CREATE TABLE IF NOT EXISTS alarm_rules (
    id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
    name VARCHAR(100) NOT NULL,
    target_type VARCHAR(20) NOT NULL,
    target_id UUID NOT NULL,
    metric VARCHAR(50) NOT NULL,
    operator VARCHAR(10) NOT NULL,
    threshold NUMERIC(10,2) NOT NULL,
    duration INTEGER DEFAULT 0,
    silence_period INTEGER DEFAULT 300,
    priority VARCHAR(20) NOT NULL,
    message VARCHAR(255),
    enabled BOOLEAN DEFAULT TRUE,
    created_at TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP
);

CREATE INDEX IF NOT EXISTS idx_alarm_rules_target_id ON alarm_rules(target_id);