SQL

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

+ Add column

Columns

Column Data type Allow null Primary key Actions
id TEXT ✓ ✓ Rename | Drop
package_id TEXT Rename | Drop
topic_name TEXT Rename | Drop
priority INTEGER ✓ Rename | Drop
error_count INTEGER ✓ Rename | Drop
mastery REAL ✓ Rename | Drop
ai_content TEXT ✓ Rename | Drop
status TEXT ✓ Rename | Drop
created_at DATETIME ✓ Rename | Drop

Foreign Keys

Column Destination
package_id review_packages.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_rt_package package_id SQL 
CREATE INDEX idx_rt_package
ON review_topics(package_id)
Drop
sqlite_autoindex_review_topics_1 id ✓ SQL
-- no sql found --
 Drop