-- Requests 6 and 7: route purchases belong to a specific permit, while
-- existing imported Synchron history (which has no permit id) keeps its
-- original trip + state behavior. Carrier validation fields are additive;
-- the validation workflow is wired in application code separately.

alter table public.service_requests
  add column if not exists permit_id uuid references public.permits(id) on delete set null;

create index if not exists service_requests_permit_route_idx
  on public.service_requests (permit_id, status, created_at desc)
  where type = 'route_request' and permit_id is not null;

comment on column public.service_requests.permit_id is
  'The exact permit whose route was requested or purchased. Null is retained only for legacy/imported trip-and-state records.';

alter table public.trips
  add column if not exists carrier_validation text
    check (carrier_validation is null or carrier_validation in ('validated', 'needs_confirmation', 'unverified')),
  add column if not exists carrier_validated_at timestamptz;

comment on column public.trips.carrier_validation is
  'Result of validation against carrier information extracted from readable permits.';
comment on column public.trips.carrier_validated_at is
  'When the carrier-validation result was last calculated.';
