Architecture

{
  "card_id":  "uuid",
  "type":     "SIGNAL_BRIEF | MANIFEST_DIFF | SCAN_STATUS | EXPORT_READY",
  "severity": "CRITICAL | WARNING | INFO",
  "content":  { "title": "...", "summary": "...", ... },
  "actions": [
    { "label": "UPDATE MANIFEST", "variant": "primary",   "shortcut": "⌘↵",  "action": "update_manifest" },
    { "label": "SAVE BRIEF",      "variant": "secondary", "shortcut": "⌘B",  "action": "save_brief" },
    { "label": "DISMISS",         "variant": "ghost",     "shortcut": "Esc", "action": "dismiss" }
  ]
}

-- One active project = one manifest
CREATE TABLE projects (
  id            TEXT PRIMARY KEY,
  name          TEXT NOT NULL,
  manifest_path TEXT NOT NULL,
  git_repo_path TEXT NOT NULL,
  created_at    TEXT NOT NULL,
  last_synced   TEXT
);

-- Tracked competitor entities per project
CREATE TABLE competitors (
  id         TEXT PRIMARY KEY,
  project_id TEXT NOT NULL REFERENCES projects(id),
  name       TEXT NOT NULL,
  urls       TEXT NOT NULL,  -- JSON array
  active     INTEGER DEFAULT 1
);

-- Individual detected changes from OSINT
CREATE TABLE signals (
  id                     TEXT PRIMARY KEY,
  project_id             TEXT NOT NULL REFERENCES projects(id),
  competitor_id          TEXT REFERENCES competitors(id),
  detected_at            TEXT NOT NULL,
  source_url             TEXT,
  raw_content            TEXT,
  significance_score     INTEGER,
  significance_rationale TEXT,
  status                 TEXT DEFAULT 'pending'
  -- pending | surfaced | dismissed | actioned
);

-- Generated intelligence outputs
CREATE TABLE briefs (
  id           TEXT PRIMARY KEY,
  project_id   TEXT NOT NULL REFERENCES projects(id),
  signal_ids   TEXT NOT NULL,  -- JSON array
  generated_at TEXT NOT NULL,
  title        TEXT NOT NULL,
  content_md   TEXT NOT NULL,
  status       TEXT DEFAULT 'draft',
  -- draft | approved | exported
  export_path  TEXT
);

-- Git commit history mirror for UI display
CREATE TABLE manifest_versions (
  id             TEXT PRIMARY KEY,
  project_id     TEXT NOT NULL REFERENCES projects(id),
  commit_hash    TEXT NOT NULL,
  committed_at   TEXT NOT NULL,
  change_summary TEXT,
  triggered_by   TEXT  -- signal_id or 'user'
);

-- Every agent action, verbatim (same pattern as TX-1)
CREATE TABLE audit_log (
  id          TEXT PRIMARY KEY,
  project_id  TEXT,
  action_type TEXT NOT NULL,
  rationale   TEXT,
  input_hash  TEXT,
  output_hash TEXT,
  created_at  TEXT NOT NULL
);