hellodb.io
MODELS · 12
/
18 refs · 105 fields
user
8
PK
id
uuid
full_name
varchar
email
varchar?
phone
varchar
FK
referred_by_id
uuid?
status
enum
created_at
timestamp
deleted_at
timestamp?
driver
9
PK
id
uuid
FK
user_id
uuid
licence_number
varchar
licence_expires_on
date
onboarding_status
enum
rating_average
decimal
trips_completed
int
home_city
varchar
approved_at
timestamp?
vehicle
10
PK
id
uuid
plate_number
varchar
make
varchar
model
varchar
year
int
colour
varchar
seat_count
int
category
enum
inspection_expires_on
date
created_at
timestamp
driver_vehicle
6
PK
id
uuid
FK
driver_id
uuid
FK
vehicle_id
uuid
is_primary
boolean
assigned_at
timestamp
released_at
timestamp?
trip
10
PK
id
uuid
FK
rider_id
uuid
FK
driver_id
uuid?
FK
vehicle_id
uuid?
status
enum
product
enum
distance_km
decimal?
requested_at
timestamp
started_at
timestamp?
ended_at
timestamp?
trip_waypoint
8
PK
id
uuid
FK
trip_id
uuid
sequence
int
kind
enum
address
varchar
latitude
decimal
longitude
decimal
arrived_at
timestamp?
fare_breakdown
10
PK
id
uuid
FK
trip_id
uuid
FK
surge_zone_id
uuid?
currency
varchar
base_fare
decimal
distance_fare
decimal
time_fare
decimal
surge_multiplier
decimal
tolls_and_fees
decimal
total
decimal
payment_method
9
PK
id
uuid
FK
user_id
uuid
kind
enum
brand
varchar?
last_four
varchar?
expires_on
date?
is_default
boolean
created_at
timestamp
deleted_at
timestamp?
payment
10
PK
id
uuid
FK
trip_id
uuid
FK
payment_method_id
uuid
amount
decimal
currency
varchar
status
enum
processor_reference
varchar?
failure_reason
varchar?
captured_at
timestamp?
created_at
timestamp
rating
8
PK
id
uuid
FK
trip_id
uuid
FK
rater_id
uuid
FK
ratee_id
uuid
score
int
comment
text?
tags
varchar[]?
created_at
timestamp
surge_zone
8
PK
id
uuid
city
varchar
name
varchar
geohash_prefix
varchar
multiplier
decimal
effective_from
timestamp
effective_to
timestamp?
created_at
timestamp
driver_location
9
PK
id
uuid
FK
driver_id
uuid
FK
vehicle_id
uuid?
latitude
decimal
longitude
decimal
heading_degrees
decimal?
speed_kph
decimal?
availability
enum
recorded_at
timestamp
110%
Opening Uber