SQL

CREATE TABLE review_packages  (
  id            TEXT PRIMARY KEY,
  child_id      TEXT NOT NULL,
  subject       TEXT NOT NULL CHECK(subject IN ('数学','语文','英语')),
  status        TEXT DEFAULT 'planning' CHECK(status IN ('planning','in_progress','completed')),
  progress      REAL DEFAULT 0,
  exam_date     TEXT,
  days_plan     INTEGER DEFAULT 7,
  total_topics  INTEGER DEFAULT 0,
  mastered_topics INTEGER DEFAULT 0,
  created_at    DATETIME DEFAULT (datetime('now')),
  updated_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
subject TEXT Rename | Drop
status TEXT ✓ Rename | Drop
progress REAL ✓ Rename | Drop
exam_date TEXT ✓ Rename | Drop
days_plan INTEGER ✓ Rename | Drop
total_topics INTEGER ✓ Rename | Drop
mastered_topics INTEGER ✓ Rename | Drop
created_at DATETIME ✓ Rename | Drop
updated_at DATETIME ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_rp_child_subject
  • child_id
  • subject
 SQL 
CREATE INDEX idx_rp_child_subject
ON review_packages(child_id, subject)
Drop
sqlite_autoindex_review_packages_1 id ✓ SQL
-- no sql found --
 Drop