+/- table definition

Query 

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