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