Add Column

Cancel

Current Schema

CREATE TABLE sources  (
  id TEXT PRIMARY KEY,
  kind TEXT NOT NULL,
  -- calendar|gmail|slack|market|health|custom
  label TEXT,
  config TEXT,
  -- JSON (non-secret metadata)
  status TEXT NOT NULL DEFAULT 'ok' CHECK (status IN ('ok','degraded','auth_error','paused','error')),
  last_success_at TEXT,
  last_error_at TEXT,
  last_error TEXT,
  created_at TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ','now')),
  updated_at TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ','now'))
)