+/- table definition

Query 

CREATE TABLE review_topics  (
  id              TEXT PRIMARY KEY,
  package_id      TEXT NOT NULL REFERENCES review_packages(id) ON DELETE CASCADE,
  topic_name      TEXT NOT NULL,
  priority       INTEGER DEFAULT 3 CHECK(priority BETWEEN 0 AND 5),
  error_count    INTEGER DEFAULT 0,
  mastery        REAL DEFAULT 0,
  ai_content     TEXT DEFAULT '[]',
  status         TEXT DEFAULT 'pending' CHECK(status IN ('pending','in_progress','mastered')),
  created_at     DATETIME DEFAULT (datetime('now'))
)
Use Shift + Up/Down to navigate recently-executed queries
delete expression index : create index : drop insert select : advanced select table : alter table : create table : drop trigger : create trigger : drop update view : create view : drop