SQL

CREATE TABLE checkins  (
  id          INTEGER PRIMARY KEY AUTOINCREMENT,
  child_id    TEXT NOT NULL REFERENCES children(id),
  date        TEXT NOT NULL,
  -- YYYY-MM-DD
      duration_sec INTEGER DEFAULT 0,
  topic_count INTEGER DEFAULT 0,
  UNIQUE(child_id, date)
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ ✓ Rename | Drop
child_id TEXT Rename | Drop
date TEXT Rename | Drop
duration_sec INTEGER ✓ Rename | Drop
topic_count INTEGER ✓ Rename | Drop

Foreign Keys

Column Destination
child_id children.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_checkins_child_date
  • child_id
  • date
 SQL 
CREATE INDEX idx_checkins_child_date
ON checkins(child_id, date)
Drop
sqlite_autoindex_checkins_1
  • child_id
  • date
 ✓ SQL
-- no sql found --
 Drop