+/- table definition

Query

CREATE TABLE review_schedule_items  (
  id            TEXT PRIMARY KEY,
  schedule_id   TEXT NOT NULL REFERENCES review_schedules(id) ON DELETE CASCADE,
  subject       TEXT NOT NULL,
  topic_name    TEXT NOT NULL,
  item_type     TEXT NOT NULL CHECK(item_type IN ('practice','error_review','mock')),
  estimated_min INTEGER DEFAULT 10,
  status        TEXT DEFAULT 'pending' CHECK(status IN ('pending','completed')),
  created_at    DATETIME DEFAULT (datetime('now'))
)
Use Shift + Up/Down to navigate recently-executed queries