1CREATE TABLE IF NOT EXISTS billing_subscriptions (
 2    id SERIAL PRIMARY KEY,
 3    created_at TIMESTAMP WITHOUT TIME ZONE NOT NULL DEFAULT now(),
 4    user_id INTEGER NOT NULL REFERENCES users(id) ON DELETE CASCADE,
 5    stripe_customer_id TEXT NOT NULL,
 6    stripe_subscription_id TEXT NOT NULL,
 7    stripe_subscription_status TEXT NOT NULL
 8);
 9
10CREATE INDEX "ix_billing_subscriptions_on_user_id" ON billing_subscriptions (user_id);
11CREATE INDEX "ix_billing_subscriptions_on_stripe_customer_id" ON billing_subscriptions (stripe_customer_id);
12CREATE UNIQUE INDEX "uix_billing_subscriptions_on_stripe_subscription_id" ON billing_subscriptions (stripe_subscription_id);