I want to create an application similar to basecamp or mailchimp. The customer registers him self and then sets up the application for themself automatically. The application will be developed using cakephp.
My question is what is the best DB structure?
- All customer separated by customer id in one table.
- Every customer with own DB + DB User.
- Use for every one an SQLite file in his folder.