jdlev Posted July 8, 2013 Share Posted July 8, 2013 I'm trying to decide how to setup user access to account information. So you have a universal table for user login information that associates that user with an account. That user only has access to that particular accounts information. Now lets say that user has a company address. Should I have another universal table where every account's company address is saved to the same table, but they can only access/edit their own address My_Database -Universal_Address_Table ---Address Company A record(only company A can see) ---Address Company B record (only company B can see) -OR- Should each account have it's own table for the addresses associated with it, so every account would have multiple iterations of the same structured table. My_Database ---Company_A_Address_Table ---Company_B_Address_Table So is one method more secure than the other? Is there a limitation on how much information MySQL can handle, because I'm hoping for a few hundred if not thousand accounts? Link to comment https://forums.phpfreaks.com/topic/279970-database-table-organization/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.