SQL

CREATE TABLE textbook_vocabularies  (
  id          INTEGER PRIMARY KEY AUTOINCREMENT,
  lesson_id   INTEGER NOT NULL REFERENCES textbook_lessons(id),
  word        TEXT NOT NULL,
  -- 字/词
    pinyin      TEXT,
  -- 拼音
    word_type   TEXT DEFAULT 'character',
  -- character=生字,
  word=词语
    stroke_count INTEGER,
  -- 笔画数
    radical     TEXT,
  -- 部首
    meaning     TEXT,
  -- 释义（可选）
    is_keyword  INTEGER DEFAULT 0,
  -- 是否重点词语
    created_at  DATETIME DEFAULT (datetime('now'))
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ ✓ Rename | Drop
lesson_id INTEGER Rename | Drop
word TEXT Rename | Drop
pinyin TEXT ✓ Rename | Drop
word_type TEXT ✓ Rename | Drop
stroke_count INTEGER ✓ Rename | Drop
radical TEXT ✓ Rename | Drop
meaning TEXT ✓ Rename | Drop
is_keyword INTEGER ✓ Rename | Drop
created_at DATETIME ✓ Rename | Drop

Foreign Keys

Column Destination
lesson_id textbook_lessons.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_vocab_lesson lesson_id SQL 
CREATE INDEX idx_vocab_lesson
ON textbook_vocabularies(lesson_id)
Drop