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
database
|database-design
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