api.spaceplanner.app

Spaceplanner API
git clone git://jacobedwards.org/api.spaceplanner.app
Log | Files | Refs

2024-08-31T17:08:02.sql (354B)

      1 CREATE TABLE spaceplanner.subscriptions (
      2 	-- Stripe subscription id
      3 	id varchar PRIMARY KEY,
      4 
      5 	-- Stripe customer id
      6 	customer_id varchar
      7 		REFERENCES spaceplanner.users(stripe_customer_id)
      8 		ON DELETE CASCADE
      9 		NOT NULL,
     10 
     11 	-- Stripe price id
     12 	price_id varchar NOT NULL,
     13 
     14 	-- Stripe product id
     15 	product_id varchar NOT NULL,
     16 
     17 	active boolean NOT NULL
     18 );