Database Schema

Jump to bottom

Doug Johnson edited this page Mar 5, 2022 · 3 revisions

Users
- id
  - name: string
  - authProvider: "google" | "local"
  - email: string
  - cars: Vehicle[]
    - id
      - type: string
      - fuelUsage: number
      - numSeats: number
      - displayName: string
Groups
- id
  - name: string
  - description: string
  - isPrivate: boolean
  - banner?: string
  - owner: string
  - members: string[]
  - rides: string[]
Rides
- id
  - name: string
  - start
    - lat: number
    - lng: number
  - end
    - lat: number
    - lng: number
  - driver: string
  - isComplete: boolean
  - carId: string
  - startDate: string
  - endDate: string
Passengers
- id IN Rides
  - id IN Users
Routes
- id IN Rides
  - distance: number
  - shape: LatLng[]
    - lat: number
    - lng: number