NYCPHP Meetup

NYPHP.org

[nycphp-talk] Database, table, and column naming schemes

Kristina Anderson ka at kacomputerconsulting.com
Tue Oct 6 12:38:26 EDT 2009



> On Tue, 6 Oct 2009, David Krings wrote:
> 
> > There 
> > really is no need to store the same piece of data more than once in 
a 
> > database.
> 
> But a table descrbing a manay-to-many could just contain foreign keys.
> 
> 
> 
> -- 
> Aj.
> 
> 

Exactly, the table would contain probably nothing more than a primary 
key autonumber field, the user id and account id in each row.

Creating a view is an option, but I have concerns about how it would 
scale in a situation where a lot of accounts were being created.



Kristina

Kristina



More information about the talk mailing list