CREATE TABLE postmortems (
    id              UUID PRIMARY KEY DEFAULT gen_random_uuid(),
    tenant_id       UUID NOT NULL REFERENCES tenants(id),
    project_id      UUID NOT NULL REFERENCES projects(id),
    captured_via    TEXT NOT NULL,            -- agent persona
    captured_at     TIMESTAMPTZ NOT NULL DEFAULT now(),
    error_summary   TEXT NOT NULL,
    what_i_did      TEXT NOT NULL,
    what_i_should   TEXT NOT NULL,
    choice_point    TEXT NOT NULL,
    memory_violated TEXT,
    blast_radius    TEXT,
    why_skipped     TEXT NOT NULL,
    what_catches    TEXT NOT NULL,
    action_item     TEXT NOT NULL,
    triggered_by_input  UUID REFERENCES operator_inputs(id),
    resolved_at         TIMESTAMPTZ,
    resolution_kind     TEXT,
    resolution_ref      TEXT
);
CREATE INDEX ix_postmortems_unresolved ON postmortems(captured_at DESC) WHERE resolved_at IS NULL;

prism_postmortem(
  pid, error_summary, what_i_did, what_i_should, choice_point,
  memory_violated?, blast_radius?, why_skipped, what_catches, action_item,
  triggered_by_input?
) → {id, captured_at}

prism_postmortem_resolve(
  pid, postmortem_id,
  resolution_kind: 'memory_filed'|'spec_filed'|'tooling_change'|'no_action_needed',
  resolution_ref?: <file path | spec_id | commit SHA>
) → {id, resolved_at}