Add Column

Cancel

Current Schema

CREATE TABLE textbook_pages  (
  id          INTEGER PRIMARY KEY AUTOINCREMENT,
  lesson_id   INTEGER NOT NULL REFERENCES textbook_lessons(id),
  page_number INTEGER NOT NULL,
  -- 教材页码
    image_path  TEXT,
  -- 扫描图本地路径
    image_url   TEXT,
  -- 公网URL
    page_type   TEXT DEFAULT 'content',
  -- content/vocab/exercise/cover
    created_at  DATETIME DEFAULT (datetime('now'))
)