endai-system 査読仕分け機能 引き継ぎ資料

-- 031: 簡易査読モード + 査読者招待フロー

-- reviews テーブルに簡易査読用カラム追加
ALTER TABLE reviews ADD COLUMN IF NOT EXISTS review_mode TEXT
  NOT NULL DEFAULT 'detailed'
  CHECK (review_mode IN ('detailed', 'quick'));
ALTER TABLE reviews ADD COLUMN IF NOT EXISTS quick_decision TEXT
  CHECK (quick_decision IN ('accept', 'revise', 'reject'));

-- reviewer_invitations テーブル作成
CREATE TABLE IF NOT EXISTS reviewer_invitations (
  id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
  conference_id UUID NOT NULL REFERENCES conferences(id),
  email TEXT NOT NULL,
  name TEXT,
  affiliation TEXT,
  token TEXT NOT NULL UNIQUE,
  status TEXT NOT NULL DEFAULT 'pending'
    CHECK (status IN ('pending','accepted','declined','expired')),
  invited_by UUID REFERENCES profiles(id),
  invited_at TIMESTAMPTZ NOT NULL DEFAULT now(),
  responded_at TIMESTAMPTZ,
  decline_reason TEXT,
  max_assignments INTEGER DEFAULT 10,
  specialty_categories UUID[],
  created_at TIMESTAMPTZ NOT NULL DEFAULT now(),
  updated_at TIMESTAMPTZ NOT NULL DEFAULT now()
);

-- + インデックス、RLS、ビュー、集計関数
-- （全文は 031_quick_review_and_invitations.sql を参照）