What I’m trying to do:
I am trying to create a dynamic management app whereby the main database can be used by 1…m users who manage a Client. Should a new Client be added, then this would in effect require a new table to be created dynamically so that a user-journey whereby user creates a new Client and therefore the Client info is kept in a seperate table to different Clients. The purpose for this is to segregate client data so that we can apply encryption for compliance reasons and therefore use seperate keys per client. Currently this feature to create new tables to the existing DB doesn’t seem evident?
What I’ve tried and what’s not working:
Search all of the Documentation and here on the forum so asking out load on a suggestive approach to my problem?