-- AlterTable: add package_departure_station_id to Booking
ALTER TABLE "passenger"."Booking"
  ADD COLUMN "packageDepartureStationId" TEXT;

-- AlterTable: add package_departure_station_id to PackageBooking
ALTER TABLE "passenger"."PackageBooking"
  ADD COLUMN "packageDepartureStationId" TEXT;

-- AddForeignKey: Booking -> Station
ALTER TABLE "passenger"."Booking"
  ADD CONSTRAINT "Booking_packageDepartureStationId_fkey"
  FOREIGN KEY ("packageDepartureStationId")
  REFERENCES "passenger"."Station"("id")
  ON DELETE SET NULL ON UPDATE CASCADE;

-- AddForeignKey: PackageBooking -> Station
ALTER TABLE "passenger"."PackageBooking"
  ADD CONSTRAINT "PackageBooking_packageDepartureStationId_fkey"
  FOREIGN KEY ("packageDepartureStationId")
  REFERENCES "passenger"."Station"("id")
  ON DELETE SET NULL ON UPDATE CASCADE;
