SQL

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

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ ✓ Rename | Drop
title TEXT Rename | Drop
content TEXT Rename | Drop
target TEXT ✓ Rename | Drop
institution_id TEXT ✓ Rename | Drop
status TEXT ✓ Rename | Drop
published_at DATETIME ✓ Rename | Drop
created_at DATETIME ✓ Rename | Drop
updated_at DATETIME ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?