SQL

CREATE TABLE achievements  (
  id          INTEGER PRIMARY KEY AUTOINCREMENT,
  child_id    TEXT NOT NULL REFERENCES children(id),
  icon        TEXT NOT NULL,
  -- emoji/unicode
      title       TEXT NOT NULL,
  desc        TEXT,
  unlocked_at DATETIME DEFAULT (datetime('now'))
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ ✓ Rename | Drop
child_id TEXT Rename | Drop
icon TEXT Rename | Drop
title TEXT Rename | Drop
desc TEXT ✓ Rename | Drop
unlocked_at DATETIME ✓ Rename | Drop

Foreign Keys

Column Destination
child_id children.id

+ Add index

Indexes

Name Columns Unique SQL Drop?