Data model

The Keystone lists in Openfront Rideshare and how they relate.

38 lists in features/keystone/models. Create and delete are closed on tenant lists; records are created through named mutations. Money is integer minor units.

DomainLists
IdentityUser, Role, Fleet, FleetMembership, DriverProfile, RiderProfile, FleetBrandingChange
OperationsVehicle, ComplianceDocument, Policy, PolicyEvaluation, ProviderConnection
ServiceServiceArea, RideService, AvailabilityRule, AvailabilityException, FareRule, RideQuote
RideRideRequest, RequestCancellationCommand, MatchOffer, Trip, TripEvent, LocationEvent, Cancellation
SafetySafetyIncident, SupportCase, Conversation, Message, Review
FinancePaymentProvider, Payment, Refund, PaymentObservation, LedgerEntry, Payout
IntegrationNotification, MarketplaceRegistration

Relationships

  • Fleet has memberships, drivers, vehicles, service areas, services, fare rules, rides, trips, policies, provider connections, and a marketplace registration.
  • RideService links to many ServiceArea rows; a FareRule prices one service in one area.
  • RideQuote snapshots the fare rule and links to one RideRequest.
  • RideRequest has many MatchOffer rows and at most one Trip.
  • An accepted MatchOffer creates the Trip, which links rider, driver, vehicle, TripEvent, LocationEvent, Cancellation, Payment, LedgerEntry, SafetyIncident, SupportCase, Conversation, and Review.
  • Payment has many Refund, LedgerEntry, and PaymentObservation rows.
  • DriverProfile and Vehicle have ComplianceDocument and PolicyEvaluation rows; vehicles link to many drivers.

Key statuses

ListStatus values
Fleetsetup, active, paused
DriverProfileapplicant, pending_review, active, paused, ineligible, offboarded
Vehiclepending_review, active, maintenance, suspended, retired
RideRequestrequested, matching, matched, cancelled, expired
MatchOfferoffered, accepted, declined, expired, withdrawn
Tripdriver_assigned, driver_en_route, driver_arrived, in_progress, completed, cancelled, no_show
Paymentpending, authorized, captured, failed, partially_refunded, refunded, cancelled
RideQuoteactive, accepted, expired, void

On this page