SQL

CREATE TABLE chat_logs  (
  id          INTEGER PRIMARY KEY AUTOINCREMENT,
  child_id    TEXT NOT NULL REFERENCES children(id),
  session_id  TEXT,
  message_count INTEGER DEFAULT 0,
  started_at  DATETIME DEFAULT (datetime('now')),
  ended_at    DATETIME
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ ✓ Rename | Drop
child_id TEXT Rename | Drop
session_id TEXT ✓ Rename | Drop
message_count INTEGER ✓ Rename | Drop
started_at DATETIME ✓ Rename | Drop
ended_at DATETIME ✓ Rename | Drop

Foreign Keys

Column Destination
child_id children.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_chat_logs_child child_id SQL 
CREATE INDEX idx_chat_logs_child
ON chat_logs(child_id)
Drop