-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 [EMAIL PROTECTED] wrote: | I'm just curious, What naming conventions for DB tables do you | use?
this is a biggy :-) a lot of php developers that work with mysql, a non relational db use pk names of ID.... I always name the pk of table (table_name)_id... I also tend to prefix ~ column names with an abbreviation of the table name, it makes life easier as there is more information there and when you start joining tables, there is less conflict if u use common naming conventions z -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.6-2 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAj0HWKMACgkQm98oI6K7h0gxUQCgjUvOt0+YVHgz/Qyh8RlAawAp CrwAoOwShhA1t7xZpiKsaYQ3Cdz8Supo =YXc3 -----END PGP SIGNATURE----- ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists