Design DB to Implement Subscriptions using Razorpay

Need help Database
1

Hi,

Guys, I need your help.
I am implementing monthly subscriptions in my app. I am using razor pay to achieve this.

Right now, I am using their APIs to create subscriptions and using webhooks I am capturing all the payment and subscription events information and storing them in a subscription table. This table has all the information from when subscription starts till its completion.

image
image994×490 22 KB

All the above records will be for a single user.

My question is whether this structure is good enough and scalable, or should I design my DB differently?

Another approach which I am thinking of is to have this table as is and store subscription status, start date and end date in user table and use them when needed.

Thanks,
Ram.

2

Only one object tracks everything?

3

What do you mean by one object?

Currently, whenever an event happens I am storing all the information in a table.

4

When you say table you are referring to one data type with all of the fields right?

5

Yes. This is the table structure

image
image571×819 8.37 KB

6

Flat objects scale well :+1:t2:

1 Like
7

Thank You.

To check user’s subscription status, would you recommend storing subscription status, subscription period in user table?

8

I would recommend

  • Setting privacy rules
  • Place heavy data in a satelliteObject, as well as, confidential data
  • Just place fields on the object that will be displayed on RGs …. the rest to satellites
1 Like
9

hi @tech16 , i have some questions regarding razorpay integration. can we connect?