Database Schema

Jump to bottom

Marcus Dunn edited this page Apr 8, 2022 · 3 revisions

Users
- id
  - name: The display name of the User
  - authProvider: Google, Facebook, or Email/Password supported
  - email: The email address of the User
  - cars: The set of cars the User has added to their profile
    - id
      - type: string
      - fuelUsage: number
      - numSeats: number
      - displayName: string
Groups
- id
  - name: The display name of the Group
  - description: A short description that shows at the top of the Group page
  - isPrivate: Is the group private, which means it does not appear in search results
  - banner?: The banner image
  - owner: The ID of the User that created the Group, and is responsible for billing in Premium Groups
  - members: List of IDs of Group members
  - rides: List of IDs of child Rides
Rides
- id
  - name: The display name of the Group
  - start: A reference to the Pickup Point entered by the passenger that created the ride, or the driver's start location
  - end: The destination of the Ride
  - driver: The ID of the User that is driving, if present
  - isComplete: Flag that the Driver has marked the Ride as completed
  - carId: The ID of the Driver's Car
  - startDate: The date and time that the Driver is leaving
Passengers
- id: The ID of a Ride
  - id: List of IDs of Passengers and Driver for the Ride
Routes
- id: The ID of a Ride
  - distance: The distance in kilometres of the entire Ride
  - shape: The geometry object of the Ride following streets and roads