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 Live Service (Dev) Azure Portal CI/CD Pipeline Source Code Technology Stack
Delivery Status¶
Delivery Wave: 4 -- Guide and Transport Operations
| Stage | Status |
|---|---|
| Infrastructure (Bicep) |  complete |
| Database Schema (Flyway) | complete |
| Deployed to Dev | complete |
| Smoke Tested | complete |
| Deployed to Prod | not-started |
| Pipeline | Status |
|---|---|
| CI Pipeline | complete |
| CD Pipeline | complete |
Azure Resources (Dev):
Integration Context¶
Generated from architecture/specs/svc-transport-logistics.yaml + cross-service-calls.yaml
Data Store¶
Entity Relationship Diagram¶
Generated from architecture/metadata/data-stores.yaml
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_statusonstatusidx_vehicle_typeonvehicle_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_routeonroute_ididx_treq_pickuponpickup_timeidx_treq_vehicleonvehicle_id
Endpoints (7 total)¶
GET /routes -- List transport routes¶
Returns available transport routes with optional filtering by origin, destination, or active status.
Generated from architecture/specs/svc-transport-logistics.yaml Auto-generated baseline — shows standard request flow. For detailed behavioral sequences, see the relevant solution design.
POST /routes -- Create a new transport route¶
Generated from architecture/specs/svc-transport-logistics.yaml Auto-generated baseline — shows standard request flow. For detailed behavioral sequences, see the relevant solution design.
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.
Generated from architecture/specs/svc-transport-logistics.yaml Auto-generated baseline — shows standard request flow. For detailed behavioral sequences, see the relevant solution design.
POST /transport-requests -- Request transport for a reservation¶
Creates a transport request linked to an existing reservation
Architect-authored — overrides auto-generated baseline Source: architecture/diagrams/endpoints/svc-transport-logistics--post-transport-requests.puml
GET /transport-requests/{request_id} -- Get transport request details¶
Generated from architecture/specs/svc-transport-logistics.yaml Auto-generated baseline — shows standard request flow. For detailed behavioral sequences, see the relevant solution design.
GET /vehicles -- List fleet vehicles¶
Generated from architecture/specs/svc-transport-logistics.yaml Auto-generated baseline — shows standard request flow. For detailed behavioral sequences, see the relevant solution design.
PATCH /vehicles/{vehicle_id} -- Update vehicle information¶
Generated from architecture/specs/svc-transport-logistics.yaml Auto-generated baseline — shows standard request flow. For detailed behavioral sequences, see the relevant solution design.
Consuming Applications¶
| Application | Screens Using This Service |
|---|---|
| Operations Dashboard | Transport Dispatch |