Using Multiple Databases

Posted by sergiuoala on Stack Overflow See other posts from Stack Overflow or by sergiuoala
Published on 2012-12-18T23:01:48Z Indexed on 2012/12/18 23:02 UTC
Read the original article Hit count: 159

Filed under:
|

A company is hired by another company for helping in a certain field.

So I created the following tables: Companies: id, company name, company address Administrators: (in relation with companies) id, company_id, username, email, password, fullname

Then, each company has some workers in it, I store data about workers. Hence, workers has a profession, Agreement Type signed and some other common things.

Now, the parent tables and data in it for workers (Agreement Types, Professions, Other Common Things) are going to be the same for each company.

Should I create 1 new database for each company? Or store All data into the same database?

Thanks.

© Stack Overflow or respective owner

Related posts about database

Related posts about database-design