Database payment Subscription Logic

I’m having a Database with kinda subscription. People pay via Stripe. Now I have two tables: t_payment and t_user. Now for eg. if a User makes a payment for 1 year, then that payment should go into the t_payment and fill up the column validtill with date+365 days or similar. With that design I have a history off all payments and TX ids. Or do you have any other ideas or experience in doing that?

A sample would look like that:

Sidequestion: I have prive_with_vat, price_no_vat etc completely separated but does it make sense?

Community Page
Last updated: