How is the system and architecture of paid subscriptions built?

Question

Database design

Good afternoon!

How is the system of paid subscriptions built and what should (usually) their business logic be?

I think it's mandatory:

• Creation of the `Orders` table.
  
• Creating a `Subscriptions` table - where we store subscription plans .
  

Questions:

• What tables are created to implement paid subscriptions?
  
• How do we check if a user has a subscription and from which table do we read it?
  
• If the user already has a subscription, when signing up for another one, do we simply renew the current one or create a record that will be created from the expiration date of the previous subscription?
  

Enlighten please!
The more information, the better!

Thank you!