Skip to content
DBML templates

DBML — marketplace schema

Users, listings, orders, reviews.

Template previewDBML
listings.seller_id > users.idorders.buyer_id > users.idorders.listing_id > listings.idreviews.order_id > orders.idusersiduuidemailvarcharcreated_attimestamplistingsiduuidseller_iduuidtitlevarcharprice_centsintordersiduuidbuyer_iduuidlisting_iduuidstatusvarcharreviewsiduuidorder_iduuidstarsintbodytext

Make it your own.

Table users { id uuid [pk]; email varchar; created_at timestamp }
Table listings { id uuid [pk]; seller_id uuid [ref: > users.id]; title varchar; price_cents int }
Table orders { id uuid [pk]; buyer_id uuid [ref: > users.id]; listing_id uuid [ref: > listings.id]; status varchar }
Table reviews { id uuid [pk]; order_id uuid [ref: > orders.id]; stars int; body text }