Add Column

Cancel

Current Schema

CREATE TABLE announcements  (
  id             INTEGER PRIMARY KEY AUTOINCREMENT,
  title          TEXT NOT NULL,
  content        TEXT NOT NULL,
  target         TEXT DEFAULT 'all' CHECK(target IN ('all','institution','parent')),
  institution_id TEXT,
  status         TEXT DEFAULT 'draft' CHECK(status IN ('draft','published')),
  published_at   DATETIME,
  created_at     DATETIME DEFAULT (datetime('now')),
  updated_at     DATETIME DEFAULT (datetime('now'))
)