[null, {"document_url": "http://www.nathanhammond.com/the-subscription-library-schema-to-rule-them-all", "unformatted_src": "http://www.nathanhammond.com/user/files/subscription.png", "src": "http://www.nathanhammond.com/user/files/subscription.png", "formatted_filename": "subscription", "alt_text": "A database schema for modeling any type of subscription."}, null]

Have you ever hacked together a billing system for a web application you were building? Did you later change your mind about how you wanted to monetize the application but couldn’t because it was hardcoded? Are you tired of interfacing with terrible payment providers? Did your billing system implode on February 29, 2012?

Well, good news! After reviewing just about every type of subscription that I could find, I believe that I’ve come up with all the information needed to model each of them. For the low, low, price of free (as in speech and beer!) I present the (fully untested, semi-normalized, highly speculative) subscription library schema to rule them all: However, this is merely a stepping stone on the path to subscription billing bliss. I’ve not actually started the long and terribly arduous task of writing code to support this schema and as such I can assure you that it will change. But sticking with the infomercial theme, coming soon to a SaaS application you will write:

What do you think? Have I missed anything?

One thought on “The Subscription Library (Schema) to Rule Them All”
