-- Remediation Engine storage v1: derived flags and package definitions only.
CREATE SCHEMA IF NOT EXISTS assessor_remediation;
CREATE TABLE IF NOT EXISTS assessor_remediation.package_snapshots (
  scope_key text PRIMARY KEY,
  data jsonb NOT NULL,
  created_at timestamptz NOT NULL DEFAULT now(),
  CHECK (jsonb_typeof(data->'packages') = 'array')
);