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.