SQL

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
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ ✓ Rename | Drop
section_id TEXT Rename | Drop
assignment_id TEXT Rename | Drop
section_name TEXT Rename | Drop
section_desc TEXT ✓ Rename | Drop
category TEXT ✓ Rename | Drop
major_title TEXT ✓ Rename | Drop
material_id TEXT ✓ Rename | Drop
sort_order INTEGER ✓ Rename | Drop
total_score REAL ✓ Rename | Drop
create_time DATETIME ✓ Rename | Drop
child_id TEXT ✓ Rename | Drop
parent_id TEXT ✓ Rename | Drop
source_type TEXT ✓ Rename | Drop
status TEXT ✓ Rename | Drop
title TEXT ✓ Rename | Drop
note TEXT ✓ Rename | Drop
subject TEXT ✓ Rename | Drop
item_count INTEGER ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_pager_ps_child child_id SQL 
CREATE INDEX idx_pager_ps_child
ON pager_paper_sections(child_id)
Drop
idx_pager_ps_parent parent_id SQL 
CREATE INDEX idx_pager_ps_parent
ON pager_paper_sections(parent_id)
Drop
idx_pager_ps_status status SQL 
CREATE INDEX idx_pager_ps_status
ON pager_paper_sections(status)
Drop
idx_ps_asgn assignment_id SQL 
CREATE INDEX idx_ps_asgn
ON "pager_paper_sections"(assignment_id)
Drop
idx_ps_order
  • assignment_id
  • sort_order
 SQL 
CREATE INDEX idx_ps_order
ON "pager_paper_sections"(assignment_id, sort_order)
Drop
sqlite_autoindex_pager_paper_sections_1 section_id ✓ SQL
-- no sql found --
 Drop