Skip to content

armgit / AiSOC

Public Imported from GitHub
0

Open-source AI Security Operations Center: alert fusion, LLM-agent triage, MITRE ATT&CK investigation, and a replayable decision ledger for every agent step. Self-hostable, runs with no API keys, MIT licensed. Ships an MCP server for Claude, Cursor and Continue.

1.0 KB
Raw Blame
-- Migration 027: Per-case investigation/response tasks
--
-- The web console renders a "Tasks" panel in the case workspace where SOC
-- analysts can capture follow-up work (run forensic image, contact owner,
-- block IP at the edge, …) tied to a specific case. Tasks are simple — a
-- title, an optional assignee/due date, and a three-state status.

CREATE TABLE IF NOT EXISTS aisoc_case_tasks (
    id          UUID PRIMARY KEY DEFAULT gen_random_uuid(),
    case_id     UUID NOT NULL REFERENCES aisoc_cases(id) ON DELETE CASCADE,
    title       TEXT NOT NULL,
    status      TEXT NOT NULL DEFAULT 'todo'
                    CHECK (status IN ('todo','in_progress','done')),
    assignee    TEXT,
    due_at      TIMESTAMPTZ,
    created_at  TIMESTAMPTZ NOT NULL DEFAULT now(),
    updated_at  TIMESTAMPTZ NOT NULL DEFAULT now(),
    created_by  TEXT
);

CREATE INDEX IF NOT EXISTS idx_aisoc_case_tasks_case   ON aisoc_case_tasks (case_id);
CREATE INDEX IF NOT EXISTS idx_aisoc_case_tasks_status ON aisoc_case_tasks (status);