Databases

Stripe-Style Subscription & Usage Billing Schema

ER Diagrams · made in Skemio

ER diagram connecting customers, subscriptions, subscription items, usage records, invoices, and invoice line items.
ER diagram connecting customers, subscriptions, subscription items, usage records, invoices, and invoice line items.
Open it in SkemioMake your own

What it shows

  • Decouple fixed subscription items from continuous usage meter aggregation.
  • Usage records append events; billing cycles aggregate units asynchronously.
  • Invoices seal lines with immutable unit prices upon cycle close.

The takeaway

Aggregate high-frequency usage records asynchronously into invoice line items at cycle boundary.

More er diagrams