uber

Tables (7)

credit_card

  • Key — Primary key — NOT NULL

driver

  • driver_id (driverId) — Primary key — NOT NULL
  • state
  • email
  • name
  • password
  • createdDateTime
  • deletedDateTiem (deletedDateTime)

favorite_location

  • favorite_location_id — Primary key — NOT NULL
  • passenger_id — Foreign key → passenger.passenger_id — NOT NULL
  • name
  • address
  • latitude
  • longitude
  • type
  • icon
  • deletedDateTime
  • createdDateTime

location

  • Key — Primary key — NOT NULL
  • Field

match

  • match_id — Primary key — NOT NULL
  • driver_id — Foreign key → driver.driver_id — NOT NULL
  • passenger_id — Foreign key → passenger.passenger_id — NOT NULL
  • ride_state
  • start_point
  • end_point
  • createdDateTime
  • completedDateTime
  • acceptedDateTime
  • estimatedAmount
  • paymentMethod

passenger

  • passenger_id — Primary key — NOT NULL
  • email
  • name
  • password
  • createdDateTime
  • deletedDateTime

payment

  • payment_id — Primary key — NOT NULL
  • match_id — Foreign key → match.match_id — NOT NULL
  • driver_id — Foreign key → match.driver_id — NOT NULL
  • passenger_id — Foreign key → match.passenger_id — NOT NULL
  • amount
  • createdDateTime
  • pg_provider