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: 236
        
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