+/- table definition

Query

CREATE TABLE reminders  (
  entity_id TEXT PRIMARY KEY,
  text TEXT NOT NULL,
  due_at_iso TEXT NOT NULL,
  recurrence_cron TEXT,
  status TEXT NOT NULL CHECK (status IN ('active','snoozed','done','cancelled')),
  last_fired_at TEXT,
  done_at TEXT,
  snoozed_until_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'))
)
Use Shift + Up/Down to navigate recently-executed queries