Railway Reservation Upgrade: AI-Powered Booking System to Tell Passengers the Chances of Waiting Tickets Getting Confirmed ...
-- Creates the three dimension tables for the star schema. -- dim_carrier: 4 rows - one per carrier in the dataset -- dim_airport: 4 rows - one per origin airport (NOT destinations) ...
-- 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 ...