-- Migration: Value Card session column
-- Description: Adds a single value_card_details JSONB column to program_session holding the last
--              Value Card sent for the session — its description and the uploaded file URLs
--              (re-hosted under valuecard/sessions/<sessionId>/):
--                { "description": "...", "documentUrls": ["https://.../card.pptx"] }
--              Nullable; null = no value card sent yet. Idempotent.

ALTER TABLE program_session
    ADD COLUMN IF NOT EXISTS value_card_details JSONB NULL;

COMMENT ON COLUMN program_session.value_card_details IS
    'Last Value Card sent for this session: { description, documentUrls[] } (files re-hosted under valuecard/sessions/<sessionId>/). Null = none sent.';
