Add Column

Cancel

Current Schema

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'))
)