Add Column

Cancel

Current Schema

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'))
)