Shopify

Production-grade database schema for a Shopify-like e-commerce platform featuring multi-store management, product catalog with variants and images, inventory tracking, order lifecycle management, fulfillment, payment processing, and discount engine.

PostgreSQL15 tablesE-Commerce

e-commercemulti-tenantinventoryfulfillmentpayments

Tables in this template

shopsShops

10 cols

usersUsers

8 cols

customersCustomers

10 cols

addressesAddresses

11 cols

productsProducts

11 cols

product_variantsProduct Variants

12 cols

product_imagesProduct Images

8 cols

inventory_levelsInventory Levels

7 cols

ordersOrders

16 cols

order_itemsOrder Items

10 cols

fulfillmentsFulfillments

9 cols

fulfillment_itemsFulfillment Items

6 cols

discount_codesDiscount Codes

10 cols

collectionsCollections

9 cols

collection_productsCollection Products

6 cols

Related Templates

View all templates →

E-Commerce Platform

Complete database schema for an online store with products, orders, customers, payments, and inventory management.

PostgreSQL12 tables

e-commerceshoppingpayments+2

E-Commerce

Multi-Vendor Marketplace

Database schema for a multi-vendor marketplace with stores, products, orders, reviews, and seller payouts.

PostgreSQL11 tables

marketplacemulti-vendore-commerce+3

E-Commerce

Subscription Box Service

Database schema for a subscription box service with recurring plans, curated boxes, and shipment tracking.

PostgreSQL10 tables

subscriptionrecurringbox+3

E-Commerce

Digital Product Store

Database schema for a digital product marketplace with creators, licenses, downloads, and customer reviews.

PostgreSQL10 tables

digitaldownloadslicenses+3

E-Commerce