Back to Home
ERD Studio
Browse Templates/Subscription Box Service

Subscription Box Service

A complete subscription box service database schema for businesses like Birchbox, HelloFresh, or Loot Crate. Includes subscriber management with flexible recurring plans, curated box assembly with individual item tracking, shipment lifecycle management, and subscription lifecycle handling with pause/cancel support. Designed for subscription commerce platforms that ship physical goods on a recurring schedule.

PostgreSQL10 tablesE-Commerce
subscriptionrecurringboxshipmentse-commerceplans
Created with ERD Studio

Tables in this template

subscribersSubscribers
9 cols
plansPlans
9 cols
subscriptionsSubscriptions
9 cols
subscription_pausesSubscription Pauses
6 cols
boxesBoxes
8 cols
box_itemsBox Items
5 cols
productsProducts
11 cols
shipmentsShipments
10 cols
paymentsPayments
10 cols
reviewsReviews
8 cols

Related Templates

View all templates →

Shopify

Clone

E-commerce platform with multi-store support, product variants, fulfillment, and discounts

PostgreSQL15 tables
e-commercemulti-tenantinventory+2
E-Commerce

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

Digital Product Store

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

PostgreSQL10 tables
digitaldownloadslicenses+3
E-Commerce
Subscription Box Database Schema Template | ERD Studio