SQL

CREATE TABLE assignments  (
  id            TEXT PRIMARY KEY,
  child_id      TEXT NOT NULL,
  parent_id     TEXT NOT NULL,
  status        TEXT DEFAULT 'pending'
                    CHECK(status IN ('pending','pushed','correcting','completed')),
  source_type   TEXT DEFAULT 'photo'
                    CHECK(source_type IN ('photo','voice','screenshot','manual')),
  note          TEXT DEFAULT '',
  item_count    INTEGER DEFAULT 0,
  pushed_at     DATETIME,
  created_at    DATETIME DEFAULT (datetime('now')),
  updated_at    DATETIME DEFAULT (datetime('now'))
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id TEXT ✓ ✓ Rename | Drop
child_id TEXT Rename | Drop
parent_id TEXT Rename | Drop
status TEXT ✓ Rename | Drop
source_type TEXT ✓ Rename | Drop
note TEXT ✓ Rename | Drop
item_count INTEGER ✓ Rename | Drop
pushed_at DATETIME ✓ Rename | Drop
created_at DATETIME ✓ Rename | Drop
updated_at DATETIME ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_asgn_child child_id SQL 
CREATE INDEX idx_asgn_child
ON assignments(child_id)
Drop
idx_asgn_created created_at SQL 
CREATE INDEX idx_asgn_created
ON assignments(created_at)
Drop
idx_asgn_parent parent_id SQL 
CREATE INDEX idx_asgn_parent
ON assignments(parent_id)
Drop
idx_asgn_status status SQL 
CREATE INDEX idx_asgn_status
ON assignments(status)
Drop
sqlite_autoindex_assignments_1 id ✓ SQL
-- no sql found --
 Drop