I am developing an application that includes financial accounting.
Should I store data for multiple companies in a single Database?
Is it possible to apply a filter on a single field say company_id in all data tables globally so that I may operate a single company at a time. I want to avoid including this condition in each & every where clause throughout the application. I also need to generate some combined reports, where data from multiple companies would be required.