What about a "prefix" column, and filter all selects on the prefix. A single database ctructure sounds more scalable and logically you're partitioning the data based on login or context. Prefixing table names doesn't sound like a good idea.
--
What about a "prefix" column, and filter all selects on the prefix. A single database ctructure sounds more scalable and logically you're partitioning the data based on login or context. Prefixing table names doesn't sound like a good idea.
--