Railway Reservation Upgrade: AI-Powered Booking System to Tell Passengers the Chances of Waiting Tickets Getting Confirmed ...
-- and one-per-day invariants, plus RLS. create table if not exists public.reservations ( -- Server-set; the First-Come-First-Serve tiebreaker (PROJECT_SPEC §6). created_at timestamptz not null ...
-- Auto-cancel past-day no-show reservations even when nobody opens the app. -- Mirrors the app's lazy sweep (cancelStaleReservations) so it also fires on a -- schedule. pg_cron evaluates the schedule ...