Add Column

Cancel

Current Schema

CREATE TABLE course_topics  (
  id          INTEGER PRIMARY KEY AUTOINCREMENT,
  title       TEXT NOT NULL,
  category    TEXT NOT NULL,
  description TEXT DEFAULT '',
  age_range   TEXT DEFAULT '6-12',
  difficulty  TEXT DEFAULT 'beginner' CHECK(difficulty IN ('beginner','intermediate','advanced')),
  tags        TEXT DEFAULT '[]',
  content     TEXT DEFAULT '',
  status      TEXT DEFAULT 'active' CHECK(status IN ('active','draft','archived')),
  created_at  DATETIME DEFAULT (datetime('now')),
  updated_at  DATETIME DEFAULT (datetime('now'))
)