I have searched a lot in SO and SE but I did not get anything particularly about this kind of database design with coupon codes included. Please take a look at this problem.
I am developing a website in which I sell a service. People buy this service in advance (Pre-paid).
I sell that service in four plans
Monthly plan,
3 months plan,
6 months plan and
yearly plan.
But as encouragement for people to use my service initially, I want to give them a free coupon code(One or more). So that they can redeem in their accounts and use.
Coupons codes can be
Monthly Coupon Code,
2 months Coupon Code,
3 months Coupon Code and so on.
Each account will have an account_id in the user table.
I am struggling a lot to link This subscription model to coupons and Plans. I am a beginner at this kind of database design. Put me in a correct path.
