SQL

CREATE TABLE "pager_paper_questions"  (
  id               INTEGER PRIMARY KEY AUTOINCREMENT,
  question_id      TEXT NOT NULL UNIQUE,
  assignment_id    TEXT NOT NULL,
  type             TEXT NOT NULL DEFAULT 'unknown'
                     CHECK(type IN ('single_choice','multiple_choice','true_false','fill_blank',
                                    'short_answer','essay','matching','calculation','other','unknown')),
  content_text     TEXT NOT NULL DEFAULT '',
  score            REAL DEFAULT 0,
  difficulty       REAL DEFAULT 0.50 CHECK(difficulty >= 0 AND difficulty <= 1),
  correct_answer   TEXT DEFAULT '',
  explanation      TEXT DEFAULT '',
  sort_order       INTEGER DEFAULT 0,
  assigned_page    INTEGER DEFAULT 0,
  page_order       INTEGER DEFAULT 0,
  image_idx        INTEGER DEFAULT 0,
  section          TEXT DEFAULT '',
  options          TEXT DEFAULT '[]',
  major_index      TEXT DEFAULT '',
  extra_content    TEXT DEFAULT '[]',
  ref_material_id  TEXT,
  ref_paragraph_index INTEGER,
  create_time      DATETIME DEFAULT (datetime('now'))
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ ✓ Rename | Drop
question_id TEXT Rename | Drop
assignment_id TEXT Rename | Drop
type TEXT Rename | Drop
content_text TEXT Rename | Drop
score REAL ✓ Rename | Drop
difficulty REAL ✓ Rename | Drop
correct_answer TEXT ✓ Rename | Drop
explanation TEXT ✓ Rename | Drop
sort_order INTEGER ✓ Rename | Drop
assigned_page INTEGER ✓ Rename | Drop
page_order INTEGER ✓ Rename | Drop
image_idx INTEGER ✓ Rename | Drop
section TEXT ✓ Rename | Drop
options TEXT ✓ Rename | Drop
major_index TEXT ✓ Rename | Drop
extra_content TEXT ✓ Rename | Drop
ref_material_id TEXT ✓ Rename | Drop
ref_paragraph_index INTEGER ✓ Rename | Drop
create_time DATETIME ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_pq_asgn assignment_id SQL 
CREATE INDEX idx_pq_asgn
ON "pager_paper_questions"(assignment_id)
Drop
idx_pq_section
  • assignment_id
  • section
 SQL 
CREATE INDEX idx_pq_section
ON "pager_paper_questions"(assignment_id, section)
Drop
idx_pq_type type SQL 
CREATE INDEX idx_pq_type
ON "pager_paper_questions"(type)
Drop
sqlite_autoindex_pager_paper_questions_1 question_id ✓ SQL
-- no sql found --
 Drop