hellodb.io
MODELS · 28
/
46 refs · 212 fields
user
9
PK
id
uuid
email
varchar
full_name
varchar
phone
varchar?
FK
referred_by_id
uuid?
is_prime
boolean
status
enum
created_at
timestamp
deleted_at
timestamp?
address
10
PK
id
uuid
FK
user_id
uuid
label
enum
line1
varchar
line2
varchar?
city
varchar
postal_code
varchar
country_code
varchar
is_default
boolean
created_at
timestamp
wishlist
6
PK
id
uuid
FK
user_id
uuid
name
varchar
visibility
enum
is_default
boolean
created_at
timestamp
wishlist_item
6
PK
id
uuid
FK
wishlist_id
uuid
FK
product_variant_id
uuid
note
text?
priority
enum
added_at
timestamp
subscription
8
PK
id
uuid
FK
user_id
uuid
tier
enum
billing_period
enum
status
enum
started_at
timestamp
renews_at
timestamp
cancelled_at
timestamp?
category
7
PK
id
uuid
FK
parent_category_id
uuid?
name
varchar
slug
varchar
path
text
depth
int
is_leaf
boolean
product
9
PK
id
uuid
FK
category_id
uuid
brand
varchar
title
varchar
description
text
average_rating
decimal
is_adult
boolean
created_at
timestamp
deleted_at
timestamp?
product_variant
8
PK
id
uuid
FK
product_id
uuid
sku
varchar
colour
varchar?
size
varchar?
attributes
jsonb
weight_grams
int
is_active
boolean
seller
8
PK
id
uuid
FK
user_id
uuid
display_name
varchar
legal_name
varchar
country_code
varchar
feedback_rating
decimal
status
enum
joined_at
timestamp
listing
10
PK
id
uuid
FK
product_variant_id
uuid
FK
seller_id
uuid
condition
enum
price
decimal
currency
varchar
fulfillment
enum
is_buy_box_winner
boolean
status
enum
created_at
timestamp
warehouse
7
PK
id
uuid
code
varchar
name
varchar
city
varchar
country_code
varchar
capacity_units
int
is_active
boolean
inventory
7
PK
id
uuid
FK
listing_id
uuid
FK
warehouse_id
uuid
quantity_on_hand
int
quantity_reserved
int
restock_eta
date?
updated_at
timestamp
cart
6
PK
id
uuid
FK
user_id
uuid
status
enum
currency
varchar
created_at
timestamp
updated_at
timestamp
cart_item
6
PK
id
uuid
FK
cart_id
uuid
FK
listing_id
uuid
quantity
int
unit_price_snapshot
decimal
added_at
timestamp
order
9
PK
id
uuid
FK
user_id
uuid
FK
shipping_address_id
uuid
FK
coupon_id
uuid?
status
enum
subtotal
decimal
total
decimal
currency
varchar
placed_at
timestamp
order_item
8
PK
id
uuid
FK
order_id
uuid
FK
listing_id
uuid
FK
seller_id
uuid
quantity
int
unit_price
decimal
tax_amount
decimal
status
enum
shipment
8
PK
id
uuid
FK
order_id
uuid
FK
warehouse_id
uuid
carrier
varchar
tracking_number
varchar
status
enum
shipped_at
timestamp?
estimated_arrival
date
shipment_item
4
PK
id
uuid
FK
shipment_id
uuid
FK
order_item_id
uuid
quantity
int
delivery
8
PK
id
uuid
FK
shipment_id
uuid
delivered_at
timestamp
received_by
varchar?
proof_photo_url
text?
latitude
decimal
longitude
decimal
attempt_count
int
payment
9
PK
id
uuid
FK
order_id
uuid
FK
user_id
uuid
method
enum
amount
decimal
currency
varchar
status
enum
gateway_reference
varchar
processed_at
timestamp
return_request
8
PK
id
uuid
FK
order_item_id
uuid
FK
user_id
uuid
reason
enum
resolution
enum
status
enum
requested_at
timestamp
received_at
timestamp?
refund
7
PK
id
uuid
FK
payment_id
uuid
FK
return_request_id
uuid?
amount
decimal
reason
enum
status
enum
created_at
timestamp
coupon
9
PK
id
uuid
FK
seller_id
uuid?
code
varchar
discount_type
enum
discount_value
decimal
min_order_value
decimal
max_redemptions
int
starts_at
timestamp
expires_at
timestamp
review
9
PK
id
uuid
FK
product_id
uuid
FK
user_id
uuid
FK
order_item_id
uuid?
rating
int
title
varchar
body
text
is_verified_purchase
boolean
created_at
timestamp
review_vote
5
PK
id
uuid
FK
review_id
uuid
FK
user_id
uuid
is_helpful
boolean
created_at
timestamp
question
6
PK
id
uuid
FK
product_id
uuid
FK
user_id
uuid
body
text
answer_count
int
created_at
timestamp
answer
7
PK
id
uuid
FK
question_id
uuid
FK
user_id
uuid
body
text
is_seller_answer
boolean
upvotes
int
created_at
timestamp
recommendation
8
PK
id
uuid
FK
user_id
uuid
FK
product_id
uuid
surface
enum
score
decimal
model_version
varchar
embedding
vector
generated_at
timestamp
81%
Opening Amazon