Home E-commerceMarketplace

Marketplace

Multi-vendor marketplace with seller management, commissions, disputes, and product approval workflows

SchemaVerse

E-commercePostgreSQLMulti-tenantAudit LogE-commerce

marketplace.dbml

15 tables|26 relations

users

idinteger

emailvarchar(255)

*UQ

password_hashvarchar(255)

first_namevarchar(100)

last_namevarchar(100)

phonevarchar(20)

created_attimestamp

updated_attimestamp

sellers

idinteger

user_idinteger

FK*UQ

business_namevarchar(255)

business_emailvarchar(255)

tax_idvarchar(50)

verification_statusvarchar(20)

verified_attimestamp

is_activeboolean

created_attimestamp

updated_attimestamp

seller_profiles

idinteger

seller_idinteger

FK*UQ

biotext

logo_urlvarchar(500)

banner_urlvarchar(500)

websitevarchar(255)

return_policytext

shipping_policytext

avg_ratingdecimal(3,2)

total_salesinteger

created_attimestamp

updated_attimestamp

categories

idinteger

namevarchar(100)

slugvarchar(100)

*UQ

parent_idinteger

commission_ratedecimal(5,2)

created_attimestamp

products

idinteger

seller_idinteger

FK*

category_idinteger

FK*

namevarchar(255)

slugvarchar(255)

*UQ

descriptiontext

pricedecimal(10,2)

stock_quantityinteger

skuvarchar(100)

statusvarchar(20)

created_attimestamp

updated_attimestamp

product_images

idinteger

product_idinteger

FK*

urlvarchar(500)

alt_textvarchar(255)

display_orderinteger

created_attimestamp

orders

idinteger

user_idinteger

FK*

order_numbervarchar(50)

*UQ

statusvarchar(20)

subtotaldecimal(10,2)

platform_feedecimal(10,2)

total_amountdecimal(10,2)

payment_statusvarchar(20)

created_attimestamp

updated_attimestamp

order_items

idinteger

order_idinteger

FK*

product_idinteger

FK*

seller_idinteger

FK*

quantityinteger

unit_pricedecimal(10,2)

total_pricedecimal(10,2)

commission_amountdecimal(10,2)

seller_payout_amountdecimal(10,2)

statusvarchar(20)

tracking_numbervarchar(100)

created_attimestamp

reviews

idinteger

product_idinteger

FK*

user_idinteger

FK*

order_item_idinteger

ratinginteger

commenttext

is_verified_purchaseboolean

created_attimestamp

updated_attimestamp

seller_ratings

idinteger

seller_idinteger

FK*

user_idinteger

FK*

order_idinteger

ratinginteger

commenttext

created_attimestamp

commissions

idinteger

order_item_idinteger

FK*

seller_idinteger

FK*

commission_ratedecimal(5,2)

commission_amountdecimal(10,2)

statusvarchar(20)

created_attimestamp

seller_payouts

idinteger

seller_idinteger

FK*

payout_amountdecimal(10,2)

period_startdate

period_enddate

statusvarchar(20)

payment_methodvarchar(50)

transaction_idvarchar(100)

paid_attimestamp

created_attimestamp

refunds

idinteger

order_item_idinteger

FK*

amountdecimal(10,2)

reasontext

statusvarchar(20)

processed_attimestamp

created_attimestamp

disputes

idinteger

order_item_idinteger

FK*

user_idinteger

FK*

seller_idinteger

FK*

reasonvarchar(100)

descriptiontext

statusvarchar(20)

resolutiontext

resolved_attimestamp

created_attimestamp

updated_attimestamp

messages

idinteger

sender_idinteger

FK*

recipient_idinteger

FK*

product_idinteger

subjectvarchar(255)

bodytext

is_readboolean

created_attimestamp

React Flow

About this Schema

Overview

A two-sided marketplace database schema similar to Etsy or Amazon Marketplace. Enables multiple sellers to list products while the platform manages transactions, commissions, and dispute resolution.

Key Design Decisions

Seller Accounts: Separate seller profiles with verification status and commission rates
Product Approval: Admin approval workflow for new listings
Commission Tracking: Automatic commission calculation on each order
Dispute Resolution: Built-in system for handling buyer-seller conflicts

Tables

16 tables including seller profiles, product listings, orders, commissions, payouts, disputes, and platform analytics. Supports complex multi-party transactions with proper audit trails.

Comments

Loading comments...