Skip to content

svc-transport-logistics

NovaTrek Transport Logistics API  |  Logistics  |  v1.4.0  |  NovaTrek Platform Engineering

Manages shuttle buses, van pickups, and transport coordination between NovaTrek

Swagger UI Download OpenAPI Spec

Integration Context

⤢svc-transport-logistics C4 context diagram

Data Store

Overview

Property Detail
Engine PostgreSQL 15
Schema transport
Tables routes, route_schedules, transport_requests, vehicles
Estimated Volume ~300 transport requests/day
Connection Pool min 3 / max 10 / idle timeout 10min
Backup Strategy Daily pg_dump, 14-day retention

Key Features

  • Time-window optimization for route scheduling
  • Vehicle capacity tracking with overbooking prevention
  • GPS coordinate storage for pickup and dropoff points

Table Reference

vehicles

Fleet vehicles with capacity and maintenance status

Column Type Constraints
vehicle_id UUID PK
registration VARCHAR(20) NOT NULL, UNIQUE
vehicle_type VARCHAR(30) NOT NULL
capacity INTEGER NOT NULL
status VARCHAR(20) NOT NULL, DEFAULT 'available'
current_location POINT NULL
last_service_date DATE NULL

Indexes:

  • idx_vehicle_status on status
  • idx_vehicle_type on vehicle_type

transport_requests

Guest and staff transport requests with pickup windows

Column Type Constraints
request_id UUID PK
route_id UUID NOT NULL, FK -> routes
vehicle_id UUID NULL, FK -> vehicles
passenger_count INTEGER NOT NULL
pickup_time TIMESTAMPTZ NOT NULL
pickup_location POINT NOT NULL
dropoff_location POINT NOT NULL
status VARCHAR(20) NOT NULL
created_at TIMESTAMPTZ NOT NULL

Indexes:

  • idx_treq_route on route_id
  • idx_treq_pickup on pickup_time
  • idx_treq_vehicle on vehicle_id

Endpoints (7 total)

GET /routes -- List transport routes

Returns available transport routes with optional filtering by origin, destination, or active status.

View in Swagger UI

⤢GET /routes sequence diagram

POST /routes -- Create a new transport route

View in Swagger UI

⤢POST /routes sequence diagram

GET /routes/{route_id}/schedule -- Get schedule for a transport route

Returns the daily schedule of departures for a given route, optionally filtered by date range.

View in Swagger UI

⤢GET /routes/{route_id}/schedule sequence diagram

POST /transport-requests -- Request transport for a reservation

Creates a transport request linked to an existing reservation

View in Swagger UI

⤢POST /transport-requests sequence diagram

GET /transport-requests/{request_id} -- Get transport request details

View in Swagger UI

⤢GET /transport-requests/{request_id} sequence diagram

GET /vehicles -- List fleet vehicles

View in Swagger UI

⤢GET /vehicles sequence diagram

PATCH /vehicles/{vehicle_id} -- Update vehicle information

View in Swagger UI

⤢PATCH /vehicles/{vehicle_id} sequence diagram

Consuming Applications

Application Screens Using This Service
Operations Dashboard Transport Dispatch