Database Table Management

I’m confused as to why separate tables are needed. If the goal is to use separate encryption keys for each client, that can be done with a single table that has a client field to tell you which client the row belongs to. The row data will decrypt only with that client’s key.

Is there a regulatory need for separate tables?

There is a feature request for being able to create data tables with code ( Create Data Tables with Code - #11 by splinter ), but as far as I know there’s no way to do it yet.

1 Like