Query
CREATE TABLE messages (
id INTEGER PRIMARY KEY AUTOINCREMENT,
child_id TEXT NOT NULL REFERENCES children(id),
session_id TEXT NOT NULL,
role TEXT NOT NULL CHECK(role IN ('user', 'ai')),
content TEXT NOT NULL,
created_at DATETIME DEFAULT (datetime('now')),
topic TEXT DEFAULT ''
)