Query
CREATE TABLE reports (
id INTEGER PRIMARY KEY AUTOINCREMENT,
child_id TEXT NOT NULL REFERENCES children(id),
type TEXT NOT NULL CHECK(type IN ('weekly','daily')),
start_date TEXT NOT NULL,
end_date TEXT NOT NULL,
data_json TEXT NOT NULL,
created_at DATETIME DEFAULT (datetime('now'))
)