hellodb.io
MODELS · 17
/
34 refs · 148 fields
user
8
PK
_id
objectid
full_name
varchar
email
varchar
phone
varchar
FK
default_address_id
objectid?
loyalty_tier
enum
status
enum
created_at
timestamp
address
9
PK
_id
objectid
FK
user_id
objectid
label
enum
line1
varchar
city
varchar
postal_code
varchar
geo
object
delivery_note
text?
is_default
boolean
{ }
geo
object
type
varchar
coordinates
decimal[]
restaurant
10
PK
_id
objectid
name
varchar
slug
varchar
cuisines
varchar[]
address
object
opening_hours
object[]
commission_rate
decimal
rating_average
decimal
status
enum
created_at
timestamp
{ }
address
object
line1
varchar
city
varchar
postal_code
varchar
{}
geo
object
{ }
geo
object
type
varchar
coordinates
decimal[]
{ }
opening_hours
object[]
day_of_week
enum
opens_at
varchar
closes_at
varchar
is_closed
boolean
menu
8
PK
_id
objectid
FK
restaurant_id
objectid
name
varchar
service_type
enum
available_from
varchar
available_to
varchar
is_active
boolean
updated_at
timestamp
menu_item
10
PK
_id
objectid
FK
menu_id
objectid
FK
restaurant_id
objectid
name
varchar
price
decimal
currency
varchar
modifier_groups
object[]
dietary_tags
varchar[]
availability
enum
updated_at
timestamp
{ }
modifier_groups
object[]
group_id
objectid
name
varchar
min_select
int
max_select
int
{}
options
object[]
{ }
options
object[]
option_id
objectid
name
varchar
price_delta
decimal
is_available
boolean
cart
8
PK
_id
objectid
FK
user_id
objectid
FK
restaurant_id
objectid
FK
promotion_id
objectid?
item_count
int
subtotal
decimal
status
enum
updated_at
timestamp
order
10
PK
_id
objectid
FK
user_id
objectid
FK
restaurant_id
objectid
FK
cart_id
objectid?
order_code
varchar
status
enum
line_items
object[]
delivery_address
object
totals
object
placed_at
timestamp
{ }
line_items
object[]
line_id
objectid
menu_item_id
objectid
name_snapshot
varchar
quantity
int
unit_price
decimal
line_total
decimal
{}
selected_modifiers
object[]
{ }
selected_modifiers
object[]
option_id
objectid
name_snapshot
varchar
price_delta
decimal
{ }
delivery_address
object
line1
varchar
city
varchar
postal_code
varchar
delivery_note
text?
{}
geo
object
{ }
geo
object
type
varchar
coordinates
decimal[]
{ }
totals
object
subtotal
decimal
delivery_fee
decimal
packaging_fee
decimal
tax
decimal
discount
decimal
grand_total
decimal
currency
varchar
rider
8
PK
_id
objectid
full_name
varchar
phone
varchar
vehicle_type
enum
city
varchar
onboarding_status
enum
rating_average
decimal
created_at
timestamp
rider_shift
8
PK
_id
objectid
FK
rider_id
objectid
zone
varchar
started_at
timestamp
ended_at
timestamp?
deliveries_completed
int
earnings
decimal
status
enum
delivery
10
PK
_id
objectid
FK
order_id
objectid
FK
rider_id
objectid?
FK
rider_shift_id
objectid?
status
enum
assigned_at
timestamp?
picked_up_at
timestamp?
delivered_at
timestamp?
distance_km
decimal
rider_payout
decimal
rider_location
8
PK
_id
objectid
FK
rider_id
objectid
FK
delivery_id
objectid?
location
object
heading_degrees
decimal
speed_kph
decimal
battery_pct
int
recorded_at
timestamp
{ }
location
object
type
varchar
coordinates
decimal[]
payment
9
PK
_id
objectid
FK
order_id
objectid
FK
user_id
objectid
method
enum
amount
decimal
currency
varchar
status
enum
provider_reference
varchar
captured_at
timestamp?
refund
8
PK
_id
objectid
FK
payment_id
objectid
FK
order_id
objectid
reason
enum
amount
decimal
status
enum
requested_at
timestamp
completed_at
timestamp?
promotion
10
PK
_id
objectid
code
varchar
FK
restaurant_id
objectid?
discount_type
enum
discount_value
decimal
min_order_value
decimal
max_discount
decimal
usage_limit_per_user
int
valid_from
timestamp
valid_to
timestamp
promotion_redemption
6
PK
_id
objectid
FK
promotion_id
objectid
FK
user_id
objectid
FK
order_id
objectid
discount_applied
decimal
redeemed_at
timestamp
rating
9
PK
_id
objectid
FK
order_id
objectid
FK
user_id
objectid
target
enum
FK
restaurant_id
objectid?
FK
rider_id
objectid?
score
int
comment
text?
created_at
timestamp
support_ticket
9
PK
_id
objectid
FK
user_id
objectid
FK
order_id
objectid?
FK
refund_id
objectid?
category
enum
priority
enum
status
enum
opened_at
timestamp
resolved_at
timestamp?
81%
Opening Food Delivery