Subscriptions Schema

ext_subscriptions - Subscriptions

Schema: ext_subscriptions | Auto-generated on 2026-03-30

---

plans

Subscription plan definitions with Stripe integration.

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
instructor_id	uuid	NO	—
title	text	NO	—
slug	text	NO	—
description	text	YES	—
price	numeric	NO	—
interval	text	NO	'monthly'
features	jsonb	NO	'[]'
stripe_price_id	text	YES	—
status	text	NO	'draft'
subscriber_count	integer	NO	0
published_at	timestamptz	YES	—
created_at	timestamptz	NO	now()
updated_at	timestamptz	NO	now()

plan_courses

Courses included in a subscription plan.

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
plan_id	uuid	NO	—
course_id	uuid	NO	—
created_at	timestamptz	NO	now()

members

Active subscription members.

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
plan_id	uuid	NO	—
subscriber_id	uuid	NO	—
instructor_id	uuid	NO	—
payment_id	uuid	YES	—
stripe_subscription_id	text	YES	—
status	text	NO	'active'
current_period_start	timestamptz	NO	—
current_period_end	timestamptz	NO	—
cancelled_at	timestamptz	YES	—
created_at	timestamptz	NO	now()
updated_at	timestamptz	NO	now()