hellodb
.io
Hide sidebar
B
e_commerce
Project settings
,
v0
No versions yet
MODELS · 9
/
address
8
cart
5
cart_item
6
order
9
order_item
7
payment
7
product
7
product_variant
8
user
6
10 refs · 63 fields
user
6
PK
id
uuid
email
varchar
full_name
varchar
phone
varchar?
role
enum
created_at
timestamp
address
8
PK
id
uuid
FK
user_id
uuid
line1
varchar
line2
varchar?
city
varchar
postal_code
varchar
country
varchar
is_default
boolean
product
7
PK
id
uuid
name
varchar
slug
varchar
description
text?
brand
varchar?
status
enum
created_at
timestamp
product_variant
8
PK
id
uuid
FK
product_id
uuid
sku
varchar
option_name
varchar
option_value
varchar
price
decimal
stock_quantity
int
is_active
boolean
cart
5
PK
id
uuid
FK
user_id
uuid
status
enum
created_at
timestamp
updated_at
timestamp
cart_item
6
PK
id
uuid
FK
cart_id
uuid
FK
product_variant_id
uuid
quantity
int
unit_price
decimal
added_at
timestamp
order
9
PK
id
uuid
FK
user_id
uuid
FK
address_id
uuid
order_number
varchar
status
enum
subtotal
decimal
shipping_fee
decimal
total
decimal
placed_at
timestamp
order_item
7
PK
id
uuid
FK
order_id
uuid
FK
product_variant_id
uuid
product_name
varchar
quantity
int
unit_price
decimal
line_total
decimal
payment
7
PK
id
uuid
FK
order_id
uuid
method
enum
provider_reference
varchar
amount
decimal
status
enum
created_at
timestamp
Models
Names only
1
Relations
Foreign keys
2
Fields
Every field
3
Fit to screen
Space
Export
Exit preview
Exit preview
P
Report an issue
Zoom out
-
110%
Zoom in
=
Opening E-commerce