+/- table definition

Query 

CREATE TABLE "pager_paper_sections"  (
  id             INTEGER PRIMARY KEY AUTOINCREMENT,
  section_id     TEXT NOT NULL UNIQUE,
  assignment_id  TEXT NOT NULL,
  section_name   TEXT NOT NULL DEFAULT '',
  section_desc   TEXT DEFAULT '',
  category       TEXT DEFAULT '',
  major_title    TEXT DEFAULT '',
  material_id    TEXT,
  sort_order     INTEGER DEFAULT 0,
  total_score    REAL DEFAULT 0,
  create_time    DATETIME DEFAULT (datetime('now')),
  child_id    TEXT DEFAULT '',
  parent_id   TEXT DEFAULT '',
  source_type TEXT DEFAULT 'photo',
  status      TEXT DEFAULT 'pending',
  title       TEXT DEFAULT '',
  note        TEXT DEFAULT '',
  subject     TEXT DEFAULT '识别中...',
  item_count  INTEGER DEFAULT 0
)
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