SQL

CREATE TABLE ability_radar_history  (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  child_id TEXT NOT NULL REFERENCES children(id),
  dimension TEXT NOT NULL,
  score REAL NOT NULL,
  recorded_at DATETIME DEFAULT CURRENT_TIMESTAMP
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ ✓ Rename | Drop
child_id TEXT Rename | Drop
dimension TEXT Rename | Drop
score REAL Rename | Drop
recorded_at DATETIME ✓ Rename | Drop

Foreign Keys

Column Destination
child_id children.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_ability_history_child
  • child_id
  • dimension
  • recorded_at
 SQL 
CREATE INDEX idx_ability_history_child
ON ability_radar_history(child_id, dimension, recorded_at)
Drop
idx_radar_history_child
  • child_id
  • recorded_at
 SQL 
CREATE INDEX idx_radar_history_child
ON ability_radar_history(child_id, recorded_at)
Drop