Skip to content

Subscriptions Schema

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


Subscription plan definitions with Stripe integration.

ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
instructor_iduuidNO—
titletextNO—
slugtextNO—
descriptiontextYES—
pricenumericNO—
intervaltextNO'monthly'
featuresjsonbNO'[]'
stripe_price_idtextYES—
statustextNO'draft'
subscriber_countintegerNO0
published_attimestamptzYES—
created_attimestamptzNOnow()
updated_attimestamptzNOnow()

Courses included in a subscription plan.

ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
plan_iduuidNO—
course_iduuidNO—
created_attimestamptzNOnow()

Active subscription members.

ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
plan_iduuidNO—
subscriber_iduuidNO—
instructor_iduuidNO—
payment_iduuidYES—
stripe_subscription_idtextYES—
statustextNO'active'
current_period_starttimestamptzNO—
current_period_endtimestamptzNO—
cancelled_attimestamptzYES—
created_attimestamptzNOnow()
updated_attimestamptzNOnow()