SQL

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

+ Add column

Columns

Column Data type Allow null Primary key Actions
id TEXT ✓ ✓ Rename | Drop
subject TEXT Rename | Drop
publisher TEXT Rename | Drop
version TEXT ✓ Rename | Drop
grade INTEGER Rename | Drop
term INTEGER Rename | Drop
label TEXT Rename | Drop
created_at DATETIME ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
sqlite_autoindex_textbook_versions_1 id ✓ SQL
-- no sql found --
 Drop