Add Column

Cancel

Current Schema

CREATE TABLE review_error_mastery  (
  id                TEXT PRIMARY KEY,
  child_id          TEXT NOT NULL,
  assignment_item_id TEXT,
  subject           TEXT NOT NULL,
  question_title    TEXT,
  correct_count     INTEGER DEFAULT 0,
  total_attempts    INTEGER DEFAULT 0,
  status            TEXT DEFAULT 'pending' CHECK(status IN ('pending','mastered')),
  last_practiced_at DATETIME DEFAULT (datetime('now')),
  created_at        DATETIME DEFAULT (datetime('now'))
)