SQL

CREATE TABLE pager_papers  (
  id              INTEGER PRIMARY KEY AUTOINCREMENT,
  assignment_id   TEXT NOT NULL UNIQUE,
  child_id        TEXT DEFAULT '',
  parent_id       TEXT DEFAULT '',
  subject         TEXT DEFAULT '',
  title           TEXT DEFAULT '',
  note            TEXT DEFAULT '',
  source_type     TEXT DEFAULT 'photo',
  status          TEXT DEFAULT 'pending',
  section_count   INTEGER DEFAULT 0,
  item_count      INTEGER DEFAULT 0,
  total_score     REAL DEFAULT 0,
  create_time     DATETIME DEFAULT (datetime('now')),
  update_time     DATETIME DEFAULT (datetime('now'))
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ ✓ Rename | Drop
assignment_id TEXT Rename | Drop
child_id TEXT ✓ Rename | Drop
parent_id TEXT ✓ Rename | Drop
subject TEXT ✓ Rename | Drop
title TEXT ✓ Rename | Drop
note TEXT ✓ Rename | Drop
source_type TEXT ✓ Rename | Drop
status TEXT ✓ Rename | Drop
section_count INTEGER ✓ Rename | Drop
item_count INTEGER ✓ Rename | Drop
total_score REAL ✓ Rename | Drop
create_time DATETIME ✓ Rename | Drop
update_time DATETIME ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_pp_child child_id SQL 
CREATE INDEX idx_pp_child
ON pager_papers(child_id)
Drop
idx_pp_parent parent_id SQL 
CREATE INDEX idx_pp_parent
ON pager_papers(parent_id)
Drop
idx_pp_status status SQL 
CREATE INDEX idx_pp_status
ON pager_papers(status)
Drop
idx_pp_subject subject SQL 
CREATE INDEX idx_pp_subject
ON pager_papers(subject)
Drop
sqlite_autoindex_pager_papers_1 assignment_id ✓ SQL
-- no sql found --
 Drop