xionhack Posted December 9, 2013 Share Posted December 9, 2013 Hello. In my business logic, I have a user, a company (users can be part of the company) and products. A product can be owned by a user or by a company, the company can assign it to a user later, but it would still be owned by the company (in case the company fires the user). My thought is to have the user table, the company table and the product table. I'm thinking about having a product_owner table, where I would have product_id, user_id, company_id, agent_assigned. If the product is owned by a user then only product_id and user_id will be filled. If it's owned by a company, then product_id, company_id and agent_assigned would be filled. Is this the best way to do it? It doesn't seem good to me. Quote Link to comment https://forums.phpfreaks.com/topic/284655-best-way-to-do-this-database-design/ Share on other sites More sharing options...
dakota367 Posted January 6, 2014 Share Posted January 6, 2014 Can a user be a part of multiple companies? Quote Link to comment https://forums.phpfreaks.com/topic/284655-best-way-to-do-this-database-design/#findComment-1464022 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.