nuber

Tables (6)

chat

  • id — integer — Primary key — NOT NULL
  • passengerId — integer
  • rideId — integer
  • driverId — integer
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • id (id2) — integer — Foreign key → ride.id — NOT NULL

message

  • id — integer — Primary key — NOT NULL
  • text — text — NOT NULL
  • chatId — integer
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • userId — integer
  • id (id2) — integer — Foreign key → chat.id — NOT NULL

place

  • id — integer — Primary key — NOT NULL
  • name — text — NOT NULL
  • lat — double — NOT NULL
  • lng — double — NOT NULL
  • address — text — NOT NULL
  • isFav — boolean — NOT NULL
  • userId — integer
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • id (id2) — integer — Foreign key → user.id — NOT NULL
  • id (id3) — integer — Foreign key → ride.id — NOT NULL

ride

  • id — integer — Primary key — NOT NULL
  • status — text — NOT NULL
  • pickUpAddress — text — NOT NULL
  • pickUpLat — double — NOT NULL
  • pickUpLng — double — NOT NULL
  • dropOffAddress — text — NOT NULL
  • dropOffLat — double — NOT NULL
  • dropOffLng — double — NOT NULL
  • price — double — NOT NULL
  • distance — text — NOT NULL
  • duration — text — NOT NULL
  • passengerId — integer
  • driverId — integer
  • chatId — integer
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • id (id2) — integer — Foreign key → user.id — NOT NULL

user

  • id — integer — Primary key — NOT NULL
  • email — text
  • verifiedEmail — boolean — NOT NULL
  • firstName — text — NOT NULL
  • lastName — text — NOT NULL
  • age — integer
  • password — text
  • phoneNumber — text
  • verifiedPhoneNumber — boolean — NOT NULL
  • profilePhoto — text — NOT NULL
  • isDriving — boolean — NOT NULL
  • isRiding — boolean — NOT NULL
  • isTaken — boolean — NOT NULL
  • lastLng — double — NOT NULL
  • lastLat — double — NOT NULL
  • lastOrientation — double — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • fbId — text

verification

  • id — integer — Primary key — NOT NULL
  • target — text — NOT NULL
  • payload — text — NOT NULL
  • verified — boolean — NOT NULL
  • createdAt — timestamp — NOT NULL
  • updatedAt — timestamp — NOT NULL
  • id (id2) — integer — Foreign key → user.id — NOT NULL