RideGo schema

All tables live in the ridego schema, so write ridego.riders in your queries.

ridego.riders

One row per rider (customer).

• rider_id (INT) — PK
• first_name (VARCHAR(50))
• last_name (VARCHAR(50))
• email (VARCHAR(120))
• phone (VARCHAR(15))
• signup_date (TIMESTAMP)
• city (VARCHAR(40)) — home city at signup
• rating (DECIMAL(2,1)) — average rating given by drivers, 1 to 5

ridego.drivers

One row per driver.

• driver_id (INT) — PK
• first_name (VARCHAR(50))
• last_name (VARCHAR(50))
• email (VARCHAR(120))
• vehicle_type (VARCHAR(20)) — 'sedan', 'hatchback', 'suv', 'auto', 'motorbike'
• vehicle_number (VARCHAR(20))
• signup_date (TIMESTAMP)
• status (VARCHAR(20)) — 'active', 'deactivated', 'pending'
• city (VARCHAR(40)) — primary operating city
• rating (DECIMAL(2,1)) — average rating from riders, 1 to 5

ridego.trips

One row per ride request, whether or not it was completed.

• trip_id (INT) — PK
• rider_id (INT) — FK → riders.rider_id
• driver_id (INT) — FK → drivers.driver_id; nullable; NULL when no driver accepted
• request_time (TIMESTAMP)
• pickup_time (TIMESTAMP) — nullable; NULL if the trip never started
• dropoff_time (TIMESTAMP) — nullable; NULL unless completed
• pickup_city (VARCHAR(40))
• dropoff_city (VARCHAR(40))
• distance_km (DECIMAL(6,1))
• status (VARCHAR(20)) — 'completed', 'rider_cancelled', 'driver_cancelled', 'no_driver', 'system_cancelled'
• fare_amount (DECIMAL(10,2)) — nullable; fare charged to the rider; NULL unless completed
• surge_multiplier (DECIMAL(3,1)) — 1.0 means no surge

ridego.payments

Payment attempts. A completed trip can have a failed attempt followed by a successful one.

• payment_id (INT) — PK
• trip_id (INT) — FK → trips.trip_id
• amount (DECIMAL(10,2))
• payment_method (VARCHAR(20)) — 'card', 'upi', 'wallet', 'cash_recorded'
• payment_status (VARCHAR(20)) — 'success', 'failed', 'refunded'
• created_at (TIMESTAMP)

ridego.driver_earnings

One row per completed trip: what the driver earned.

• earning_id (INT) — PK
• driver_id (INT) — FK → drivers.driver_id
• trip_id (INT) — FK → trips.trip_id
• base_fare (DECIMAL(10,2))
• distance_fare (DECIMAL(10,2))
• surge_earnings (DECIMAL(10,2))
• commission_amount (DECIMAL(10,2)) — platform commission
• payout_amount (DECIMAL(10,2)) — amount paid to the driver
• payout_date (DATE)

ridego.driver_locations

Periodic GPS pings from online drivers. High volume; usually aggregated by city and time bucket.

• ping_id (BIGINT) — PK
• driver_id (INT) — FK → drivers.driver_id
• recorded_at (TIMESTAMP)
• latitude (DECIMAL(9,6))
• longitude (DECIMAL(9,6))
• city (VARCHAR(40))