Look at any subscription mailing list from any journal, and you can get an idea of ββwhat data you will have to record. The start and end dates of the subscription will be a good thing to keep and which plan the user subscribes to. When you have an end date, you just need to run a query to get the records of users who have access. Sort of
Select * from users where subscription_end_date is >= today
I'm sure there will be many other columns in your final product, but it's up to you what data you want to keep. What are the different subscription states? Can anyone sign up for both services at the same time?
source
share