-- Review rating must be 1-5
ALTER TABLE "Review" ADD CONSTRAINT review_rating_check
  CHECK (rating >= 1 AND rating <= 5);

-- Group size must be positive when set
ALTER TABLE "Reservation" ADD CONSTRAINT reservation_group_size_check
  CHECK ("groupSize" IS NULL OR "groupSize" > 0);

-- Package discount 0-100%
ALTER TABLE "ServicePackage" ADD CONSTRAINT package_discount_check
  CHECK ("discountPercent" >= 0 AND "discountPercent" <= 100);

-- Offer discount 0-100%
ALTER TABLE "CustomerOffer" ADD CONSTRAINT offer_discount_check
  CHECK ("discountPercent" IS NULL OR ("discountPercent" >= 0 AND "discountPercent" <= 100));

-- Waiting list priority non-negative
ALTER TABLE "WaitingList" ADD CONSTRAINT waiting_list_priority_check
  CHECK (priority >= 0);
