Re: [UPHPU] Database Conventions

[Kyle Waters]

Ray Hunter wrote:
    users_first_name
    users_last_name
I haven't been appending the table name to the columns, but now I wish I 
had.  so when I do joins I wouldn't have to do as statements since they 
would already have unique names.

If I'm doing a foreign key I like to use the same name (ie user_index) 
so that I can do natural joins.

Kyle

_______________________________________________

UPHPU mailing list
UPHPU@uphpu.org
http://uphpu.org/mailman/listinfo/uphpu
IRC: #uphpu on irc.freenode.net