Hi, I use the Leszynski/Reddick conventions when programming front ends. We have made changes to the table definitions, so that the prefix refers to the table instead. The example would look like this:
tblNews newID newusrID newPosted newSubject newContent tblUser usrID usrnewID usrName This gives the very nice property that every field in the database is unique, which again means that you can skip most table references. I only skip table references for readability. Eg. SELECT usrName, newSubject FROM tblNews INNER JOIN tblUser ON usrnewID = newID Cheers Mikkel -----Original Message----- From: howard gramer [mailto:[EMAIL PROTECTED]] Sent: Monday, 22 October 2001 11:40 AM To: [EMAIL PROTECTED] Subject: Re: Field Naming Standards ummm, is there any thing wrong with using the Naming Convention devloped by Stan Leszynski and Greg Reddick, authors of Access 97 books? Their conventions would creat this: tblNews intpkNewsID intfkUsersID datPosted varSubject txtContent blnBoolean tblUsers intpkUsersID intfkNewsID varName pk = primary key fk = foreign key The capitals are my preference. ----- Original Message ----- From: "Mike E" <[EMAIL PROTECTED]> To: "ryc" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Saturday, October 20, 2001 3:36 PM Subject: Re: Field Naming Standards > That seems to follow how I've been doing it as well. > > For example, consider this database set up: > > Table: news > Fields: > newsid int(10) > userid int(10) > dateposted datetime > subject varchar(255) > content text > > Table: users > Fields: > userid int(10) > name varchar(60) > > and on and on. I'd love to hear from some hard-core developers. Guys > who have been doing database development professionally for years. > > Mike > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php