Add Column

Cancel

Current Schema

CREATE TABLE inbox_items  (
  id TEXT PRIMARY KEY,
  type TEXT NOT NULL,
  text TEXT NOT NULL,
  normalized_text TEXT,
  status TEXT NOT NULL CHECK (status IN ('new','open','triaged','snoozed','done','dismissed','archived')),
  tags TEXT,
  links TEXT,
  ts TEXT NOT NULL,
  route TEXT,
  urgency TEXT,
  next_touch_at_iso 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'))
)