logo
ExamplesEditorPricingDocs
37.1kSign in

Subscription box database schema

How recurring physical commerce is modelled: plans and subscriptions, one row per billing cycle, preferences that drive curation, per-cycle box contents, shipments, skips and pauses, churn reasons and referral credit.

Subscription Box ER diagram

Subscription box database schema n1 n1 n1 n1 n1 n1 n1 n1 n1 11 n1 n1 n1 11 n1 n1 n1 members idBIGINT emailVARCHAR full_nameVARCHAR shipping_addressJSONB timezoneVARCHAR referral_codeVARCHAR statusVARCHAR created_atTIMESTAMPTZ plans idBIGINT codeVARCHAR nameVARCHAR interval_unitVARCHAR interval_countINTEGER price_minorINTEGER currency_codeCHAR items_per_boxINTEGER cutoff_days_beforeINTEGER activeBOOLEAN subscriptions idBIGINT member_idBIGINT plan_idBIGINT statusVARCHAR next_cycle_dateDATE paused_untilDATE payment_method_re…VARCHAR started_atTIMESTAMPTZ cancelled_atTIMESTAMPTZ billing_cycles idBIGINT subscription_idBIGINT cycle_numberINTEGER period_startDATE period_endDATE ship_dateDATE skip_deadlineDATE statusVARCHAR amount_minorINTEGER credit_applied_mi…INTEGER currency_codeCHAR charge_referenceVARCHAR billed_atTIMESTAMPTZ member_preferences subscription_idBIGINT attributeVARCHAR valueVARCHAR is_hard_constraintBOOLEAN updated_atTIMESTAMPTZ products idBIGINT skuVARCHAR nameVARCHAR brandVARCHAR attributesJSONB unit_cost_minorINTEGER on_handINTEGER available_fromDATE available_untilDATE cycle_items idBIGINT billing_cycle_idBIGINT product_idBIGINT skuVARCHAR nameVARCHAR quantityINTEGER unit_cost_minorINTEGER selection_reasonVARCHAR shipments idBIGINT billing_cycle_idBIGINT carrierVARCHAR tracking_numberVARCHAR address_snapshotJSONB statusVARCHAR shipped_atTIMESTAMPTZ delivered_atTIMESTAMPTZ subscription_events idBIGINT subscription_idBIGINT event_typeVARCHAR billing_cycle_idBIGINT effective_dateDATE detailJSONB created_byVARCHAR created_atTIMESTAMPTZ cancellation_reasons idBIGINT codeVARCHAR labelVARCHAR categoryVARCHAR is_recoverableBOOLEAN positionINTEGER cancellations subscription_idBIGINT reason_idBIGINT commentVARCHAR last_cycle_idBIGINT winback_offer_codeVARCHAR winback_acceptedBOOLEAN cancelled_atTIMESTAMPTZ referrals idBIGINT referrer_idBIGINT referred_member_idBIGINT code_usedVARCHAR statusVARCHAR qualified_atTIMESTAMPTZ created_atTIMESTAMPTZ credits idBIGINT member_idBIGINT sourceVARCHAR referral_idBIGINT applied_to_cycle_…BIGINT amount_minorINTEGER currency_codeCHAR expires_atDATE created_atTIMESTAMPTZ

Related database schemas

PostgreSQL
Commerce

Amazon-style marketplace database schema

How a marketplace models many sellers listing the same product: a shared catalogue, competing offers, the buy box decision as a log, orders split into per-seller sub-orders, fulfilment, payouts and product-level reviews.

PostgreSQL
Commerce

E-commerce store database schema

A production-shaped e-commerce schema: products with variants, inventory per location, carts, orders with snapshotted line items, payments and shipments. Open it in the editor or export SQL for six dialects.

MySQL
Commerce

Etsy-style handmade marketplace database schema

How a handmade marketplace models its data: shops and sections, made-to-order listings with variations and personalisation, cross-shop carts, orders split per shop, shipping profiles and photo reviews.

MySQL
Commerce

Retail point of sale database schema

How an in-store point of sale is modelled: stores and registers, cashier shifts with opening float and closing count, sales with discounted lines, multi-tender payment, returns against the original sale, drawer movements and approved price overrides.