+/- table definition

Query 

CREATE TABLE textbook_versions  (
  id          TEXT PRIMARY KEY,
  -- 'yuwen_bubian_1s' 格式
    subject     TEXT NOT NULL,
  -- 语文/数学/英语
    publisher   TEXT NOT NULL,
  -- 人教/北师大
    version     TEXT DEFAULT '部编版',
  -- 版本名称
    grade       INTEGER NOT NULL,
  -- 1-12
    term        INTEGER NOT NULL,
  -- 1=上册,
  2=下册
    label       TEXT NOT NULL,
  -- 显示名: '一年级上册'
    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