Subscriptions
Manage the subscriptions of your SaaS customers
Last updated
Manage the subscriptions of your SaaS customers
Last updated
When a new subscription is created or updated, a record in the UserPlan
table is created or updated. That is where the subscription of your users lives.
Remember that only one subscription can exist for a user and that the user must exist in the User table when the subscription or order is created.
The file prisma/schema.prisma
already contains tables to manage the subscription plans of your SaaS. Those tables are SubscriptionPlan
, PlanProperty
, and UserPlan
, let's see how they are used.
This table must contain all the subscription plans you create in Lemon Squeezy.
Its columns are:
You can add new records by running npx prisma studio
in the terminal, it will run the database client UI at http://localhost:5555/.
To generate random cuids, you can use the CUID Generator of Shipped.
If you have a free plan, you can create a record for it as well.
When you have subscription plans in your SaaS, each plan will probably have some limits and properties. This table is intended to save those properties for each Subscription Plan.
Here's an example.
For each plan you can create a record in the table PlanProperty
, like this:
UserPlan is the table in which are stored the subscription plans purchased by your customers.
The records are automatically inserted and updated by the webhook /api/webhooks/lemonsqueezy
but it might happen that you need to manually update it, for any reason.
This table is intended to contain only one record for each user (no multiple plans are allowed).
Plan | Screenshots | planId |
---|---|---|
id | planId | propertyName | value |
---|---|---|---|
Free
10/month
thlx5o9ds0m8s8g9p8e7utvo
Hobby
500/month
hjtmghruw3tw68x6daxqgwhu
Pro
1000/month
rgiy096elb1s4fsauug9qamf
123
thlx5o9ds0m8s8g9p8e7utvo
MAX_SCREENSHOTS
10
234
hjtmghruw3tw68x6daxqgwhu
MAX_SCREENSHOTS
500
345
rgiy096elb1s4fsauug9qamf
MAX_SCREENSHOTS
1000