1
0 Comments

What is the best SQL table layout for stripe payments?

I would like to add a payment plan page to my site and I have decided to go with stripe as the processor, but I'm not sure which SQL columns to include
I plan to offer 3 price plans and a free plan (4 plans).
I read that stripe handles discount codes so I’m not sure if I need a coupon SQL table for that.

I may be completely off but this is what I came up with based on my research. I know many people use Stripe on indiehackers I know this would be the best place to get some advice. Please help.

Plan
id | plan_type | plan_period | plan_status

Coupon
id | userid | created | expires | coupon status

on May 9, 2021