[UPHPU] Database Conventions

Kyle Waters unum at unum5.org
Wed Jan 9 14:46:24 MST 2008


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


More information about the UPHPU mailing list