-- Record which CDC-GPSF user reviewed a Ministry progress report (and when).
ALTER TABLE "progress_report_ministries"
  ADD COLUMN "reviewed_by_id" INTEGER,
  ADD COLUMN "reviewed_at" TIMESTAMP(3);

CREATE INDEX "progress_report_ministries_reviewed_by_id_idx"
  ON "progress_report_ministries"("reviewed_by_id");

ALTER TABLE "progress_report_ministries"
  ADD CONSTRAINT "progress_report_ministries_reviewed_by_id_fkey"
  FOREIGN KEY ("reviewed_by_id") REFERENCES "users"("id")
  ON DELETE SET NULL ON UPDATE CASCADE;
