How to make a subscription system for a telegram bot on telebot with sqlite3?

Question

Bots

I have a payment via telegram, I first need to enter the user id in the database and the time for which time he bought a subscription, then check if there is a person in the database to give access to the message thread, I use the telebot library with the sqlite3 database
if
the user presses start and selects Soft, there are several options to choose from, free and paid, the user selects a paid one, but it is not in the database, the bot offers to buy him a subscription for 1d, 1n, 1m,
the user goes and pays, the bot writes the user to the database. after the expiration of time, it deletes
I don’t know how to do it, I tried to study it, but it wasn’t what I needed