How to properly structure a database?

Question

MySQL

Good afternoon.
Online course website. How to correctly implement the structure of the database?
User (user):

id,
name,
email,
password
created_at,
updated_at

The user after registration can get a "trial version" (trial) for 7 days.
After the end of the trial period, you will have to buy one of the tariff plans.
How to implement all this correctly? Where to record trial, payments, tariff plans?
I will be glad to have a detailed answer from you!)
Thank you very much in advance!

Answer 1

why write it down where? You have created_at, so 7 days trial is a matter of mathematics, and not a separate column in the database
tariff plans and payments will obviously be in the corresponding tariff and payment tables, and there will probably be tables that implement many to many relationships of the
payment_id type | user_id
The current tariff can also be calculated, not stored (not always, here you need to look at the business model)