Add Column

Cancel

Current Schema

CREATE TABLE abilities  (
  id          INTEGER PRIMARY KEY AUTOINCREMENT,
  child_id    TEXT NOT NULL REFERENCES children(id),
  ability_id  TEXT NOT NULL,
  -- language/logic/science/creativity/social/metacognition/kinesthetic
      level       INTEGER DEFAULT 1,
  xp          INTEGER DEFAULT 0,
  xp_to_next  INTEGER DEFAULT 100,
  updated_at  DATETIME DEFAULT (datetime('now')),
  UNIQUE(child_id, ability_id)
)