Differentiating Database Data by Client for Jira Cloud Plugin

[Ali Türkkan]

Hi,

We want to release a Jira Cloud Plugin on Heroku. In this sense, we opened an application on Heroku and created a postgresql database. We used a single database in our developments. However, we need to keep the data of each customer separately while we are going live our application. For this process, we have separated data by Jira base URL, but there is no guarantee that this URL will not change.

Our current database structure;
 Table1
    column1
    column2
    ...
    baseUrl
 Table2
    column1
    column2
    ...
    baseUrl

In this structure, we separate the data of each customer according to the baseUrl. However, this solution is unreasonable and unreliable. Is there a way to keep each customer's data separate in the database? We could not find a definitive solution to the problem in our research. We wanted to get your thoughts on this.