Hi I've got a small internal project I am working on. Currently it only serves my company, but I'd like to scale it so that it could serve multiple companies. The tables I have at the moment are
Project Number | Title | exacttarget_id | Author | Body | Date
Name | Email | Date Created | Password
What I would do is create 2 tables:
I would create one table for the different companies, lets call it
Company_id | Title | Logo | (Whatever other data you want)
I would also create one table for the settings listed above, lets call it
Company_id | Key | Value
This gives you the flexibility in the future to add additional settings without compromising your existing code. A simple query gets all the settings, regardless of how many your current version uses.
SELECT Key, Value FROM COMPANY_SETTINGS WHERE Company_id = :companyId
Te results can then be put into an associative array for easy use throughout the project.