My company is designing a database in which we intend to store data for several customers. We are trying to decide if,
A: we want to store all customer data in one set of tables with customer_id fields separating the data or, B: storing each customers data in a separate schema.
I'd like to get some opinions on the pros and cons of these methods concerning maintainability, scalability, and performance.
