Re: The only concern is whether referenced tables can be partitioned?

[Rick James]

One of us is quite confused. I will assume you are confused about the meaning of "partition". Partitioning that is discussed in this forum has to do with a way of splitting up a "table" into "partitions".

Are you are providing a service where different clients get different datasets, and you don't want them to see each other's data (for security reasons)? This is how I would intepret "information for a specific client". For this you really need to have separate databases.

If you are splitting data _about_ each client, then a "client_id" column can say which client this row is referring to.

Neither of these interpretations involve "partitions".

(Sorry that the English language is so tricky.)