← All features
product

Rate cards per vehicle

Different rates per car, per package, per date — without spreadsheets.

Every car has a price per package (hourly / daily / weekly / monthly) with an effective_at date. Rent agreement creation pulls the current rate automatically from the right card.

  • car_rent_policies + car_rent_policy_details tables
  • Historical rates preserved (effective_at index)
  • Rates stored as NUMERIC(12,2) — no rounding surprise
  • UI lives in the car detail "Rate card" tab

How it works

On rent create: SELECT rate FROM car_rent_policy_details JOIN car_rent_policies WHERE car_id = ? AND package_id = ? AND effective_at ≤ rent.start ORDER BY effective_at DESC LIMIT 1.

Edit rates on any car detail page.

More product features