-- Migration 153: CRA project -> IACE (CE risk assessment) project reference.
-- One assessment, two views: the IACE "CRA / Cyber" tab resolves the linked CRA
-- project's latest assessment snapshot via this column instead of a demo fixture.
-- Additive + idempotent.

ALTER TABLE compliance_cra_projects
    ADD COLUMN IF NOT EXISTS linked_iace_project_id UUID;

CREATE INDEX IF NOT EXISTS idx_cra_projects_linked_iace
    ON compliance_cra_projects (linked_iace_project_id);
