-- Optional display name for personalized report emails (Hi {name},).
alter table public.scan_details
  add column if not exists requester_name text;

comment on column public.scan_details.requester_name is 'Recipient name for email greeting; falls back to Hi there, when null.';
