For those looking for a book: Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design by Michael J. Hernandez
http://www.amazon.com/exec/obidos/ASIN/0201694719 On Wed, 12 Jun 2002, Joshua Miller wrote: > We usually do something like so: > > Stored Proc: sp_whatever > Views: vw_whatever > Tablename: tblUsers, tblPermissions, etc. > Fields: Always prefixed with table-related text as such: > userID (PK/ID) > ufirstname > ulastname > uaddress1 > uaddress2 > ucity > ustate > uzip > etc. > > That just makes it easier for me to see what field is related to what > table - especially when you have similar data in multiple fields (which > we try to avoid by abstracting the database as much as possible - but > sometimes is necessary). > > There may be a better way or a more suitable way for your programming > style. > > Joshua Miller > Web Development :: Programming > Eagle Web Development LLC > www.eaglewd.com > [EMAIL PROTECTED] > (304) 622-5676 (Clarksburg Office) > (304) 456-4942 (Home Office) > > > -----Original Message----- > From: Zac Spitzer [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, June 12, 2002 10:20 AM > To: CF-Talk > Subject: Re: DB Table Naming Conventions > > > -----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----- > > > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
