How to implement a paid subscription system?

Question

Database design

Hello. It is required to implement a system of paid subscriptions. How to implement this in terms of the database?
I had an idea to make 2 tables: with all possible subscriptions and with those already issued, but I don't understand how to store the rights for each of the subscriptions.

Answer 1

1. Table of all criteria: id, min, max, desc
2. Table of restrictions (permissions):
id, "depends on the restriction (parent):ID", "criteria1:ID", ..., "criteriaN:ID", ACL
3. Table of access rights to resources:
id, itemID, typeID, ACL
4. Table of paid user subscriptions: id, "parental restriction:ID", userID
, expiredAt (when expires)
the desired restriction for subscriptions (clause 2).
Based on the subscription id of the user restriction (item 4), we find the id of the restriction (item 2).
Then, we check the summary ACL and the subscription expiration date.
Then - everything else according to the criteria and restrictions.

Answer 2

An intermediate table from a many-to-many relationship. You can name subscriptions or orders.