SQL

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'))
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id TEXT ✓ ✓ Rename | Drop
child_id TEXT Rename | Drop
assignment_item_id TEXT ✓ Rename | Drop
subject TEXT Rename | Drop
question_title TEXT ✓ Rename | Drop
correct_count INTEGER ✓ Rename | Drop
total_attempts INTEGER ✓ Rename | Drop
status TEXT ✓ Rename | Drop
last_practiced_at DATETIME ✓ Rename | Drop
created_at DATETIME ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_rem_child child_id SQL 
CREATE INDEX idx_rem_child
ON review_error_mastery(child_id)
Drop
idx_rem_child_status
  • child_id
  • status
 SQL 
CREATE INDEX idx_rem_child_status
ON review_error_mastery(child_id, status)
Drop
idx_rem_child_subject
  • child_id
  • subject
 SQL 
CREATE INDEX idx_rem_child_subject
ON review_error_mastery(child_id, subject)
Drop
sqlite_autoindex_review_error_mastery_1 id ✓ SQL
-- no sql found --
 Drop